How to Export a Shared Mailbox Calendar to CSV or Excel in Outlook
Question details
The user needs a method to export calendar events from a shared Outlook mailbox into a CSV file or an Excel spreadsheet.

- Product
- Microsoft Outlook
- Device & OS
- not provided
- Scenario
- Extracting and saving shared calendar events for backup, reporting, or data analysis in a spreadsheet application.
- Observed behavior
- Outlook does not provide a direct export option for shared mailbox calendars in its native Import/Export wizard, requiring users to use a workaround.
Verify that you have the appropriate permissions to access, view, and copy the contents of the shared mailbox calendar before attempting to export.
Copy the Shared Calendar to Your Personal Mailbox and Export
This method is best for a full calendar export. By copying the shared calendar to your personal Exchange account, you can use Outlook's built-in export tool.
Outlook's Import/Export wizard only recognizes folders within your primary mailbox. To bypass this limitation, you must first duplicate the shared calendar into your personal account hierarchy.
Open Outlook, navigate to your Calendars, and select the shared calendar. Click on the 'View' tab, select 'Change View', and choose 'List'.
Right-click the shared calendar from the navigation pane and select 'Copy Calendar'. In the prompt that appears, select a folder under your personal Exchange account and click 'OK' to paste it.
Go to 'File' > 'Open & Export' > 'Import/Export'. Select 'Export to a file', click 'Next', choose 'Comma Separated Values', select the copied calendar folder, and follow the prompts to save your CSV file.
Copy and Paste Calendar Events Directly
Ideal for a small number of events or a specific date range, this method allows you to quickly paste calendar data directly into a spreadsheet.
Open and Analyze Your Exported Calendar CSV with WPS Office
Once you have exported your Outlook calendar to a CSV file, you need a reliable spreadsheet tool to view and format the data. WPS Spreadsheet is a fast, lightweight, and free alternative to Microsoft Excel that handles CSV and XLSX files perfectly.
- 1. Download and Install WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer.
- 2. Open the CSV File: Launch WPS Spreadsheet, click 'Open', and locate the CSV file you exported from your Outlook calendar.
- 3. Format and Save: Adjust the column widths, apply filters to your events, and save the document as a standard .xlsx file for better formatting retention.

Frequently Asked Questions
Why can't I directly export a shared calendar in Outlook?
Outlook's native Import/Export wizard is designed to only process folders and data that reside within your primary Exchange mailbox. It does not recognize or list shared mailboxes or external calendars, which is why copying the calendar to your local account is required first.
How do I export only a specific date range from the shared calendar?
Before exporting or copying, change your calendar view to 'List'. You can then use the Outlook search bar or the 'View Settings' filter to display only the events within your desired date range. Once filtered, you can select all visible items and copy them directly into your spreadsheet.
Will recurring events be exported correctly to CSV?
When exporting to CSV via the Import/Export tool, recurring events are often exported as a single master item with recurrence rules, rather than individual daily occurrences. To see every single instance, it is better to view the calendar in List form, expand the date range, and copy-paste the visible items.




