In previous article, we mentioned how to export google calendar to google sheets but in this article, I have mentioned how to export Google calendar to excel easily, step by step.
Google Calendar is a great tool that lets you track and organize day-to-day events, set reminders, and goals, and create and edit tasks. It has several features like multiple calendars, repeating events, and reminders, that make it stand out among other tools with similar functions.
It also lets you create a backup for your calendar by exporting it to various platforms including excel, and you will learn how to do it in this post.
Let's get started already!
How to Export Google Calendar to Excel
There are two options for exporting Google Calendar. You can export events from a calendar, and you can also export events from all calendars. Remember, Google lets you have multiple calendars on one account.
Irrespective of your choice, find the steps to export Google Calendar to Excel below. However, you should know that you cannot export Google Calendar from the Google Calendar application. You need to use the Google Calendar web version instead.
Exporting Events from all Calendars
Here are the steps to export events from all calendars to excel:
Step 1: Open Google Calendar
Since you cannot export events from the app, the first step is to open the Google calendar web version on your computer.
Step 2: Settings
When the Google Calendar web version displays, click on Settings. Click on the gear icon at the top right side of the page, and click settings from the drop-down options.
Step 3: Import & Export
Now on the settings page, select Import & Export on the left menu of the page.
Step 4: Export
The import and export options will display on the right side of the page, scroll to the Export and click on the Export button. The Export button in question is a clickable link. When you click this link, the events from all calendars will download to your computer as a ZIP file.
Step 5: Extract The Files
Go to the download location on your computer. You will find the zip file in this folder, except you select to save it in a different folder. If you do, then, navigate to the folder and open the Zip file.
Right-click on the zip file and select Extract All. The extracted .ics files for each calendar will save to a new system folder on your computer, and you will have to process each file separately.
Step 6: Open Microsoft Excel
Open the Microsoft Excel app on your computer from the start menu apps, or search for Microsoft Excel with the Windows search button.
Step 7: Open the Folder
After launching Microsoft Excel, click on the File tab at the top left of the page.
Then, click on open, then browse to the folder with your exported Google Calendar files.
Step 8: Customize Browse Option
The files are not in the default Excel file format, and the system will not display the items since they do not match the Excel format. You will see 'No items match your search instead'. Click the All Excel Files drop-down menu at the bottom-right of the window.
Then choose the All Files option to display the exported files.
Step 9: Select a File to Open it
The extracted files will display in the window. Double click a file to open it, and Excel will launch the text conversion wizard. Leave the default selections in the wizard and click Next until you get to Finish. Click on Finish and the file will open in the active spreadsheet.
You can repeat steps 7 to 9, selecting a different exported file till you have converted the events from all the calendars.
Exporting Events from One Calendar
The first method will export the events from all calendars in your account. However, you can select one calendar to export, if you have multiple calendars and you do not wish to export the events from all of them. You can choose up to two, three, or more calendars if you want to export events from multiple but not all Google Calendars.
Below are the steps to do this:
Step 1: Open Google Calendar
Since you cannot export events from the app, the first step is to open the Google calendar web version on your computer.
Step 2: My Calendar
Click the arrow beside my calendar option in the left menu of the Google Calendar page, but you may not need to click it if the option is expanded.
Step 3: Settings and Sharing
Point to the calendar you want to export, click on the More option -the three vertical dots next to the calendar and then click on Settings and Sharing.
Step 4: Export
Select the Export calendar button under the calendar settings section, and the file will download to your computer in .ics format.
Your Google calendar is imported to your computer and you can open it in Excel with steps 6 to 9 in the first method above.
Conclusion
That is all on how to export Google Calendar to Excel, and you can apply the tips in this post whether you want to export events from all calendars or one calendar.
You can also follow the second method to choose the calendars you want to export to excel.
You may also like to read:
