Free ICS to CSV converter Convert a calendar file to a spreadsheet ======================================== Turn an .ics file into a CSV you can open in Excel, Numbers or Google Sheets. Every event becomes a row. Free, nothing stored. Sharing these events, not just filing them? If you are exporting because you need to share these events with people, there is a shorter path. The builder on our homepage turns an event into one link that adds itself to any calendar, stays editable, and reports who added it. Includes 10 events a month and 50 RSVPs per event at no cost. The free tool below still works if you just need the raw output. [ Build a real event link, free](https://addcal.co/)[ See how it works ](https://addcal.co/solutions/add-to-calendar-links.md) Show times inMy timezone (UTC)UTCLeave as-is (each event's own timezone) Times are converted to this timezone and written as `2020-01-01 10:11:00`, ready for a spreadsheet. All day events are never shifted. Drag an .ics file here Your file is parsed and discarded. Nothing is stored. Choose an .ics file Or paste the file contents Read pasted calendar What you get -------------- The CSV has one row per event and a header row, with these columns: | Column | What it holds | | --- | --- | | title | The event name | | starts_at | Start time, e.g. 2020-01-01 10:11:00 | | ends_at | End time, same format | | timezone | The timezone the times are shown in | | is_all_day | yes or no | | location | Address or meeting link | | description | Event description | | recurrence_rule | The RRULE, for repeating events | | uid | The event's unique id | Why convert a calendar to CSV? -------------------------------- A spreadsheet is far easier for reporting than a calendar file: totalling hours across a project, auditing what actually got scheduled, sharing a season's fixtures with someone who does not want a subscription, or moving events into another system that imports CSV. Timezones and date format --------------------------- Calendar files store times with an offset, which is correct but awkward in a spreadsheet. Pick a timezone above and every timed event is converted into it and written as `2020-01-01 10:11:00`, which Excel, Numbers and Google Sheets all parse as a real date. The default is your own timezone, so a meeting shows the time you actually attended it. All day events are never converted. They have no time of day, so shifting them across timezones would push them onto the wrong date. A note on repeating events ---------------------------- A weekly meeting is stored once with a rule, not as 52 separate events. We export it as one row and put the rule in the `recurrence_rule` column, so a single recurring meeting does not flood your spreadsheet. If you want to inspect the file first, try the [ ICS viewer ](https://addcal.co/tools/ics-viewer.md). More free calendar tools -------------------------- [AI text to calendar converter ](https://addcal.co/tools/text-to-calendar.md)[ICS file viewer ](https://addcal.co/tools/ics-viewer.md)[ICS file generator ](https://addcal.co/tools/ics-generator.md)[Import ICS to Google Calendar ](https://addcal.co/tools/import-ics-to-google-calendar.md)[Add to calendar link generator ](https://addcal.co/tools/add-to-calendar-link-generator.md) FAQ Common questions ---------------- ### How do I convert an ICS file to CSV? Upload your .ics file above and download the CSV. Each event becomes a row with its title, start and end time, timezone, location, description and recurrence rule. ### Can I open the result in Excel or Google Sheets? Yes. The file is standard CSV and dates are written as 2020-01-01 10:11:00, which Excel, Numbers and Google Sheets all recognise as a real date rather than plain text. ### What timezone are the times in? Whichever you pick before converting. It defaults to your own timezone, so events show the local time you experienced them. You can also choose UTC, or leave each event in its original timezone. All day events are never shifted, because they have no time of day. ### How are recurring events handled? A repeating event is exported as a single row with its recurrence rule in the recurrence_rule column, rather than one row per occurrence. Free forever, start in 30 secondsFill your next event's seats. Starting with your first link. ------------------------------------------------------------ Create a working calendar link in under a minute. No credit card, no trial clock, no catch. [ Create my first event, free ](#event-form)[ or compare plans and pricing ](https://addcal.co/pricing.md) ![Rachel Kim](https://cdn.addcal.co/0e6b8af/build/assets/test_1-D_w4B6C6.jpg)![Daniel Ortega](https://cdn.addcal.co/0e6b8af/build/assets/test_2-DqHKeMBW.png)![Priya Mehta](https://cdn.addcal.co/0e6b8af/build/assets/test_3-Csszw6s7.png) 15,000+ creators & teams Free forever ยท no credit card