Today I have built a tool that cleans up the calendar (ICS file) exported from Outlook 2010 to be suitable for import to Google Calendar

It looks to me that:

  • when a recurring Outlook event instance is updated, Outlook generates 2 event entries with the same UID – one for the recurring original and another for the changed instance details. This second entry only contains the details which are different from the recurring event.
  • when importing this file into Google calendar – it imports only the modified instance details – thus often resulting in import of blank entries.

The tool:

  • looks at the recurring event
  • copies the missing details from recurring event into a modified instance
  • removes the recurring event from the ics file

Using library