How to export Google Calendar and write info to Outlook ZCalendar

[JrMontgom]

I recently started using a shared Google calendar with members of the AudioVisual committee at my church. However now Google doesn't support the synching of Google to Outlook mail. Is there a way to export a Google calendar by date in CVS format? If so I could then parse the data in the CVS formatted file and update my Outlook calendar using the Outlook calendar objects.

[Dal Jeanis]

Unfortunately, this is an Access forum rather than a Google calendar forum, so we might not have any SMEs on that function.

From a quick google of "google calendar export", It looks like you should be able to export to CSV format, since you can import from that format.

https://support.google.com/calendar/answer/37111?hl=en


Good luck!

[JrMontgom]

Thanks for the quick response but the only export is in "ICS" format not CSV.

[Dal Jeanis]

Okay, that's pretty lame of Google. I guess you could export to .ICS and then import the .ICS into a fresh MS Outlook calendar (or third party anything), then export from Outlook to CSV.

Looks like gcal2excel is an open source utility program to simplify that conversion. WinCalendar is a professional application that also does the job. I have no opinion on either of them.