Unfortunately, Google Calendar does not offer any method of directly exporting a calendar to MS Excel in CSV format. But Excel can open the iCal file from Google calendar just as easily. To start with, you must let Google calendar export the calendar in ICS format.
Once the ICS file is available, you have three ways of exporting it to Excel.
3 ways to Export Google Calendar ICS File to MS Excel
- Open ICS file in Excel
- Use MS Outlook to export to CSV format
- Use an online application to export to CSV format
Please note the CSV format does not support repeat events.
You will also lose information on reminders, event time-zone data, attachments, invitations and so on.
We will show you in simple, step-by-step instructions, three methods of exporting Google calendar to Excel.
Let us begin.
Method #1: Open ICS File in Excel
Step #1: Open Google Calendar
Login to the Google suite using your credentials.
Open Google Calendar.
Step #2: Open the Exports Menu
Click on the gear icon in the top right corner.
This opens a menu.
Click on Settings.
This opens the detailed Settings menu.
Scroll down and click on Import and export in the left panel.
This will open a secondary menu.
Click on Export.
Step #3: Export the Calendar
In the right pane, under Export, click on Export.
This will open the File Manager.
Navigate to the location where you want to save the calendar file.
Type a suitable File name: for the calendar file.
Ensure that Save as Type: is Compressed (Zipped) folder.
Click on the Save button at the bottom.
A notification will appear for the saved file.
Step #4: Unzip the Calendar File
In the bottom of your browser window, a message will be displayed: Show all downloads.
Click on Show all downloads.
The File Manager will open.
Click on the zipped ICS file you just created.
Depending on your operating system, you may have to double click on the zipped file to unzip and open it.
The zipped file will open to show two files.
Right-click on the file with your Google id as its name.
A menu will open, click on Copy.
Navigate to the place where you want to save the calendar file.
Paste the calendar file.
Rename it if necessary.
Step #5: Open Calendar File in Excel
Open the Excel application.
Click on File in the main menu bar.
Click on Open in the dropdown menu.
The File Manager window will open.
Navigate to the location of the calendar file.
Click on the file name.
Click on the Open button in the File Manager window.
A Text Import Wizard will open.
Click on and select Delimited.
Click on the Next button at the bottom.
The next screen opens.
Click on and select Comma.
Click on the Next button at the bottom.
The next screen opens.
Click and select Text.
Click on the Finish button at the bottom.
MS Excel displays the contents of the calendar file.
Caution: You may lose some information if you save the file in CSV format. Instead, save it as an Excel file.
Method #2: Use MS Outlook to Export as CSV
Step #1: Open Google Calendar
Login to the Google suite using your credentials.
Open Google Calendar.
Step #2: Open the Exports Menu
Click on the gear icon in the top right corner.
This opens a menu.
Click on Settings.
This opens the detailed Settings menu.
Scroll down and click on Import and export in the left panel.
This will open a secondary menu.
Click on Export.
Step #3: Export the Calendar
In the right pane, under Export, click on Export.
This will open the File Manager.
Navigate to the location where you want to save the calendar file.
Type a suitable File name: for the calendar file.
Ensure that Save as Type: is Compressed (Zipped) folder.
Click on the Save button at the bottom.
A notification will appear for the saved file.
Step #4: Unzip the Calendar File
Click on Show all downloads.
The File Manager will open.
Click on the zipped ICS file you just created.
Depending on your operating system, you may have to double click on the zipped file to unzip and open it.
The zipped file will open to show two files.
Right-click on the file with your Google id as its name.
A menu will open, click on Copy.
Navigate to the place where you want to save the calendar file.
Paste the calendar file.
Rename it if necessary.
Step #5: Import Calendar in Outlook
Open the MS Outlook program.
Click on the File tab in the top main menu bar.
This opens the File menu.
Click on Open & Export in the left pane.
In the right pane, click on the Import/Export button.
The Import Export Wizard will open.
Click on Import an iCalendar (ics) or vCalendar file (vcs).
Click on the Next button at the bottom.
This will open the File Manager.
Navigate to the location of your calendar file.
Click on the calendar file name.
A dialog box will open.
Click on the Import button.
Outlook will import the calendar.
Step #6: Export as CSV File
Click on the File tab in the top main menu bar.
The File menu will open.
Click on Open & Export in the left panel.
In the right panel, click on the Import/Export button.
The Import and Export Wizard will open.
Click on Export to a File.
Click on the Next button at the bottom.
In the next dialog box, click on Comma Separated Values.
Click on the Next button at the bottom.
In the next screen, click on Calendar (This computer only).
Click on the Next button at the bottom.
In the next screen, you can change the location and name of the exported file.
Make the necessary changes, and click on the Next button at the bottom.
In the next screen, click on the Finish button at the bottom.
In the next screen, you can change the date range if you want.
Click on the OK button at the bottom.
Outlook will export your calendar in CSV format.
Step #7: Open CSV File in Excel
Open the Excel application.
Click on File in the main menu bar.
Click on Open in the dropdown menu.
The File Manager window will open.
Navigate to the location of the CSV file.
Click on the CSV file name.
Click on the Open button.
A Text Import Wizard will open.
Click on and select Delimited.
Click on the Next button at the bottom.
The next screen opens.
Click on and select Comma.
Click on the Next tab at the bottom.
The next screen opens.
Click and select Text.
Click on the Finish button at the bottom.
Excel now displays the contents of the CSV file.
Caution: You may lose some information if you save the file in CSV format. Instead, save it as an Excel file.
Method #3: Use an Online Application to Export to CSV Format
Step #1: Open Google Calendar
Login to the Google suite using your credentials.
Open Google Calendar.
Step #2: Open the Exports Menu
Click on the gear icon in the top right corner.
This opens a menu.
Click on Settings.
This opens the detailed Settings menu.
Scroll down and click on Import and export in the left panel.
This will open a secondary menu.
Click on Export.
Step #3: Export the Calendar
In the right pane, under Export, click on Export.
This will open the File Manager.
Navigate to the location where you want to save the calendar file.
Type a suitable File name: for the calendar file.
Ensure that Save as Type: is Compressed (Zipped) folder.
Click on the Save button at the bottom.
A notification will appear for the saved file.
Step #4: Unzip the Calendar File
Click on Show all downloads.
The File Manager will open.
Click on the zipped ICS file you just created.
Depending on your operating system, you may have to double click on the zipped file to unzip and open it.
The zipped file will open to show two files.
Right-click on the file with your Google id as its name.
A menu will open, click on Copy.
Navigate to the place where you want to save the calendar file.
Paste the calendar file.
Rename it if necessary.
Step #5: Open Online Application
Open your favorite Browser.
Type the URL: https://www.indigoblue.eu/ics2csv
The converter application will open.
Step #6: Choose Your Calendar File
Click on the Choose Files button.
File Manager will open.
Navigate to your calendar file.
Click on your calendar file name to select it.
Step #7: Select Separator
Click on the Select Separator tab
In the menu that opens, select comma.
Step #8: Select Date Format
Click on the Date Format tab.
In the menu that opens, select MM/DD/YYYY.
Step #9: Convert File and Save
Click on the Convert to CSV button.
The File Manager will open.
Save the converted CSV file in a suitable location.
Step #10: Open CSV File in Excel
Open the Excel application.
Click on File in the main menu bar.
Click on Open in the dropdown menu.
The File Manager window will open.
Navigate to the location of the CSV file.
Click on the CSV file name.
Click on the Open button.
Excel displays the contents of the CSV file.
Caution: You may lose some information if you save the file in CSV format. Instead, save it as an Excel file.
Conclusion
We have shown you three ways to export your Google Calendar to Microsoft Excel. Use any of the methods suitable for your needs.