BYTETOOLS

ICS (iCalendar) to CSV Converter

Convert an .ics calendar file to CSV online. One row per event with start, end, duration, location, organiser, attendees and recurrence — all in your browser.

Drop an .ics file here or click to browse

What is the ICS (iCalendar) to CSV Converter?

The ByteTools ICS to CSV Converter reads an iCalendar export from Google Calendar, Outlook, Apple Calendar or a booking system and turns it into a spreadsheet.

  • One row per VEVENT with 18 named columns
  • Handles UTC, floating, TZID and all-day date values
  • Computes duration in human form and in minutes
  • Organiser and attendee names with their addresses
  • Un-escapes \n, \, and \; inside text fields
  • Runs offline in your browser — nothing is uploaded

How to use the ICS (iCalendar) to CSV Converter

  1. 1

    Drop your .ics file into the drop zone, or paste the calendar text.

  2. 2

    Choose the delimiter your spreadsheet expects.

  3. 3

    Pick how dates should be written: ISO 8601, your local time, or exactly as in the file.

  4. 4

    Check the event, recurring and all-day counts.

  5. 5

    Copy the CSV or download it as calendar.csv.

About the ICS (iCalendar) to CSV Converter

The ByteTools ICS to CSV Converter reads an iCalendar export from Google Calendar, Outlook, Apple Calendar or a booking system and turns it into a spreadsheet. Every VEVENT block becomes one row with the summary, location, description, organiser, attendee list, status and recurrence rule laid out in named columns.

Dates are handled properly rather than dumped as raw strings: UTC timestamps ending in Z, floating times, TZID-qualified times and all-day VALUE=DATE entries are each recognised, and the duration between start and end is calculated for you in both a human-readable form and whole minutes.

Folded lines are unfolded first, and escaped commas, semicolons and newlines inside SUMMARY, DESCRIPTION and LOCATION are decoded back to real text. The whole conversion runs locally in your browser, so a calendar full of meeting titles and attendee addresses is never uploaded anywhere.

Frequently asked questions

How do I open an .ics file in Excel?

Convert it here first. Drop the .ics into the drop zone, download the generated CSV, then open that in Excel or Google Sheets — each event becomes one row with its own columns.

How are time zones handled?

Timestamps ending in Z are true UTC and can be shown in ISO form or converted to your local time. Times carrying a TZID or no zone at all cannot be converted without a time zone database, so the wall-clock reading is shown with the TZID named beside it.

Does it expand recurring events into individual dates?

No. The RRULE is exported as text so you can see the pattern, but each recurring event stays a single row. Expanding a rule into hundreds of occurrences would need full RFC 5545 recurrence handling including exceptions.

What happens to all-day events?

An event stored as VALUE=DATE is flagged 'yes' in the All day column and its start and end are written as plain dates without a time. Remember that iCalendar end dates for all-day events are exclusive.

Is my calendar uploaded to a server?

No. The file is read on your device and parsed by JavaScript in the page. Meeting titles, attendee addresses and notes never leave your browser.

Related tools