ICS to CSV: turn a calendar file into a spreadsheet
Short answer: choose an .ics file (or paste its text), pick the time zone you want the times in, and download a CSV with one row per event: title, start, end, all-day, place, notes and repeat rule. It is free and runs in your browser, so the calendar is never uploaded.
No account. Nothing uploaded. Free.
2. Check the table
3. Download it
What the CSV contains
| Column | What it holds |
|---|---|
| Subject | The event title. |
| Start Date, Start Time | The start, written as 2026-11-17 and 10:00. Empty time for an all-day event. |
| End Date, End Time | The end. For an all-day event this is the last day of the event. |
| All Day Event | True or False. |
| Time Zone | The zone the times are shown in. |
| Location, Description | The place and the notes. |
| Repeats | The repeat rule of a repeating event, such as FREQ=WEEKLY;BYDAY=MO. |
| UID | The unique id from the file. |
How times and time zones are handled
- Times that end in Z are in UTC. They are converted to the time zone you pick, which starts as the one on your device. Daylight saving time is applied for the date of each event.
- Times that name their own zone (for example America/New_York) are shown as written, and that zone appears in the Time Zone column.
- Times with no zone at all are shown as written. The file does not say where they apply.
Repeating events
A repeating event is listed once, with its rule in the Repeats column. It is not expanded into one row for every occurrence, so a weekly meeting that runs for a year is one row, not 52. If you need every date, import the file into a calendar app and export or print that view.
Open the file in Excel, Google Sheets or Numbers
The download is a UTF-8 file with a byte-order mark, so Excel shows accents and non-Latin letters correctly. In some countries Excel expects a semicolon between columns instead of a comma: choose "Semicolon" above if everything lands in one column. In Google Sheets use File, Import, Upload.
A cell that starts with =, +, - or @ is run as a formula by spreadsheet programs. Calendar files come from other people, so this page puts an apostrophe in front of such a cell and the text stays text.
What it is useful for
- Counting meetings or hours in a spreadsheet.
- Keeping a readable backup of a calendar you export from Google, Outlook or Apple Calendar.
- Cleaning or editing many events by hand, then turning the table back into a calendar file with CSV to ICS. The columns of this page are read by that tool as they are.
- Sending a list of dates to someone who does not use a calendar app.
What is left out
The CSV is a table of events, not a copy of the whole file. Reminders, guests, organizer details, attachments and time zone definitions are not included. To-dos and journal entries in the file are ignored. An event with no readable start date is skipped, and the page tells you which one.
When the events are in an image, not a file
Plans often arrive as a screenshot, a chat or a PDF you cannot copy from. Yotei is a Windows and Mac app that reads the event from your screen: press a shortcut, drag a box around it, check the details and confirm. It adds the event to Google Calendar, Outlook or iCloud directly. See how Yotei works, or test it yourself in your browser.
FAQ
How do I convert an ICS file to CSV?
Choose the .ics file on this page, check the table, pick the time zone and separator you want, and press Download .csv file. The CSV opens in Excel, Google Sheets and Numbers.
Is my calendar uploaded?
No. The file is read by a script in this page and stays in your browser. The only request the page makes is an anonymous visit counter.
Why are the times different from my calendar?
Times stored in UTC are shown in the time zone you pick. Check "Show times in" and set it to the zone you want.
Why does a repeating event appear only once?
It is listed once with its repeat rule in the Repeats column, instead of one row for every occurrence.
Can I turn the CSV back into a calendar file?
Yes. Use the CSV to ICS page. It reads these columns. Repeat rules, guests and reminders are not carried through the CSV.
Does it work with Google Calendar and Outlook exports?
It reads standard .ics files, which is what both of them export.
Yotei