export google calendar to excel file or csv: gcal2excel
Internet
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:
- 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.
- Import your calendar into MS Outlook and export to csv.
- 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