ICS to CSV and Excel converter

How to convert an .ics file to a spreadsheet

1. Choose one or more .ics files.
2. Choose the time zone to show times in (it starts set to your device’s time zone), and the date and time format you prefer.
3. Check the preview and download a CSV or an Excel workbook. Events are sorted by start time.

The columns you get

Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location come first. These are the same headings Google Calendar uses for its CSV import. They are followed by Time Zone, Repeats, Organizer, Attendees, Categories, Status, URL and the event’s UID (its unique ID).

• All-day events show their real last day. In an .ics file, the end date of an all-day event is the day after it ends, which is confusing in a spreadsheet, so this is corrected.
• Repeating events are listed once, with a plain-English rule such as “Every 2 weeks on MO, 5 times” in the Repeats column.
• Times are converted whether the file uses Outlook’s Windows time zone names (“Eastern Standard Time”) or standard names (“Europe/Paris”). If a time zone can’t be identified, its times are shown as written, and the page names that time zone in a note.

Getting an .ics file out of your calendar

• Google Calendar: on a computer, Settings → Import & export → Export. You get a ZIP with one .ics file per calendar. Unzip it and choose the files here.
• Outlook (classic, Windows): open the calendar → File → Save Calendar → More options to pick the date range and how much detail to include.
• Outlook.com and the new Outlook: Settings → Calendar → Shared calendars → Publish a calendar, then open the ICS link to download the file. Anyone with that link can see the calendar, so stop publishing once you have the file. Work accounts may have this option turned off.
• Apple Calendar (Mac): select the calendar (iCloud calendars are listed too) → File → Export → Export…
• iPhone and iCloud: there is no export button. Without a Mac, open the Calendar app → Calendars → the ⓘ next to the calendar → turn on Public Calendar → Share Link. Open the link in a browser with webcal:// changed to https://, which usually downloads the .ics file, then turn Public Calendar off again.
• Booking and event systems usually offer an “Add to calendar” or “Download .ics” link.

Calendar invitations come from other people. So if any text could be treated as a formula by a spreadsheet (text starting with = or @, for example), it gets an apostrophe added at the start in the CSV file. The Excel (.xlsx) download keeps such text exactly as it is, as plain text.

Common uses

• Billing or timesheets: list meetings with start and end times, then add a duration column (=E2-C2) in Excel.
• Moving events between calendars that can’t sync, or keeping a record before deleting an old calendar.
• Sharing a readable schedule with someone who doesn’t use your calendar app.