Export Outlook Appointments to Google Calendar

This how-to is part of a larger series that I will be publishing in the coming weeks covering my switch from Outlook to Google’s online services. The intent of this series is to help others who have found themselves wanting more out of their email and calendar applications. This guide specifically covers the transfer of Outlook events to Google Calendar online. There are quite a few steps in this process so take your time and make sure that you follow it closely, this will ensure a successful transfer. If you know of an easier way to transfer your calendar information to Google or have any questions, please post them below.

Note: I used Outlook 2007 for this guide.

Export Outlook Appointments to Google Calendar

1. Open Outlook. Click on File > Import and Export…

Export Outlook Appointments to Google Calendar

2. Click on Export to a file from the list and click Next

Note: I chose this option instead of iCal/vCal due to some errors I’ve received in the past. The CVS route is a sure thing.

Export Outlook Appointments to Google Calendar

3. Select Comma Separated Values (Windows) from the menu, click Next.

Note: Make sure to select the file type for Windows

 


Export Outlook Appointments to Google Calendar

4. Select the folder to export from, in this case we will be exporting from the Calendar. Click the Calendar icon and click Next.

Export Outlook Appointments to Google Calendar

5. Click on Browse to select the directory where you would like to save the file.

Export Outlook Appointments to Google Calendar

6. Name the file (export-google) and click OK.

Note: You can name the file whatever you like. I named it this way because it makes it easier to find.

Export Outlook Appointments to Google Calendar

7. Click Next to proceed.

Export Outlook Appointments to Google Calendar

8. Make sure that Export "Appointments" from folder: Calendar is selected. Click Finish.

Export Outlook Appointments to Google Calendar

9. Enter the date range that you would like to include with this export and click OK when you’re ready to proceed.

Export Outlook Appointments to Google Calendar

10. When the export is complete you should find a .CSV file in the location you indicated.

Export Outlook Appointments to Google Calendar

11. Log in to your Google Calendar and click on the Settings link on the top right corner.

Export Outlook Appointments to Google Calendar

12. Click on the Calendars tab and click on the Import calendar link.

Export Outlook Appointments to Google Calendar

13. Click on the Browse button to locate your .CSV file we exported in the previous steps.

Export Outlook Appointments to Google Calendar

14. Locate the .CSV file and click Open.

Export Outlook Appointments to Google Calendar

15. Choose a Calendar from the drop-down menu and click on the Import button.

Export Outlook Appointments to Google Calendar

16. Depending on the number of events and the speed of your connection, the import can take seconds or a couple of minutes. When completed you should see the message above. Processed X events.

Export Outlook Appointments to Google Calendar

17. Return to your calendar and you should now see the events you just imported. Welcome to Google Calendar.

Article posted on 06 11th, 2009

Related & Suggested Posts

  1. Transfer Your Outlook Contacts to the Cloud
  2. Use Google Calendar Sync to Keep Your Outlook Calendar Synchronized
  3. Transfer Your Outlook Emails to Gmail
  4. How to Import Your Contacts into Outlook 2010
  5. Transfer Your Outlook 2003 Emails to Gmail