Export Google Calendar to Excel or CSV
Google Calendar's own export gives you an .ics file. That is a format for calendar apps, and Excel shows it as lines of code, not as a table. The reliable route goes through Google Sheets.
The short version
- Export your events into a Google Sheet with an add-on. You get one row per event.
- In Google Sheets, choose File, then Download, then Microsoft Excel (.xlsx) or Comma-separated values (.csv).
- The whole thing takes about a minute, and you choose the calendars and the dates.
Why the built-in export does not help
In Google Calendar, Settings, then Import & export, then Export downloads a ZIP file with one .ics file for each calendar. That is useful for moving to another calendar app. It falls short for a spreadsheet in two ways:
- It is not a table. An .ics file stores each event as a block of text, so there are no columns to sort, filter or add up.
- It has no date filter. You get every event the calendar has ever held, not just last month.
Step 1: Put your events in Google Sheets
DropScribe Calendar Export is an add-on for Google Sheets. It is free for 14 days with everything unlocked.
- Install DropScribe Calendar Export from the Google Workspace Marketplace and approve the permissions Google shows you.
- Open a spreadsheet and follow the menu below. The panel opens on the right.
Extensions then DropScribe Calendar Export then Open
- Under Calendars, tick the ones you want.
- Under Date range, choose a preset such as Last month, or click Pick dates for your own range.
- Click Export events.
The first five of the ten columns. Each event is one row.
Get last month's events as a table
Free for 14 days with everything unlocked. No card needed.
Step 2: Download the sheet
With the exported sheet open, follow one of these menus in Google Sheets.
File then Download then Microsoft Excel (.xlsx)
File then Download then Comma-separated values (.csv)
- Choose .xlsx for Excel. Start and End stay real dates, so you can sort and filter by them, and the total row keeps its formula.
- Choose .csv for other tools, such as accounting or time-tracking software. A CSV file holds only the sheet you are looking at, so open the exported sheet first.
What is in the file
| Column | What it holds |
|---|---|
| Calendar | The name of the calendar the event came from. |
| Title | The name of the event. |
| Start, End | The date and time, in your spreadsheet's time zone. All-day events show the date alone. |
| Hours | End minus start, to two decimal places. Left empty for all-day events. |
| All day | Yes for an all-day event. |
| Location, Description | The text from the event. |
| Guests | The guests' email addresses, separated by commas. |
| Link | A link that opens the event in Google Calendar. |
A repeating event gets one row for each time it happens inside your dates. The last row adds up the Hours column.
If you need the file regularly
Under Save to, choose The same sheet. Each export then rewrites a sheet named Calendar export, so you download from the same place every time. On Pro, Daily refresh runs the export again every day, and the sheet is already current when you open it.
Questions
Can I export only a date range?
Yes. Choose This month, Last month, Last 30 days or Next 30 days, or pick your own start and end dates. Google Calendar's own export has no date filter.
Can I put several calendars in one file?
Yes. During the trial and on Pro you can tick up to 20 calendars for one export, and the Calendar column says which one each event came from. The Free plan exports 1 calendar at a time.
How many events can I export?
Up to 5,000 events per export during the 14-day trial and on Pro, and 50 per export on the Free plan.
Is my calendar sent to a server?
No. The add-on runs inside your own Google account and copies events from Google Calendar to your Google Sheet. DropScribe runs no server for it.