ICS to CSV Converter
Turn a Google Calendar, Outlook or Apple Calendar export (.ics) into a CSV or Excel list of events, with times in your own time zone. Free, no sign-in, and nothing is uploaded.
Drop your file here or choose a fileTap to choose a file
Opened on your device - never uploaded · up to 50MB
Supports .ics, .ical, .ifb, .txt · or paste a file from your clipboard
No file handy? · download it
How to Convert an ICS File to CSV
- Export the calendar as .ics (steps for each app are below).
- Drop the .ics file above or paste its text. It is read in your browser.
- Pick the time zone and formats. Times are shown in your computer's zone unless you choose another.
- Download CSV or Excel.
Exporting the .ics File
Google Calendar
On a computer, open Google Calendar, click the gear icon and choose Settings > Import & export > Export. You get a ZIP with one .ics file per calendar. For a single calendar, open it under Settings for my calendars and choose Export calendar.
Outlook for Windows
Open the calendar, then File > Save Calendar. Use More Options to choose the date range and how much detail to include, and save the .ics file.
Apple Calendar on Mac
Select the calendar in the sidebar, then File > Export > Export and save the .ics file.
What Is in the CSV
One row per event, with columns in the order Outlook and Google Calendar use for CSV import - Subject, Start Date, Start Time, End Date, End Time, All Day Event, Location, Description - followed by Organizer, Attendees, Categories, Recurrence, Status, Time Zone and the event's UID. Text escapes in the calendar file (\, and \n) are turned back into commas and line breaks, and long lines the calendar folded are joined.
All-day events have no times, and their End Date is the last day of the event. In the .ics file itself an all-day event ends at the start of the following day, which reads as one day too many in a spreadsheet.
Time Zones
Calendars store times three ways: in UTC (most of a Google export), in a named zone such as America/Chicago, or as "floating" times with no zone. UTC times and named-zone times are converted to the zone you choose, with daylight saving applied on the right dates. Floating times, and Outlook's Windows zone names such as "Eastern Standard Time", are kept exactly as written; the Time Zone column says which zone each row is in.
Using the Event List
A calendar as a spreadsheet answers questions the calendar app cannot: how many hours went to each client last quarter, which meetings had no agenda, who attended what. Total durations with a pivot table, or log billable time in the timesheet template. To go the other way and create calendar events from a spreadsheet, use Excel to Calendar.
Frequently Asked Questions
In Google Calendar open Settings, choose Import & export, then Export. Google downloads a ZIP with one .ics file per calendar; unzip it, drop the calendar's .ics file here and download CSV or Excel. To export a single calendar, open its settings under 'Settings for my calendars' and choose Export calendar.
Google Calendar stores most times in UTC. The converter shows them in the time zone you pick - your computer's zone by default - so a 10:00 meeting in New York reads 10:00, not 15:00. Choose 'As written in the file' to keep the raw times.
No. A recurring event is one row with its first occurrence and the recurrence rule (for example FREQ=WEEKLY;BYDAY=MO) in the Recurrence column. That keeps the file honest about what the calendar stores; an open-ended weekly meeting would otherwise produce endless rows.
Yes. The first columns - Subject, Start Date, Start Time, End Date, End Time, All Day Event, Location, Description - are the ones both programs map on CSV import. Use US dates and 12-hour times for Outlook in the US.
No. The .ics file is read in your browser and the CSV is created there. Meeting titles, attendees and notes never leave your computer.