ICS to CSV Converter — Calendar File to Spreadsheet
Turn any iCalendar (.ics) export into a clean CSV you can open in Excel or Google Sheets. Drop the file below, preview every event in a table, pick a timezone for UTC times, and download. 100% in your browser — nothing is uploaded.
What the converter extracts
The parser is deliberately tolerant: it unfolds wrapped lines, accepts LF-only files, skips VALARM reminder blocks without letting them clobber event fields, and shrugs off vendor-specific properties (X-…) that other converters choke on. From each VEVENT it extracts the title, start and end, location, description, organizer, status and recurrence rule, and unescapes ICS text (\n, \,, \;) back into normal characters.
Two details other tools commonly get wrong, handled here: all-day events use an exclusive end date in ICS, which the converter turns back into the inclusive end date a spreadsheet reader expects; and events without a DTEND (legal per the spec) are kept rather than dropped.
Common reasons to go ICS → CSV
- Reporting: count meetings per week, sum hours by project, or pivot events by location in a spreadsheet.
- Migration and cleanup: bulk-edit titles or locations in Sheets, then convert back with the CSV to ICS converter.
- Archiving: a CSV snapshot of an old calendar is searchable and future-proof.
- Sharing: colleagues without calendar access can read a spreadsheet.
ICS to CSV — frequently asked questions
How do I convert an ICS file to CSV?
Drop your .ics file into the converter on this page (or paste the raw ICS text). It parses every event, shows them in a table, and downloads a CSV with Subject, Start Date, Start Time, End Date, End Time, All Day Event, Location, Description and Recurrence columns. Everything runs in your browser — the file is never uploaded.
How do I export my Google Calendar to ICS first?
In Google Calendar on the web, open Settings → Import & export → Export. You get a ZIP containing one .ics file per calendar. Unzip it and drop the calendar you want into the converter above. Individual calendars can also be exported from their own settings page under 'Integrate calendar'.
Will the CSV open properly in Excel?
Yes. The download is UTF-8 with a BOM, which is the encoding Excel needs to display accented characters and emoji correctly when you double-click the file. It also opens cleanly in Google Sheets, Numbers and LibreOffice.
What happens to recurring events?
Recurring events appear once, with their recurrence rule (e.g. FREQ=WEEKLY;BYDAY=MO) preserved in a Recurrence column so the information isn't lost. The converter does not expand a rule into hundreds of individual rows — for most spreadsheet analysis the single row plus rule is what you want.
How are timezones handled when converting ICS to CSV?
Events stored with a named timezone (TZID) keep their original wall-clock time, since that's what the organizer meant. Events stored as UTC ('Z' times) are converted to the display timezone you pick — it defaults to your browser's zone. All-day events have no time at all and are flagged True in the All Day Event column.
Can I re-import the CSV into Google Calendar later?
Yes — the column headers this tool writes (Subject, Start Date, Start Time…) are exactly the headers Google Calendar's CSV import expects, so the round trip works. Or skip CSV entirely and use our CSV to ICS converter to go back to an .ics file.