ICS to CSV Converter

Convert iCalendar (.ics) files from Google Calendar, Outlook, or Apple Calendar to CSV — open in Excel or Google Sheets instantly.

100% freeNo software neededData never leaves your browser
1
2
Upload file

Drop your ICS file here

or click to browse

How to export your calendar to ICS

Google Calendar

  1. 1Go to calendar.google.com
  2. 2Click the gear icon > Settings
  3. 3Click Import & Export > Export
  4. 4Extract the downloaded ZIP file

Outlook

  1. 1Open Outlook
  2. 2File > Open & Export > Import/Export
  3. 3Export to a file > iCalendar format
  4. 4Choose your calendar and save

Apple Calendar

  1. 1Open Calendar on Mac
  2. 2Select a calendar in the sidebar
  3. 3File > Export > Export
  4. 4Save the .ics file

What can you do with calendar data in CSV?

Time tracking

Calculate total hours spent on meetings, projects, or clients using Excel formulas.

Billing analysis

Filter events by client name and sum durations to generate invoices from calendar data.

Team reporting

Share calendar data with people who don't use the same calendar app.

Database import

Import events into a database, CRM, or project management tool via CSV.

Frequently asked questions

What is an ICS file?

ICS (iCalendar) is the standard file format for calendar data. Google Calendar, Outlook, Apple Calendar, and virtually every calendar app can export to ICS format.

What columns does the CSV output contain?

The output CSV includes: SUMMARY (event title), DTSTART (start date/time), DTEND (end date/time), LOCATION, DESCRIPTION, and UID (unique event ID). All-day events and timed events are both supported.

How do I export my Google Calendar as ICS?

In Google Calendar, go to Settings (gear icon) > Import & Export > Export. Google downloads a ZIP file — extract it to find your ICS files.

How do I export from Outlook?

In Outlook, go to File > Open & Export > Import/Export > Export to a file > iCalendar format (.ics). Choose the calendar and save location.

How do I export from Apple Calendar?

In Apple Calendar (Mac), select a calendar from the sidebar, then go to File > Export > Export. This saves the calendar as an ICS file.

Can I analyze calendar data in Excel?

Yes — once converted to CSV, you can open it in Excel or Google Sheets. Use DATEDIF to calculate event durations, pivot tables to summarize time by category, or charts to visualize your schedule.