Google Calendar to Excel and CSV converter

Free. Your calendar file is read by your browser and the Excel file is created there too: nothing is uploaded, no account, no Google sign-in.

What you get

One line per event, in order of start time, with these columns:

Column	What it holds
Date	The day the event starts, as a real date that Excel can sort and filter.
Start, End	Times in your computer's time zone. In the Excel file they keep their full date, so =C2-B2 still works for an event that ends after midnight.
Duration	Hours and minutes, formatted [h]:mm so that a total of 26 hours shows 26:00, not 2:00.
Hours	The same duration as a decimal number (1.50 for 1 h 30), ready to multiply by an hourly rate.
Title, Calendar, Location, Description	As written in Google Calendar.

The Excel file adds a total line under the events, with SUM formulas. The CSV file holds the events only, so it imports cleanly into another tool.

What the converter takes care of

• Recurring events, one line per occurrence. Google's export stores a weekly meeting once, with its repeat rule. The converter writes every date in the period, without the dates you deleted, moved or cancelled.
• Only the period you choose. Google exports the whole history of each calendar; you pick the dates. An event that crosses the start or end of the period is cut there and marked "(partial)".
• No double counting. A meeting found in two calendars appears once. Declined invitations and all-day events are left out unless you untick them.
• A CSV that opens in columns. Where your browser's language writes decimals with a comma, as in French or German, the CSV is separated by semicolons, which is what Excel expects there. It is saved in UTF-8 with a byte order mark, so accents and other alphabets come through.
• No formula surprises. In the CSV, a title that starts with = or + gets an apostrophe in front of it, so Excel shows it as text instead of running it as a formula.

How to export your Google Calendar

1. On a computer, open Google Calendar. Google's help page notes that the phone app cannot export.
2. Open Settings, then Import & export, then Export. A .zip with one .ics file per calendar downloads.
3. Drop that .zip above. There is no need to unzip it. To export a single calendar instead, open its Settings and sharing page and choose Export calendar.

You can export a calendar if you have the "Make changes and manage sharing" permission on it.

Open the file in Google Sheets

In Google Sheets, click File at the top, then Import, and choose the .xlsx file. Dates, times, durations and the total come through as they are. To keep a sheet up to date every month without exporting again, the guide to exporting Google Calendar to Google Sheets compares the automatic options.

Questions

Is my calendar uploaded?

No. The page has no server behind it: your browser opens the export, builds the Excel or CSV file and saves it to your computer. Nothing is stored or sent, and closing the tab forgets everything. The privacy policy says the same.

Why is there no colour column?

Google Calendar's export leaves event colours out, so no converter can read them from the file. Calendar Timesheet reads colours directly from your calendar; the guide how to count hours in Google Calendar per client, colour or week compares the methods.

Which time zone are the times in?

Your computer's time zone, shown above the preview. Events created in another time zone are converted to it, the way Google Calendar shows them to you.

Can I export from my phone?

Google Calendar's export only works on a computer. For a total you can read anywhere, see Can Google Calendar calculate hours worked?

I only need the total hours

The Google Calendar hours calculator reads the same export and adds it up by calendar, keyword and week, with no file to open. To round durations to 6 or 15 minutes and price them, use the billable hours calculator.