Guide · Office and email
How to convert an .ics calendar file to Excel, CSV or PDF (free, in your browser)
By Blink Brief · Published · Updated · How pages are made
Choose the .ics file in the free converter below. Every event becomes one row in a CSV file that Excel, Google Sheets and Numbers open: title, start and end, all day, hours, time zone, location, notes and repeat. Print or save as PDF prints the same list, or saves it as a PDF. The file is read in this browser tab and never uploaded, and each time keeps the zone the file gives it, named in its own column; a time the file gives in UTC (ending in Z) is shown in your own time zone. To add the events to a calendar instead of listing them, open the file in the free ICS viewer.
Convert an .ics file to CSV, or print its events
The calendar file (.ics)
or drop it on this box
The file is read in this tab and never uploaded.
| Date | Time | Title | Location | Repeats |
|---|
In the print window, choose Portrait and your paper, US Letter or A4: the list fits either.
The converter needs JavaScript. To make the list by hand:
- Open the .ics file in a text editor, such as Notepad or TextEdit.
- Each event runs from
BEGIN:VEVENTtoEND:VEVENT. Copy itsSUMMARY(title),DTSTART(start),DTEND(end) andLOCATIONinto one spreadsheet row. - Read
20261116T090000as 16 November 2026, 9:00. AZat the end means UTC.
What each column holds
The CSV has a header row and one row per event, sorted by start date and time. Dates are written 2026-11-16 and times 09:00, which spreadsheets read as dates and times you can sort and add up.
| Column | What it holds | From the file |
|---|---|---|
| Title | The event's name | SUMMARY |
| Start date, Start time | When it starts; no time for an all-day event | DTSTART |
| End date, End time | When it ends; for an all-day event, its last day | DTEND, or DTSTART plus DURATION |
| All day | Yes or No | a date with no time |
| Hours | End minus start, such as 1.5; empty for all-day events | worked out |
| Time zone | The zone the times are in: a name such as America/Chicago, your own zone (such as America/New_York) for a time the file gives in UTC, or "none (floating)" | Z or TZID |
| Location, Notes, Link | The place, the description and the event's web link | LOCATION, DESCRIPTION, URL |
| Repeats, Repeat rule | The repeat in words, such as "Weekly on Mon, Wed until 2026-12-15", and the rule as written | RRULE, EXDATE |
Two details. An all-day event's end date in the file is the day after it ends (the standard, RFC 5545, calls the end "non-inclusive"), so the converter writes the last day itself: a trip from 14 to 16 November shows 2026-11-14 to 2026-11-16. And a cell that would start with =, +, - or @ gets an apostrophe in front, so a spreadsheet doesn't run a note from someone else's calendar as a formula. Guests, reminders and to-dos aren't in the CSV.
Excel put everything in one column or broke the accents: open the CSV this way
Accented names (Zoë, Málaga, Müller) turn into odd characters when Excel reads a UTF-8 file as another encoding. Microsoft's fix: "You can open a CSV file encoded with UTF-8 normally if it was saved with BOM (Byte Order Mark)." The converter saves the CSV with that mark, so double-click it, or use File › Open in Excel.
- Everything in one column: your Excel expects another separator, usually a semicolon where the comma is the decimal mark. Use Data › From Text/CSV instead, choose the file, select Import, and pick Comma under Delimiter, as Microsoft describes.
- Google Sheets: File › Import, upload the CSV, choose an import option such as Create new spreadsheet, and leave Separator character on Detect automatically or set it to Comma.
- Numbers on a Mac: open the CSV. In our test in Numbers 14.5, the accents, a note with commas in it and a note on two lines each stayed in one cell, and a note that began with = stayed text, its apostrophe showing.
Repeating events: one row with its rule, not one row per date
A weekly class until December is one event in the file, so it's one row in the CSV, with "Weekly on Mon, Wed until 2026-12-15" in Repeats and the rule itself beside it. The converter doesn't write out every date: a rule with no end would never stop. Dates skipped in the file show as "(except 2 dates)", and a single date that was moved or changed appears as its own row, marked "One date of a repeating event, changed".
To count sessions or bill hours, multiply the row's Hours by the number of dates in your term, or list the dates you need by hand. The ICS viewer shows the same rule in plain words, such as "Repeats every Monday and Wednesday", followed by the last date.
Time zones: UTC times in yours, the others as the file gives them
A webinar written in UTC (its time ends in Z in the file) shows in your own time zone, the one this browser reports, named in the Time zone column, such as America/New_York; a class written with a zone name keeps its local time and that name; a time with neither shows "none (floating)", which the standard means as the same clock time wherever you are. Sorting is by the times as shown, so a file that mixes zones sorts by each event's own clock.
To see an event at your own time, open the file in the ICS viewer: when an event's zone isn't yours, it shows "Your time" under it.
Print the list or save it as a PDF
After choosing the file, press Print or save as PDF. The browser's own print window opens with only the list: the file name and event count, then one line per event with its date, time, title, location and repeat.
- Choose Portrait, and your paper: US Letter in the US and Canada, A4 almost everywhere else.
- To keep a file instead of paper, pick Save as PDF as the printer.
- Check the preview's page count before printing a long calendar.
We tested the converter in Chromium and WebKit, the engines behind Chrome, Edge and Safari, at phone and desktop widths. Saved as a PDF from Chromium, our sample of 8 events filled one Letter or A4 page and a file of 200 events filled 9, with nothing but the list on them.
From Excel back to a calendar
If you still have the .ics file, import that, not the CSV: it keeps repeats and time zones. Google's help warns that repeating events imported from a CSV "might not show up that way. They'll be on your calendar as a series of one-time events." Steps for the .ics file are in opening an .ics file on Windows 11, for Google Calendar and Outlook.
For a list you made or changed in a spreadsheet, Google Calendar imports a CSV on a computer (Settings › Import & Export) with English headers it names: Subject and Start Date are required, and Start Time, End Date, End Time, All Day Event (True or False), Description, Location and Private are optional. This converter's columns have other names, so rename them to Google's, change Yes and No to True and False, and delete the columns Google doesn't list. Google's examples write dates as 05/30/2020 and times as 10:00 AM, where this converter writes 2026-11-16 and 09:00; change the format if Google refuses the file. We haven't tested such an import.
Need a calendar file out of iCloud or Outlook first? See exporting an iPhone or iCloud calendar as an .ics file and exporting a calendar from new Outlook.
Questions
Can Excel open an ICS file?
Not as a list of events: Microsoft's Excel help covers importing text and CSV files, not calendar files. Convert the .ics to a CSV with the free converter on this page, then open the CSV in Excel: one row per event, with dates and times in their own columns.
How do I convert ICS to CSV for free?
Choose the .ics file in the converter on this page and press Download CSV. It's free, with no sign-up, and works in a browser on a computer or a phone; the file is read in the browser tab and never uploaded.
How do I print an ICS calendar?
Choose the file in the converter on this page and press Print or save as PDF: only the list of events prints, one line per event, with date, time, title, location and repeat. In the print window choose Portrait and your paper, Letter or A4, or Save as PDF.
Sources
- Microsoft: Opening CSV UTF-8 files correctly in Excel: a CSV saved with a BOM opens normally. Read on 8 November 2026.
- Microsoft: Import or export text (.txt or .csv) files: Data › From Text/CSV; changing the delimiter. Read on 8 November 2026.
- Google Sheets Help: Import data sets & spreadsheets: File › Import; separator character. Read on 8 November 2026.
- Google Calendar Help: Import events to Google Calendar: CSV headers; repeat events from a CSV. Read on 8 November 2026.
- RFC 5545: iCalendar: DTSTART, DTEND (non-inclusive end), all-day dates, TZID, RRULE. Read on 8 November 2026.