Skip to content
Blink Brief
Language:

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 converter needs JavaScript. To make the list by hand:

  1. Open the .ics file in a text editor, such as Notepad or TextEdit.
  2. Each event runs from BEGIN:VEVENT to END:VEVENT. Copy its SUMMARY (title), DTSTART (start), DTEND (end) and LOCATION into one spreadsheet row.
  3. Read 20261116T090000 as 16 November 2026, 9:00. A Z at 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.

ColumnWhat it holdsFrom the file
TitleThe event's nameSUMMARY
Start date, Start timeWhen it starts; no time for an all-day eventDTSTART
End date, End timeWhen it ends; for an all-day event, its last dayDTEND, or DTSTART plus DURATION
All dayYes or Noa date with no time
HoursEnd minus start, such as 1.5; empty for all-day eventsworked out
Time zoneThe 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, LinkThe place, the description and the event's web linkLOCATION, DESCRIPTION, URL
Repeats, Repeat ruleThe repeat in words, such as "Weekly on Mon, Wed until 2026-12-15", and the rule as writtenRRULE, 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.

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.

  1. Choose Portrait, and your paper: US Letter in the US and Canada, A4 almost everywhere else.
  2. To keep a file instead of paper, pick Save as PDF as the printer.
  3. 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