An ICS to CSV converter turns a calendar file into a spreadsheet you can sort, filter, or import elsewhere. Calendar apps export events as iCalendar (.ics), which is great for other calendars but useless in Excel or Google Sheets. This free tool pulls each event’s key fields into tidy CSV columns, entirely in your browser.
How it works
The converter first unfolds the file, joining any line that begins with a space back onto the line above, because iCalendar wraps long values at 75 characters. It then walks each BEGIN:VEVENT…END:VEVENT block and reads these properties:
SUMMARY— the event titleDTSTART/DTEND— start and end, parsed fromDATEorDATE-TIMEvalues and shown in your local timeLOCATIONandDESCRIPTION
iCal text escapes (\n, \,, \;, \\) are decoded back to normal characters. Each cell is then CSV-escaped by wrapping it in double quotes and doubling any embedded quotes, so commas, line breaks, and quotation marks inside an event do not break the columns. A header row labels every column.
Tips and notes
- UTC date-times (ending in
Z) are converted to your browser’s local time; pureDATEvalues stay as a plain date. - If a property is missing on an event, its cell is simply left blank rather than skipped, so rows stay aligned.
- Open the downloaded file in a spreadsheet and use a filter to find events by month, location, or keyword.
- Recurrence rules are not expanded — each
VEVENTbecomes one row regardless of how many times it repeats.