ICS to CSV — calendar events as a table
Convert an .ics calendar to a CSV table: start, end, title, place, people and repeats, with every time shown in your own time zone.
About this conversion
An .ics stores time three different ways: in UTC, in a named time zone, or as a whole day. A converter that treats them alike moves meetings by hours and all-day events to the day before. Here each one is turned into the same moment and written in your time zone, an all-day event that runs 20–22 October says 20 to 22, not 23, and a repeating event is one row with “weekly on Thu, 5 times” spelled out.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same calendar, any way out
The file is read once and stays open, so the format is picked at the end: the same events can leave here as XLSX, CSV for Google Calendar or PDF. The same meeting found in an invitation, a reply and an export is recognised as one event, and its time is the same moment whichever way it was written — with a time zone, in UTC or as a whole day.
Questions
- I need every occurrence of a repeating event as its own row.
- Use “CSV for Google Calendar” in the Export menu: it spells repeats out as separate rows, skipping the dates that were cancelled.
- Several .ics files with the same events?
- Drop them together. Copies of the same event — from an export, an invitation and a reply — are matched and listed once.