How to Export a Calendar as a CSV File in Outlook 2013

Many popular calendar applications and services let you export your calendar as an .ics file. This type of file is compatible with many programs, including Microsoft Outlook. If you have previously exported a calendar from someplace else and added it to Outlook, then it’s very likely that it was an .ics file.

But you may be looking for a way to view your calendar in Excel, as the spreadsheet format provides a lot of flexibility for managing and sorting data. Fortunately you are able to export an Outlook calendar file as a .csv file, which can then be opened and edited in Microsoft Excel. Our tutorial below will show you how to complete this process.

Do you have an Outlook signature that you would like to update? Find out how to add a picture to that signature.

How to Create a CSV from a Calendar in Outlook 2013

The steps in this article were performed in Microsoft Outlook 2013, but will work in other versions of Excel as well. When you complete the steps in this guide you will have a .csv file with all of the events and appointments in one of the calendars that you have in Outlook. That file can then be opened in Excel or other .csv-compatible programs so that you can view your calendar information in another format. This is a helpful alternative for viewing information from a Google Calendar file, for example, if you find the .ics file format to be less than helpful when opening it directly in Excel.

Want to simplify the process of sending emails to the same group of people? Outlook distribution lists are the perfect solution.

Step 1: Open Outlook 2013.

Step 2: Click the File tab at the top-left corner of the window.

open outlook file menu

Step 3: Select the Open & Export option in the left column.

create csv file from outlook

Step 4: Choose the Import/Export option.

outlook calendar export

Step 5: Click the Export to a file option, then click the Next button.

export outlook calendar as csv

Step 6: Select Comma Separated Values, then click Next.

can i open an outlook calendar in excel

Step 7: Select the Calendar to export, then click Next. Note that you may need to scroll down a little to find the calendars.

turn outlook calendar into spreadsheet

Step 8: Click the Browse button to choose the location on your computer where you want to save the exported calendar, then click the Next button.

convert outlook calendar to excel

Step 9: Click the Finish button to create the exported .csv file of your calendar. Note that if you have recurring appointments in your calendar you will need to specify the date range of those recurring appointments that you want to export, and Outlook will include them as separate appointments.

how to export calendar as csv from outlook 2013

Do you have another calendar that you would like to add to Outlook? Find out how to import .ics calendar files to Outlook such as those created by applications like Google Calendar.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy