In the exporter Tab, you can set these additional options before you export your Google calendar/s. here you can access various options when exporting your Google Calendar/s.
Merge all: check this box if you want to merge all events from multiple selected calendars into a single worksheet.
Sum all: check this box if you want to show the total calculated sum of all durations in your exported calendar/s.
Additional fields: check the fields that you want to be exported into your calendar here.
Day Total: Checking on this field will calculate the total number of days that of your google calendar events.
Display Name: Relevant If you exported Google Calendar/s contain fields such as: “Created By:”, “Organized By:”, “Attendees”, and “Email” and your person is used in these fields.
You have the option of either having your Full name OR Email Address exported in these fields.
Merge all: check this box if you want to merge all events from multiple selected calendars into a single worksheet.
Sum all: check this box if you want to show the total calculated sum of all durations in your exported calendar/s.
Additional fields: check the fields that you want to be exported into your calendar here.
Day Total: Checking on this field will calculate the total number of days that of your google calendar events.
Display Name: Relevant If you exported Google Calendar/s contain fields such as: “Created By:”, “Organized By:”, “Attendees”, and “Email” and your person is used in these fields.
You have the option of either having your Full name OR Email Address exported in these fields.
Format: Specify the Date/Time format of the exported calendar/s here.
Date Separator: Choose what date separator to use.
Clock Style: Specify what clock style you would like here
Duration: Choose duration settings. Be it in:
Hours: minutes: seconds/ minutes
Separate Date and Time: Check this box if you want to put date and time into separate columns
All-day Filter:
Search Filter: Events with the search keywords typed in the text box will be the only event included in the export.
Attendee fields: Check what attendees you would like to be included in the exported calendar/s.
Attendee filters: Specify if you want to exclude the organizer or resource in the exported calendar/s.
Timezone: Choose what time zone to use in your Google Calendar/s export in this dropdown menu
You’ve already selected the various Google Calendar Summary options and now all you have to do is to export.
TimeTackle can export your Google Calendar or Calendars (You can export more than one at a time) into various formats: XLSX, XLS (Microsoft Excel); CSV, HTML, and PDF. Simply follow these steps.
Specify the range (start date and end date)
Click the file format you want your Google Calendar/s to be exported in. After a short while of processing a pop up should show appear prompting you to download your exported Google Calendar/s. Congratulations! You’ve just exported your google calendar.
What more you can do with the Google Calendar Export feature of TimeTackle. TimeTackle is a very powerful Google Calendar Export tool. When exporting your Google Calendar, you have the ability to access the various options in exporting your google calendar which changes its format and fields.
You can save your settings in a template so you can use it in a future Google Calendar Export. TimeTackle has a feature called recurring exports where you can schedule Google Calendar exports that automatically gets sent unto your Gmail inbox periodically.
Export Google Calendar to Excel!
© 2023 TimeTackle, Inc. All Rights Reserved.