How to export Outlook calendar - ready for import.

If you would like to have events from Outlooku calendar in your Google calendar you can follow these steps.

Export from Outlook to csv file

  1. Open Outlook: Launch the Outlook application on your computer.
  2. Go to Calendar: Click on the calendar icon to view your calendar.
  3. Select File: In the top menu, click on "File."
  4. Choose Open & Export: Select "Open & Export" from the menu.
  5. Export to a File: Click on "Import/Export" and then choose "Export to a file."
  6. Select File Type: Choose "Comma Separated Values" (CSV) or "Outlook Data File" (PST) depending on your preference.
  7. Select Calendar: Choose the calendar you want to export.
  8. Save the File: Choose a location to save the exported file and click "Finish."
You should have *.csv file ready for c next import.

Export from Outlook to ics file

  1. In Outlook select Calendar and go to File > Save calendar
  2. Choose file name of your ics file
  3. Click "More Options" below to choose: 
    • Date Range
    • Detail: Avialability only, Limited details, Full details
    • Advanced: Include private details and attachements
 You should have *.isc file ready for your next import.

Import csv or ics file to Google calendar

  1. Sign in your Google account and open Calendar from app list
  2. Maximize Calendar and go to Settings (gear wheel)
  3. Choose 1st option - Settings and find "Import and export" below
  4. Select your *.csv or *.ics file and click import
You should see successfull import. If not, than continue reading.

Possible issue

I had problem with mentioned import to Google calendar. My first import worked fine but for some reasons next imports crashed. I tried many attempts and realized to find some answers.

Solution 1:

This video https://www.youtube.com/watch?v=jEHyXyDis-w explains that one of problem could be not sufficient access to target calendar. "ID definition". So, you have to edit your ICS file and find all strings "UID:" and replace them with "UID:X". It should worked, same as for me.
Also this post is explaining solution of the same issue.

Solution 2:

If you will face the import issue I suggest to use option 1 - export calendar to *.CSV and it should be OK. If it will not be OK, let me know below what method is working for you or if you found some method how to do Import to Goggle calendar.










Comments