Google Calendar: Howto Import Outlook (CSV) or iCal Calendar Events

Want to import your schedule from Outlook into Google calendar? Importing from any CSV or iCAL file is very easy.

Users frequently need to get schedules exported from Outlook and imported into Google Calendar. These directions have been updated for the latest changes in Google Calendar.

Export from Outlook

1. Open Outlook
2. Click File menu
3. Click Import and Export
4. Click Export to a file
5. Click Comma Separated Values (DOS)
6. You may be required to install the possible translator here. Just follow the directions on the screen.
7. Select folder to export from: Calendar
8. Browse, name, and save the file some place easy to find it. (Desktop)
9. Click Next
10. On the follow actions will be performed screen click the Finish button.
11. Allow the export to perform

Import into Google Calendar

1. Open Google Calendar
2. Click the small arrow in the upper right corner of the “Other calendars” box that is on the left side of your calendar page.

Select "import calendar" from the left column.

3. Click the Import Calendar link under Calendar settings
4. Click the Browse button and select your exported file
5. Choose your calendar
6. Click Import and wait. It may take a bit.
7. You will be notified when the process is completed.

Congratulations. Your Outlook Calendar is now entered into Google Calendar!

 

About David Kirk

David Kirk is one of the original founders of tech-recipes and is currently serving as editor-in-chief. Not only has he been crafting tutorials for over ten years, but in his other life he also enjoys taking care of critically ill patients as an ICU physician.
View more articles by David Kirk

The Conversation

