Convert ICS Calendar to CSV: Complete Guide

What is an ICS File?

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

Why Convert ICS to CSV?

• Analyze meeting time with clients in Excel
• Track project time across calendar events
• Calculate total hours spent on recurring events
• Import calendar data into databases or BI tools

How to Export Your Calendar to ICS

Google Calendar:

1. Go to settings (gear icon)
2. Click "Import & Export"
3. Click "Export" to download a ZIP with ICS files

Outlook:

1. File > Open & Export > Import/Export
2. Export to a file > iCalendar format

Apple Calendar:

1. Select a calendar
2. File > Export > Export

Using the ICS to CSV Converter

1. Upload your ICS file.
2. Download the CSV — each VEVENT becomes a row.
3. Open in Excel or Google Sheets.

CSV Columns

The output CSV includes:

• SUMMARY: Event title
• DTSTART: Start date/time (YYYY-MM-DD HH:MM)
• DTEND: End date/time
• LOCATION: Event location
• DESCRIPTION: Event description
• UID: Unique event identifier

Tips for Calendar Analysis

• Use Excel's DATEDIF formula to calculate event duration
• Filter by SUMMARY to analyze time on specific projects
• Pivot tables work great for weekly/monthly time summaries