export google calendar to excel file or csv: gcal2excel


Vinh Nguyen


June 13, 2009

I can't believe google calendar doesn't let me export my calendar to a spreadsheet. It only allows export to .ics (ical) or xml. THAT SUCKS.

After many hours of search, this is what I came up with:

  1. gcal2excel(requires jdk). I couldn't get it to work in the beginning because I kept putting in "Vinh Nguyen" for calendar id (on a mac, it didn't display calendar id, it just put calendar …). To get it to work, enter the calendar id which you can find under settings in google calendar.
  2. Import your calendar into MS Outlook and export to csv.
  3. This can also be achieved with with Mozilla Sunbird. However, in one of my calendar I type using unicode (for Vietnamese) and the export gave me wierd