outlook导出的csv
There are times when it can be useful to see all of the events in your calendar at once. Outlook lets you export all of the events between two dates into a single CSV file. Here’s how it all works.
在某些情况下,一次查看日历中的所有事件可能会很有用。 Outlook使您可以将两个日期之间的所有事件导出到单个CSV文件中。 这就是全部的运作方式。
Want to know how many pointless meetings Chad from Marketing has invited you to in the last year? Wondering when the last time your supervisor had a one-to-one with you was? Maybe you just want to do some analytics on your time spent so you can see where the days go?
是否想知道市场营销部门的查德(Chad)在去年邀请了您多少次无意义的会议? 想知道上次与您的主管进行一对一交流的时间是什么? 也许您只是想对所花费的时间进行一些分析,以便了解日子的流逝?
Whatever the reason, a spreadsheet that can be searched, sorted, and filtered—or pumped into an analytics app like Power BI—is often the best way to analyze data and find the information you’re looking for.
无论出于何种原因,可以搜索,排序和过滤电子表格(或将其加载到Power BI等分析应用程序中)通常是分析数据和查找所需信息的最佳方法。
Outlook makes it easy to export your calendar into a comma-separated values (CSV) file that can be opened in Excel, Google Sheets, or any data analysis package.
Outlook使您可以轻松地将日历导出到逗号分隔值(CSV)文件中,该文件可以在Excel,Google表格或任何数据分析包中打开。
To export your calendar, open Outlook and then click File > Open & Export.
要导出日历,请打开Outlook,然后单击文件>打开和导出。
Choose the “Import/Export” option.
选择“导入/导出”选项。
In the Import and Export Wizard that opens, select “Export to a file” and then click “Next”.
在打开的导入和导出向导中,选择“导出到文件”,然后单击“下一步”。
Select “Comma Separated Values” and click “Next”.
选择“逗号分隔值”,然后单击“下一步”。
Now, select the “Calendar” option in the folder list and click the “Next” button.
现在,在文件夹列表中选择“日历”选项,然后单击“下一步”按钮。
Choose a location and filename for your CSV file and then click “Next”.
选择CSV文件的位置和文件名,然后单击“下一步”。
Finally, click the “Finish” button. This is the end of the export wizard, but because you’re exporting a calendar, you’ll be given the option to choose the start and end dates for the data you want before the export starts.
最后,单击“完成”按钮。 导出向导到此结束,但是由于要导出日历,因此可以选择在导出开始之前为所需数据选择开始日期和结束日期。
Choose a date range and then click the “OK” button. Every appointment within that date range will be exported.
选择一个日期范围,然后单击“确定”按钮。 该日期范围内的每个约会都将被导出。
A panel with a progress bar will open. Depending on the length of the date range and the number of appointments, the export could take anything from a few seconds to a few minutes.
带有进度条的面板将打开。 根据日期范围的长度和约会的数量,导出可能需要几秒钟到几分钟的时间。
Once the progress panel has closed, the export will be finished. Navigate to where you saved the CSV and open it in your desired program. You’ll see data on every appointment in your calendar within the date range you chose.
进度面板关闭后,导出将完成。 导航至保存CSV的位置,然后在所需程序中将其打开。 您会在所选日期范围内看到日历中每个约会的数据。
The data includes more than we’ve shown here. Meeting organizer, Attendees, Location, Category, Sensitivity, and other information are all included. Now you can do all the data analysis you want.
数据包含的内容超出了我们在此处显示的内容。 会议组织者,与会者,位置,类别,敏感性和其他信息均包括在内。 现在,您可以进行所需的所有数据分析。
翻译自: https://www.howtogeek.com/665358/how-to-export-an-outlook-calendar-as-a-csv-file/
outlook导出的csv