Open a calendar .ics file in Excel as a table: title, start, end, place and people
Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.Excel cannot open an .ics file: it shows raw BEGIN:VEVENT lines. Drop the calendar here and every event becomes a row, with start and end dates and times in their own columns, duration in minutes, location, description, organiser, attendees and the repeat rule in plain words. Times can be moved into one time zone. The .xlsx is written on your device; nothing is uploaded.
Drop your files or click to choose them.
Adjust the options and check the preview.
Download the result. Nothing was uploaded.
An .ics file is how Google Calendar, Outlook and Apple Calendar export events. It is text, but not a table: each event is a block of lines such as DTSTART;TZID=Europe/Berlin:20261017T093000, which a spreadsheet cannot sort or filter.
| iCalendar | Column |
|---|---|
| SUMMARY | Title |
| DTSTART, DTEND or DURATION | Start date, Start time, End date, End time, Duration (minutes) |
| TZID, a trailing Z, or neither | Time zone (a zone name, UTC, or floating) |
| LOCATION, DESCRIPTION | Location, Description (line breaks kept) |
| ORGANIZER, ATTENDEE | Organizer, Attendees, as "Name " |
| RRULE | Repeats, in words: "Weekly on Mon, Wed, 10 times" |
All-day events show their real last day. The file stores the day after the event ends, so a 24-26 December holiday is written with an end of the 27th; the table says the 26th and marks it All day.
The rest of the article, and all 6 questions about ICS to CSV Converter, are on the ICS to CSV Converter page.
Drop the .ics file on ICS to CSV Converter. Every event is read in your browser and a preview shows the first rows with title, start, end and location. Press Download CSV or Download Excel to save one row per event, ready to sort and filter in Excel, Google Sheets or Numbers.
In Google Calendar on a computer, open Settings, Import and export, then Export. Google saves a zip with one .ics file per calendar. Unzip it, drop the .ics files here together and press Download Excel: the Calendar column says which calendar each event came from.
No. A repeating event is one row with its rule written in words, such as Weekly on Mon and Wed, 10 times, plus its first date. Expanding endless rules would make an endless table, so the rule is kept as the calendar itself stores it.
No. The .ics files are read by your own browser and the CSV or Excel file is made on your device. Meeting titles, attendees and places never reach a server, and nothing is kept after you close the tab.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about ICS to CSV Converter and anybody who knows can answer. No account needed.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible · Markdown File to HTML – Turn a .md file into the HTML behind it.