export google calendar to excel file or csv: gcal2excel

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

About Vinh Nguyen

Statistician

2 comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>