Skip to content

For teams & companies: meet Ridian

Kalender Sync by
Try for free
ICS toolkit

Convert ICS to CSV and open it in Excel

Turn a calendar export from Google, Outlook or iCloud into a table that opens in Excel or Google Sheets. Your file is never uploaded: everything runs locally in your browser, we never see a single event.

Paste text instead

Works with GoogleOutlookApple and every common calendar

Processed locally with ical.js (MPL-2.0).

More ICS tools

See all →

In three steps

  1. 01

    Export to ICS

    Google Calendar: Settings → Import & export → Export (unzip it). Outlook: Save calendar → .ics. Apple: Calendar → Export.

  2. 02

    Convert

    Drop the file in, check range and time zone. Recurring events can be split into single rows.

  3. 03

    Open in Excel

    Download the CSV and open it. Columns match Google Calendar's import format.

Exporting a calendar as ICS: provider by provider

To convert, you first need an .ics file. Here's how to get one out of the common calendars:

Google Calendar

calendar.google.com → gear → Settings → Import & export → Export. You get a ZIP with one .ics per calendar. For a single calendar: pick it on the left in Settings → "Export calendar".

Outlook

Classic Outlook (Windows): open the calendar → File → Save Calendar → choose range and detail → save.

New Outlook and Outlook on the web have no file export. Workaround: Settings → Calendar → Shared calendars → Publish a calendar, copy the ICS link and open it in your browser to download the file.

Apple Calendar and iCloud

Mac: select the calendar in the sidebar → File → Export → Export. iCloud on the web can't export; share the calendar publicly there and open the webcal:// link in your browser with https:// instead of webcal://.

Opening the CSV in Excel

  • A double-click usually does it; the file is UTF-8 so accents survive.
  • Everything in column A? Your Excel expects a different separator: switch it above and download again, or use Data → From Text/CSV in Excel.
  • Google Sheets: File → Import → Upload, let it detect the separator.

FAQ

How do I export Google Calendar to Excel?
Export the calendar as ICS (Settings → Import & export), unzip it and convert the .ics here. The CSV opens directly in Excel or Google Sheets.
How do I export my Outlook calendar to Excel?
Save the calendar as .ics in Outlook ("Save calendar") and convert it here. This also works for new Outlook and Outlook on the web, which no longer offer a CSV export.
Why is everything in one column in Excel?
Your Excel expects a different separator. Pick "semicolon" instead of "comma" (or the other way round) before downloading.
What happens to recurring events?
By default every occurrence within the chosen range becomes its own row. The rule itself is kept in the "Recurrence" column.
Can I import the CSV into a calendar again?
Yes, the columns follow Google Calendar's import format. For a lasting connection between two calendars, though, a sync is the better route.

Done with exporting and importing?

An ICS file is a snapshot. Kalender Sync keeps Google, Outlook, iCloud and more in sync continuously, GDPR-compliant and hosted in Germany.

Start for free

Currently supported providers

GoogleMicrosoftApple iCloudKKSuiteGMXWEB.DEmailbox.orgiCal-Feeds