Analysing your schedule
Export a calendar as .ics, convert here, and open the CSV to sort, filter or total your events in a spreadsheet.
ICS to CSV
Convert an iCalendar (.ics) file to CSV in your browser, turning events into spreadsheet rows.
Maintained by Roshan.
Use ICS to CSV
Converts icalendar (.ics) to csv in this tab, with nothing sent anywhere.
Runs entirely on your deviceThe conversion happens in this browser tab. Nothing you type is uploaded, logged or stored, which is worth knowing for anything you would not paste into a search box.
Explore developer and data tools
Find related browser-local tools for nearby tasks without starting another search.
Browse all developer and data toolsAbout ICS to CSV
An .ics file is the standard way calendars are shared and exported - the iCalendar format - but it is meant for calendar apps to read, not people. To analyse your events, list them for a report, count how you spend your time, or import them somewhere that expects a table, you need CSV. This reads an iCalendar file and turns each event into a row, with columns for the summary, start and end times, location and description. It handles the two things that trip up naive parsers: the folded lines the format uses to wrap long values, and the compact timestamp format, which it rewrites into readable dates. As with contacts, a calendar is personal - where you were and when - so the conversion stays in your browser.
Work through the input
- Folded lines are unwound first: iCalendar wraps long values across lines with a leading space, and joining them is necessary before anything can be read.
- The file is split into individual events, each marked by a BEGIN:VEVENT block.
- For each event, the summary, start, end, location and description are extracted.
- The compact timestamps are rewritten into readable dates and times, with UTC marked where the event specifies it.
- The events become CSV rows with a header naming each column.
When ics to csv is useful
Reporting on events
Turn a shared calendar into a table for a report, without uploading where you have been.
Check the output
- It extracts the core fields - summary, start, end, location, description. Recurrence rules, attendees, reminders and attachments are not included in the table.
- A recurring event appears once, as its defining entry, rather than expanded into every occurrence.
- Timezones are handled where the event marks UTC; events in a named local timezone are shown as written without shifting.
- All-day events, which carry a date but no time, are shown as a plain date.
- The output summarises events for analysis, not a lossless copy of the calendar.
Questions about ICS to CSV
Does it expand recurring events?
No. A recurring event appears once as its defining entry, not as every occurrence.
Which fields are included?
Summary, start, end, location and description. Attendees, reminders and recurrence rules are not in the table.
How are times shown?
The compact iCalendar timestamps are rewritten as readable dates, with UTC marked where the event specifies it.
What about all-day events?
They show as a plain date, since they carry no time of day.
Related tools
vCard to CSV
Convert a vCard (.vcf) contact file to CSV in your browser, ready for a spreadsheet. Nothing is uploaded.
CSV to JSON Converter
Convert CSV to a JSON array locally. Parse quoted commas, embedded newlines, BOM files, duplicate headers, sparse rows, and optional safe value types.
GeoJSON to CSV
Convert GeoJSON point features to CSV in your browser, with longitude, latitude and properties as columns.