Export a shared Outlook Calendar to CSV
- mitchell.bird (Unlicensed)
Quickly export all calendar items from Outlook to Excel spreadsheet without the Import and Export feature. Please do as follows:
1. Open 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.