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