Privacy First
Uploaded files are automatically and permanently deleted within two hours.
Automatic deletion
ICS to Excel
Turn an iCalendar export from Google Calendar, Outlook, Apple Calendar or a booking system into an Excel sheet you can sort, filter and analyse
-
One row per event: Every VEVENT in the ICS becomes a spreadsheet row with Title, Description, Location, Starts and Ends columns.
-
Native XLSX: The output is a real Excel workbook built with LibreOffice, not a CSV, so it opens with formatting in Excel, Numbers and Google Sheets.
-
Any ICS source: Google Calendar, Outlook and Exchange exports, iCloud, Nextcloud, Teamup, Calendly and ticketing systems all produce compatible files.
With this free converter you can process up to 20 ICS (Internet Calendaring and Scheduling) files at one time.
Calendar data
How an ICS calendar becomes an Excel sheet
An ICS file is a text list of calendar components in the iCalendar format (RFC 5545). The converter parses every event with a standards-compliant library, writes the key fields into a table and converts that table into an XLSX workbook.
How to use Converter App
1
Export your calendar as ICS
In Google Calendar: Settings, Import and export, Export. In Outlook: File, Save Calendar. Then upload the .ics file here.
2
Events are parsed
Each event's summary, description, location, start and end are read and written as a row.
3
Download the XLSX
Open it in Excel, add filters or pivot tables, or import it into another system.
Key features
Reliable parsing
The iCalendar parser handles folded lines, escaped characters, time zones and all-day events as defined in the standard.
Ready for analysis
Count meetings per week, total hours per client, or filter by location with ordinary spreadsheet tools.
Migration friendly
A sheet is the easiest way to review, clean and bulk-edit events before importing them into a new calendar or CRM.
Private
Calendars contain personal data. Files are deleted automatically within two hours and never read by anyone.
Experience & privacy
Built for reliable document conversion.
Backed by 10+ years of engineering expertise in large-scale data and scientific computing, it’s built for real-world document workflows that require accurate layout preservation, strict privacy, and dependable, high-level performance.
Trusted by Users
Rated 5 stars on Trustpilot for speed, reliability, and ease of use.
User trust
Academic Use
Referenced in published research and used for interview transcription and qualitative data analysis.
Research use
Why put a calendar in a spreadsheet
Calendars are good at showing what happens next and bad at answering questions about the past: how many client meetings last quarter, how many hours were booked per room, which events have no location, who the busiest week belonged to. A spreadsheet answers these with a filter or a pivot table. Freelancers use an ICS export to bill hours, administrators audit room bookings, teachers tally lessons, and people migrating between calendar services review and clean up years of entries before importing them somewhere new.
What is inside an ICS file
iCalendar is a plain-text format standardised in RFC 5545. A file contains a VCALENDAR with any number of VEVENT, VTODO and VJOURNAL components; each event lists properties such as SUMMARY, DESCRIPTION, LOCATION, DTSTART, DTEND, RRULE for recurrence, ORGANIZER and ATTENDEE. Lines longer than 75 characters are folded, special characters are escaped, and dates come in several forms: floating local time, time with a TZID, UTC with a trailing Z, or date-only for all-day events. A correct converter must understand all of this, which is why ours uses a dedicated iCalendar parsing library rather than text matching.
How the conversion works
The ICS is parsed into components. For every VEVENT the converter reads the summary, description, location, start and end (with their UTC offsets) and writes them as a row into a UTF-8 CSV table, so accented characters and non-Latin scripts survive. LibreOffice then converts the table into an XLSX workbook with a header row. Only events are exported; tasks and journal entries are skipped. The file is produced on our servers and deleted, together with the upload, within two hours.
Working with the data in Excel
- Convert the Starts and Ends columns to date-time values (Data, Text to Columns, or a DATEVALUE formula) if Excel shows them as text.
- Add a Duration column: =Ends-Starts, formatted as [h]:mm.
- Use a pivot table on Title or Location to count or sum hours.
- Sort by Starts to see the calendar chronologically; filter blank Locations to find incomplete entries.
- To reimport cleaned events, save as CSV and import it into Google Calendar or Outlook, both of which accept CSV event lists.
FAQ
Frequently Asked Questions
Which columns does the Excel sheet contain?
Title (SUMMARY), Description, Location, Starts (DTSTART) and Ends (DTEND), in that order, followed by a repeated Location column, with a header row. Multi-line descriptions are kept as multi-line cells. Other iCalendar properties such as attendees, organiser, categories, alarms and URLs are not exported in this version. If you need those, convert the ICS to CSV and extend the mapping in a spreadsheet, or ask us.
How are recurring events handled?
A recurring series appears once, as the master event with its first start and end. The individual occurrences generated by the recurrence rule are not expanded into separate rows. For a complete list of every occurrence, export the calendar from a program that expands recurrences, for example by printing a date range to CSV from Outlook, or expand them in Excel with a formula.
In which time zone are the dates shown?
In the time zone the ICS specifies, written with its UTC offset, for example 2026-11-05 09:00:00+01:00 for an event stored with TZID=Europe/Berlin, or +00:00 for events exported in UTC. Excel treats such values as text until you convert them; a formula like =DATEVALUE(LEFT(D2,10))+TIMEVALUE(MID(D2,12,8)) turns them into real date-times, and you can add or subtract hours for a different zone.
Do all-day events work?
Yes. All-day events have date-only values; they appear with the date and no time. Note that the iCalendar standard defines the end date of an all-day event as exclusive, so a one-day event on 5 March is stored as starting 5 March and ending 6 March.
Can I convert several calendars at once?
Yes, upload multiple ICS files; each becomes its own XLSX and they are returned together in a ZIP. To merge them into one sheet, copy the rows together in Excel afterwards.
What about Outlook .pst or Google Calendar links?
The converter needs an .ics file. Outlook can save any calendar as ICS via File, Save Calendar; Google Calendar offers an ICS export per calendar in its settings, and the public ICS address of a shared calendar can be downloaded with a browser and uploaded here.