See More About: , , ,

Transfer Your Outlook Calendar to the Cloud

by
export outlook calendar google header Transfer Your Outlook Calendar to the Cloud

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 calendar google Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google1 Transfer Your Outlook Calendar to the Cloud

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 calendar google2 Transfer Your Outlook Calendar to the Cloud

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

Note: Make sure to select the file type for Windows

 


export outlook calendar google3 Transfer Your Outlook Calendar to the Cloud

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 calendar google4 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google5 Transfer Your Outlook Calendar to the Cloud

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 calendar google6 Transfer Your Outlook Calendar to the Cloud

7. Click Next to proceed.

export outlook calendar google7 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google8 Transfer Your Outlook Calendar to the Cloud

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 calendar google9 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google10 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google11 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google12 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google13 Transfer Your Outlook Calendar to the Cloud

14. Locate the .CSV file and click Open.

export outlook calendar google14 Transfer Your Outlook Calendar to the Cloud

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

export outlook calendar google15 Transfer Your Outlook Calendar to the Cloud

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 calendar google16 Transfer Your Outlook Calendar to the Cloud

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

See More About: , , ,
Originally posted Jun 11, 2009

We close comments after 30 days on GilsMethod.com and ask that you post questions and issues on our Answers website.

This helps us better serve you by allowing us to keep track of unanswered questions that are usually hidden in long comment threads.

Answers.GilsMethod.com is a community-powered support website where you will be able to post questions, and other users including us will respond with expert advice.

So if you are having trouble with your PC, Mac, iPad, iPhone, or other piece of technology, head over to Answers.GilsMethod.com and ask away.

  • 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!

  • 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!

  • http://www.gilsmethod.com Gil

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

  • http://www.gilsmethod.com Gil

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

  • 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

    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

  • http://intensedebate.com/people/gjperera gjperera

    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.

  • http://intensedebate.com/people/gjperera gjperera

    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.

  • http://kennyschiff.wordpress.com/2010/04/09/moving-your-blackberry-to-google-apps-some-things-i-learned-along-the-way/ Moving your Blackberry to Google Apps? Some things I learned along the way « Mr. Schiff's Laboratory

    [...] Clean calendar and contacts migration can be tricky. For calendaring and contacts, after many experiments we found that doing .csv-based uploads was also cleanest (and yes we tried Google Apps sync). As hard as Google engineers have tried to make this easy, Outlook/Exchanged based mailbox data structures can get screwed up over time, especially if users have ever had any kind of plugins involved, or have ever used 3rd party synchronization tools. I found that using .csv was fast and accurate with the least amount of heartache. There are some short coming to this (recurring meetings will get replicated, rather than retain their recurrence), but I’m not sorry we did it this way. If you decide to do the the .csv thing, make sure your users specify a wide data range if they want to preserve past and future calendar entries (e.g. we chose 2/1/2006 – 2/1/2012). If you’ve never done this before, you can try this recipe [...]

  • http://www.gilsmethod.com/transfer-your-outlook-emails-to-gmail Transfer Your Outlook Emails to Gmail

    [...] how-to describing the process for transferring appointments from Outlook to Google Calendar, follow this [...]

  • http://www.gilsmethod.com/transfer-your-outlook-2003-emails-to-gmail Transfer Your Outlook 2003 Emails to Gmail

    [...] To view the how-to describing the process for transferring appointments from Outlook to Google Calendar, follow this link. [...]