Transfer Your Outlook Calendar to the Cloud

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.

  • Pingback: Transfer Your Outlook 2003 Emails to Gmail()

  • Pingback: Transfer Your Outlook Emails to Gmail()

  • Pingback: Moving your Blackberry to Google Apps? Some things I learned along the way « Mr. Schiff's Laboratory()

  • Steve

    Gil, will your process automatically update the Google Calendar when changes are made in outlook or do I have to follow this process everyday?

    Steve

    • Steve – Nope this process will not sync your calendar everyday…if you wish to sync your calendars automatically you should try out Calendar Sync from Google – http://www.google.com/support/calendar/bin/answer

      I've used this software for about a year and have no major issues. The only thing you should keep in mind is that the Outlook Calendar will only sync with the Default calendar in GCal…if you have any questions about its use or are looking for tips…let me know, I'll be more than happy to help.

  • Steve

    Gil, will your process automatically update the Google Calendar when changes are made in outlook or do I have to follow this process everyday?

    Steve

    • Steve – Nope this process will not sync your calendar everyday…if you wish to sync your calendars automatically you should try out Calendar Sync from Google – http://www.google.com/support/calendar/bin/answer

      I've used this software for about a year and have no major issues. The only thing you should keep in mind is that the Outlook Calendar will only sync with the Default calendar in GCal…if you have any questions about its use or are looking for tips…let me know, I'll be more than happy to help.

  • Sandra Yalip

    Gil, you rock! This is by far the most easy to understand & idoit proff ‘how to’ i have seen online!

    This feature comes in very handy. I can suggest another another topic – how about top 5 Outlook addins. I like OutTwit for Outlook twittering & WinCalendar for outlook printing!

    • Gil

      @Sandra Yalip – Thanks for the encouraging feedback, glad you find it useful. I hope you continue finding future articles as useful.

  • Sandra Yalip

    Gil, you rock! This is by far the most easy to understand & idoit proff ‘how to’ i have seen online!

    This feature comes in very handy. I can suggest another another topic – how about top 5 Outlook addins. I like OutTwit for Outlook twittering & WinCalendar for outlook printing!

    • Gil

      @Sandra Yalip – Thanks for the encouraging feedback, glad you find it useful. I hope you continue finding future articles as useful.