How to export Outlook events to Google Calendar

This tutorial explains the steps required to export Outlook Calendar events to Google Apps Calendar. In order the transfer events from Outlook 2013 and 2010 to Google Calendar, you need to do the following

  • Export Outlook events in to CSV file.
  • Import CSV file with Outlook events in to Google Calendar.

Export Outlook Calendar Events

Let us take the following example with two calendar events in Outlook.

image

To export these events in to a CSV file, click the File menu then navigate to Open menu.

image

Click the Import option, and select Export to a file in Import and Export Wizard and click the Next button.

image

Choose the file type as Comma Separated Values (Windows)

image

Select the Calendar from which you want to export the events and click the Next button.

image

Enter a name for the export file and click Next button.

image

Then click the Finish button.

image

The following message window will be displayed for setting the date range and events that fall between these dates will alone be exported. Click the OK button to complete the export.

image

Import Calendar Events in CSV to Google Apps Calendar

Login to your Google Apps Account and launch the Google Calendar page. Click the Option icon and select Calendar settings from the list of available menus.

image

In the Calendar Settings page, click the Calendar tab and navigate to Create new Calendar section.

image

Click the Import Calendar link and select the CSV file that has the Outlook Calendar Events. Then click the Import button.

image

The following confirmation message with the Processed and Successfully imported events will be displayed as shown below.

image

When you navigate back to your Google Calendar, the imported events should be displayed.

image

In Category: Office 2010, Outlook 2010, Technical

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 3 Comments
  • TacoLou January 16, 2014, 9:45 pm

    Thanks for this! Easy and works well enough to get around my corporate lockdowns!

  • Robin B January 22, 2016, 10:09 pm

    After I have exported my calendar from outlook into a csv file and information need to import into Google Calendar is there including the “Where” column. When I import the csv file into Google calendar all fields import property except the where column. Nothing imports from that so all my room numbers are deleted. What am I doing wrong? I would appreciate an email back regarding this.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.