OLI2

Export Google Calendar to CSV or Excel

Google Calendar only exports ICS — a file built for other calendars, not for spreadsheets. OLI2 gives you a clean CSV instead: one row per meeting, one column per field, ready to open in Excel, Google Sheets or Numbers.

Read-only access to your calendar. Free to start.

What’s in the file

Every meeting becomes one row, with these columns:

Start dateStart timeEnd dateEnd timeTitleLocationAttendeesCategoryDuration (mins)
14/08/2026 09:30 14/08/2026 10:00 Weekly 1:1 Room 1.11 Oli Tew 1-1s 30

Attendees arrive as a single readable list per meeting, and durations are already in minutes — so you can pivot on them without cleaning the data first.

How to export your Google Calendar

1

Connect Google Calendar

Sign in with Google. OLI2 syncs your meetings with read-only access.

2

Filter to what you need

Pick a date range, or narrow by person, category or keyword.

3

Download the CSV

Export → CSV. The file matches your filters exactly.

Why not just use Google’s own export?

Google Calendar’s export gives you an ICS file. That’s the right format for moving a calendar into another calendar, but it’s a poor fit for analysis: events are spread across repeated text blocks rather than rows, recurring meetings are stored as rules instead of individual occurrences, and attendee lists need unpicking before a spreadsheet can count anything.

OLI2 expands recurring meetings into the occurrences that actually happened, resolves attendees to names, and hands you rows you can sort, filter and pivot immediately.

Once your calendar is a spreadsheet

Most people export because they want an answer: how much time goes to recurring meetings, which people take up the most of the week, what a month actually costs in person-hours. OLI2 answers those on screen too — the CSV is just the version you can take to a board pack.

  • Sort meetings into your own categories, with your own rules
  • See time and cost by category, person or team
  • Export the same view as PDF or a plain-text summary

Questions

Can I export my Google Calendar to Excel?

Yes. The download is a CSV file, which Excel opens directly — as do Google Sheets, Numbers and LibreOffice. To be clear: there’s no .xlsx download. CSV is the format, and it imports with one column per field, so you can save it as a workbook yourself in a click if you want one.

Can I export a whole year at once?

Yes. The file streams as it’s generated rather than being assembled in memory, so a wide date range downloads without timing out.

Does it include meetings I declined?

The export contains whatever the page you exported from is showing, so filter first and the file follows.

What about Outlook or Office 365?

Microsoft calendar support is in progress. Google Calendar is available today.

Is my calendar data private?

OLI2 asks for read-only calendar access and never writes to your calendar. You can delete your account and everything synced with it at any time — see our privacy policy.

Get your calendar as a spreadsheet

Connect Google Calendar and export in about two minutes.

See everything OLI2 does