How to export calendar from Outlook to Excel spreadsheet?
A way for you to share your Outlook calendar with others is to export your Outlook calendar and then import it into other people’s Outlook calendar folder. But there is a question of how to export it. The following tutorials will let you know how to export your Outlook calendar to Excel spreadsheet.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.
The first method will introduce an easy to quickly export all calendar items from Outlook to Excel spreadsheet without the Import and Export feature. Please do as follows:
1. Shift the Calendar folder, and select the calendar which you will export to Excel.
2. Change the calendar view with clicking View > Change View > List. See screenshot:
3. Select all calendar items or multiple ones you will export to Excel.
Note: Holding the Ctrl key, you can select multiple nonadjacent items with clicking each item one by one; holding the Shift key, you can select multiple adjacent items with clicking the first one and the last one.
4. Right click the selected items, and select the Copy from the right-clicking menu.
5. Create a new workbook, right click a blank cell and select the Keep Text Only (T) button in the right-clicking menu. See screenshot:
6. Save and close the new workbook.
So for the selected calendar items are exported to a new workbook already.
1. Go to File > Open & Export > Import/Export. See screenshot:
2. In the opening Import and Export Wizard, Under Choose an action to perform, select Export to a file, and then click Next to continue.
3. In Export to a File dialog, please select Comma Separated Values, and then click Next. See screenshot:
Note: If you are using Outlook 2010 or earlier versions, please select the Microsoft Excel 97-2003 option directly.
4. Now, under Select folder to export from, select Calendar from Outlook Data File, and then click Next.
5. When the Export to a File dialog showing up, click Browse… button to select the destination of the file.
6. Browse and choose the destination where the file can be saved. Name the file and finally click OK to close the dialog.
7. When it turns to the previous Export to a File dialog, click Next to continue.
8. Now another Export to a File dialog popping up, click Finish to export your Outlook calendar. See screenshot:
9. In the Set Date Range dialog box, please specify the date range you will export calendar within, and click the OK button.
Note: If you are using Outlook 2010 or earlier versions, and you select the Microsoft Excel 97-2003 option in Step 3, the calendar has been exported as Excel workbook already. If you are using Outlook 2013 or higher versions, the calendar has been exported as a CSV file, and please go ahead with below step.
10. Now we have export the specified calendar as a CSV file. Please open the CSV file with Microsoft Excel, and then save the file as workbook.
Recommended Productivity Tools
- Complicated and repeated operations can be done a one-time processing in seconds.
- Forward multiple emails individually with one-click, and auto forward by rules.
- Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
- Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
- 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 1 years agoi am trying to export the comments i put in the appointment. what field is that? i take notes about future and past appointments and i would to export them in excel.
To post as a guest, your comment is unpublished.· 1 years agoIm trying to export shared calendars individually but it seems to only give me the one person calendar to export apart from own. I cant seem to get a list up of different names even though I have full sharing and editing rights on all calendars any suggestions
To post as a guest, your comment is unpublished.· 2 years agohow to export calendar to excel with command line
To post as a guest, your comment is unpublished.· 2 years agoin step 8 where you have 'map custom fields', I have my own 'user defined-fields in folder' I wish to export with the other fields, how do I get these fields in there?
To post as a guest, your comment is unpublished.· 1 years agoHi I have the same question, were there any reply for your question? I have my own user defined-fields which I wish to export with the other fields but I couldn't seem to get those exported.
To post as a guest, your comment is unpublished.· 1 years agoHi,
User Defined-fields can’t be mapped and
exported by Outlook’s Import/Export feature (the 2ed method I introduced in
If you need to export custom fields, you
can try the first method introduced in this article: add the custom filed in
the List view, and then copy all rows to Excel workbook.