chris - Fotolia

Q
Manage Learn to apply best practices and optimize your operations.

How to export an Outlook calendar and contacts

Transferring Outlook data such as calendar items to an Excel compatible file only takes a few clicks, but there are subtle differences between Windows and macOS platforms.

If you need to export an Outlook calendar or other information from the Microsoft Office application, there are some key differences between the supported versions. 

Microsoft currently supports four versions of Outlook for Windows and some have different ways to export Outlook data, such as contacts and calendar items. The Outlook export process has not changed drastically from Outlook 2013 onward compared to earlier versions of Outlook. But the newer versions are more full featured with the ability to export previously unobtainable items, such as meeting attendees.

Say you want to copy your contacts for import into a different email platform or maybe you need to manipulate data in your calendar in an Excel spreadsheet as part of a monthly report -- there's a relatively easy way to do it in Outlook. Check the instructions below to export your calendar items or contacts in CSV file format.

Export an Outlook calendar on Windows

Microsoft currently supports four versions of Outlook on Windows: Outlook 2010, Outlook 2013, Outlook 2016 and Outlook 2019. The basic export functionality is very similar across these applications, but in Outlook 2013 Microsoft significantly upgraded the look and enhanced the functionality of its email client when compared to Office 2010. Versions of Outlook after 2013 have little to no significant changes with the export process.

In this tutorial, we'll use screenshots from Outlook 2016 to transfer a calendar to a CSV file. The steps to export contacts from Outlook is nearly identical but with one minor change we will highlight.

To start, click File on the menu bar, which presents the window below:

Outlook 2016 calendar export
Click on the File menu to start, then select the Open & Export setting.

Next, click the Open & Export option to show another set of menu options on the right side. Click on Import/Export.

Outlook Import and Export Wizard
The Import and Export Wizard offers a number of actions, including the Export to a file option.

A new window will appear. Select Export to a file as shown above and then click Next.

On the next window, click Comma Separated Values and then click Next.

Outlook Export to a File
After selecting the Export to a File option, the next window will prompt for the data you want to export. You can select the calendar or choose to export contacts from this window.

On the next screen, click on Calendar as shown above and then click Next. If you want to export contacts, then select Contacts from the Outlook window.  

In the next window, click the browse button to choose the location for the exported file. Click Next to continue.

Map Custom Fields option
If you want to export more than the default Calendar data, select the Map Custom Fields button to choose more Outlook calendar data.

Click on the button Map Custom Fields to select the information to export. This will open the Map Custom Fields window.

Map Custom Fields window
If you want to alter the default fields from the exported file, use the Map Custom Fields window to modify the output.

The default output selects all available values in the calendar. To change this, click the Clear Map button on the right side to clear all fields and choose the values you want by dragging them from the left window to the right window. Once done, click the OK button to return to the previous screen. Click Finish.

Calendar date range
Outlook gives you the option to select the date range for the calendar data to export.

Before the export starts, you can select the date range. Outlook will offer a default range or you can adjust this and click OK.

After the export progress window closes, you can open the CSV file in Excel or another spreadsheet program.

Outlook for Mac calendar export process

On Macintosh systems, Microsoft supports Outlook for Mac versions 2016 and 2019.  Outlook for Mac differs from the Windows Outlook version in that it does not have an option to export to a CSV file. The only choice is to export to a PST or OLM file. According to Microsoft, it has received feature requests to export a spreadsheet-compatible file on macOS systems, but there are no immediate plans to develop the feature.

The steps to export a calendar from either supported version of Outlook for Mac are the same.

Outlook 2016 for Mac export menu
The calendar export process on Outlook 2016 for Mac contrasts slightly from the Windows version due to the different menu layout.

Click on the File menu item and select Export.

OLM archive format
Outlook 2016 for Mac systems only provides the OLM archive file format for calendar export.

A window will open to export to an archive OLM file. Select the Calendar type and then click Continue. After giving a name for the OLM file, the file will export.

Due to the nature of the OLM file type, this export process might not be useful for purposes other than to archive the data. There are third-party applications that claim to convert the OLM file to other formats, such as CSV, which might be the only option to import the data into a spreadsheet unless Microsoft develops a more comprehensive export feature.

This was last published in May 2019

Dig Deeper on Exchange Server setup and troubleshooting

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

2 comments

Send me notifications when other members comment.

Please create a username to comment.

Hi. Can you help me with something? I have exported my outlook calendar to excel but when I click on the excel file, the only data is column headings. There is actually data in any of the rows. Not sure how to troubleshoot this.
Cancel
What are some tools you use to help end users export data from Microsoft applications?
Cancel

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchSQLServer

SearchEnterpriseDesktop

SearchVirtualDesktop

Close