ICS to CSV Converter

Export iCal events to a CSV spreadsheet for analysis or import

Ad placeholder (leaderboard)

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:VEVENTEND:VEVENT block and reads these properties:

  • SUMMARY — the event title
  • DTSTART / DTEND — start and end, parsed from DATE or DATE-TIME values and shown in your local time
  • LOCATION and DESCRIPTION

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; pure DATE values 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 VEVENT becomes one row regardless of how many times it repeats.
Ad placeholder (rectangle)