How to Export Google Calendar Events to a CSV File

While Google Calendar is an excellent tool for managing your daily schedule, sometimes you need to extract your schedule for use outside of the Google ecosystem. Whether you need to import your itinerary into a different calendar app, analyze your time-management habits in Microsoft Excel, or provide a raw data export for an employer, Google provides a way to export everything.

However, Google exports calendar data in the universal .ics (iCalendar) format by default, not the .csv (Comma Separated Values) format preferred by spreadsheet applications. To get a CSV file, you must use a specific workaround.

Step 1: Export Your Calendar as an ICS File

First, we must extract the raw data from Google.

1. Open a web browser and navigate to calendar.google.com. (This cannot be done from the mobile app).
2. Click the Gear icon in the top-right corner and select Settings.
3. In the left-hand sidebar, click on Import & export.
4. Under the “Export” section, you will see a button labeled Export. Click it.
5. Google will immediately generate and download a ZIP file to your computer containing the .ics files for all your calendars.
6. Locate the downloaded ZIP file on your computer and extract (unzip) it to reveal the .ics file.

Step 2: Convert the ICS File to CSV

Since Google refuses to output a CSV directly, you must convert the .ics file. You have two options here: using a free online converter, or importing the data into Outlook first.

Method A: Using an Online Converter (Fastest)

If your calendar does not contain highly sensitive corporate secrets, the fastest method is to use a free online tool.

1. Search the web for a free “ICS to CSV converter” (there are dozens of safe, reputable websites dedicated entirely to this single task).
2. Upload the .ics file you extracted in Step 1.
3. Click Convert and download the resulting .csv file.

Method B: Using Microsoft Outlook (Most Secure)

If your calendar contains confidential information, you should handle the conversion locally using the desktop version of Microsoft Outlook.

1. Open the Outlook desktop app on your PC.
2. Go to File > Open & Export > Import/Export.
3. Select Import an iCalendar (.ics) or vCalendar file (.vcs) and click Next.
4. Browse to your downloaded .ics file and select it. Click Import. (Your Google events are now inside Outlook).
5. Go back to File > Open & Export > Import/Export.
6. This time, select Export to a file and click Next.
7. Select Comma Separated Values (CSV) and click Next.
8. Select the Calendar folder you just imported into, click Next, and save the CSV file to your hard drive.

You can now open this CSV file in Excel, Google Sheets, or Apple Numbers to view your schedule in a perfect row-and-column layout.