Follow the reactions below and share your own thoughts.

  • Kevin

    could not see “Import” only “Export” in Calendar settings. I am using Google Chrome browser.

    • moi

      same here whats up with that?

  • http://blogs.tech-recipes.com/davak/ davak

    Kevin: It looks like this was recently changed. I’ll update the main recipe, but here is how to do it now.

    Click the Add arrow under the Calendar list in the left column
    Select Import from there.

    • Kevin

      Holy smokes! There it is. Thanx.

      • http://blogs.tech-recipes.com/davak/ davak

        Anytime!

        • Kevin

          …any idea about importing contacts from Outlook to Gmail so that all the fields and entries make the trip?

    • wdonders

      Sorry, but I still can’t find the import option.

      Only in the pulldown menu under ‘Add’ in the ‘Other calendars’ pane, there is an import option.
      But not in the ‘My calendars’ Pane.
      And i want to import a calendar which i can edit, not a ‘other calendar’, cause these are not editable.
      help! Am i missing something?

  • J. Cadow

    For this to “work good” in the current Google Calendar interface, change step 13 to:

    13. Click the small ‘Add’ link in the bottom right corner of the “Other calendars” box that’s on the left side of your calendar page.

  • josh

    Thanks, it worked good.

  • http://masbury.wordpress.com Monte_Asbury

    I moved my Palm calendar to Gcal by exporting it to yahoo calendar, then exporting as a csv to Gcal.

    • Jjkennard

      How did you do that? I have a Palm Tungsten E2 which I love but is starting to give up the ghost and now just purchased an Incredible phone. I have a Gmail account already set up. Palm Support helped me to get my Palm calendar into Outlook, but you can’t transfer “recurring” events, and that’s about half of my calendar. Please help as I am not very computer savvy.

  • Web Suunnittelu

    Cool app, but the import feature was a pain in the back!

  • richard S

    does this process update the google calendar when you add stuff to the outlook?

  • Linda gollette

    thanks for the advise it worked perfectly

  • http://photo.seratoga.com/ Liperty

    I don’t seem to be able to import reoccurring events – they become 100s of individual events.. is there any way to resolve this..

    eg. If I have a weekly appointment in Outlook – it becomes an separate appointment for each week in Google Calendars – not good if you want to change the address / details of the appointment for all instances!

    Pls. help!

    Cheers,

    -=Steve

  • rafdevis

    Great! Gracias.

  • John P.

    Awesome! Just followed your instructions and it worked like a charm!

    Many thanks-!

  • Anonymous

    This does not work well when you begin to import your Outlook calendar on a regular basis (weekly).

    I am finding numerous duplicate entires in my google calendar, and this gets worse each time I import with more duplicates.

    Can I stop this occurring?

  • Keith

    Your tease says that “Actually importing from any CSV or iCAL file is very easy.” But I don’t see any instructions re: importing from iCal, just Outlook. Am I missing something?

  • NyeTheLoanGuy

    Thx, this was easy and worked great.

  • TomKayak

    Anyway to write an app that automates all of those tasks?
    Tommy

  • Ajblye

    Yay it worked! Now I must learn how to synd both calendars and get all that to my blackberry

  • Drew

    Awesome! Worked like a charm, thanks.

  • Leenwa

    I am unable to get it to work on Outlook 2007 12/1/10

  • Craig Salvay

    Thanks. Good Instructions…especially “it will tell you when it’s done.” Impatience is a terrible thing!

  • Jbridges

    Thanks, worked like a charm the first try. And I’m a non-techie.

    • Heidy Morales

      I agree…I first tried using the Microsoft instructions and as always, they sucked. I did this all on the first try and I’m certainly a non-techie also. THANKS!!!

  • Tacktoday
  • Marian

    I imported my ical file (ics) into the Google calendar and saw it did ( in a second) but nothing shows. Restarted the Mac but whatever I try the Google calendar stays empty :S
    Can you help?

  • Megan Vice

    Hi,

    I was able import the football calendar using the ICS file, but not the CSV. I was wondering if there will be a ICS file version of the Men’s basketball schedule?

    Thanks!

  • Landan

    When I open up my Google Calendar, I am missing what used to be there. All I see is the calendar and “Subscribe with Google Calendar”, and “Time Zone Central Time”. Where is the “left column” that you speak of? Where are the “Calendar Settings”? There is nothing to click on other than to change the month or subscribe to Google Calendar.

    HELP!!!!!!!!!!

  • David Kirk

    @landan – I updated to article to include a picture which shows the import selection.

  • Sheds

    Thanks for your help, I have been trying to do this for the longest time.

    So glad I found your Blog

    Thanks

  • Robby

    Help please, when I try to get my outlook calender to my Gmail, with the importing, anpop up on the gmail asking : importing calender that s all but no importing ….
    Help please I really need my calender on my gmail

    Thanks in advance

  • Pim

    Is there a way to automate this import?
    I’ve automated the build of an CSV from my work schedule.
    Everything works perfectly when I import the CSV by hand.
    The last step is to also automate the import of the CSV into my calendar.

    Anybody?

  • Brandy

    I am having the same problem! I haven’t seen it before, but when I tried to update my calendar, the other pop-up window comes up, and the only thing it says is “Import Calendar”, with a big X in it, and nothing happens. Have not been able to import my calendar in a weeks … HELP!

    • Antony

      I’ve seen the same problem. I tried it in a number of browsers before I got to the bottom of this problem. It seems that the pop-up window is not sized properly and it is an error – something like the file you are trying to import is too big. But you can’t see the error message so the only way of closing the window is to click on the X.

      Strangely enough the pop-up windows is incorrectly sized in Chrome on a Mac, as well as Firefox. It was Safari that showed the pop-up window correctly.

      I had to split the file into a number of smaller sections – importing 1 year at a time (for 12 years of data, that was quite a job).

  • takon3108

    many many thanks

  • Sandra

    THANK YOU SO MUCH You are a genius!

  • Art Long

    Thank you so very much, your information did the trick and has made my life a lot easier. Much appreciated! Thank you again

  • Bernard Most

    Your instructions are clear BUT, when I click Other calendars, I do not get the “import” option; indeed, I get no options at all. Any idea what I’m doing wrong or have set up incorrectly?

  • Heather

    How do I prevent it from putting duplicate appointments. I was using an icalendar, but it won’t seem to update correctly anymore. I just did the .csv and it’s showing all my original stuff plus the new. I’d want it to override the existing.

  • Sarah Borduin

    The above instructions are exactly how I thought this process should work. I got and error message: Failed to import events: Unable to process your iCal/CSV file..

    Am searching further for how to overcome this failure.

  • Laura

    I imported the outlook calendar into google but when I make an update on the outlook calendar it does not appear in google. Does the google calendar not update automatically when a change is made in the outlook calendar?

  • Janey van Asperen

    Thank you for the step by step recipe. I have been trying for months to exchange my appointments in my outlook calendar with my gmail calendar but all the recipes where too complicated. Yours is simple. And it worked out fine, so thanks!

    Just one question left: I followed all the steps, but does this mean that all my appointments in both calendars synchronize automatically or do I have to repeat these steps when I change something in one of these calendars?