Google Calendar is great at showing your schedule and terrible at answering questions about it. How many hours of meetings last quarter? Which days did the team book the workshop? For that you want the events in a spreadsheet — and Google offers no direct "export to Excel."
Step 1: Export Your Calendar from Google
In Google Calendar on the web: Settings → Import & export → Export. You'll get a ZIP file containing one .ics file per calendar. (Need to open the ZIP? There's an extractor for that too.)
Step 2: Convert ICS to CSV
Drop the .ics file into the ICS to CSV converter. Every event becomes a spreadsheet row with columns for Summary, Start Date, End Date, All Day, Location, Description, Status, URL, Organizer, and Categories — ready to sort, filter, and pivot in Excel or Google Sheets.
The calendar is parsed in your browser with a proper iCalendar parser (line folding and escaping handled), and nothing is uploaded — your schedule stays yours.
Step 3 (Optional): Analyze
- Sort by Start Date and subtract columns for meeting durations
- Pivot on Organizer or Categories to see where the time goes
- Filter All Day = Yes to separate events from deadlines
Going the Other Way
Built a schedule in a spreadsheet — a rota, a season of fixtures, a course timetable? The CSV to ICS converter turns it back into a calendar file Google Calendar imports in one step. Developers can use ICS to JSON for structured event data. All the tools are on the calendar converters page.