Google Calendar Summary Options​

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.

24/7 Support • Cancel Anytime • Free Forever

Google Calendar Summary Options​

Additional

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.

Additional

Additional

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.

Additional

Date Time Format

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

DurationChoose duration settings. Be it in:

Hours: minutes: seconds/ minutes

Separate Date and TimeCheck this box if you want to put date and time into separate columns

Date time format

Filters

All-day Filter:

  • All day Events only – checking this option will only let events that last one whole day be exported.
  • Exclude All-day Events- checking this field will exclude all day events from being exported.

Search Filter:  Events with the search keywords typed in the text box will be the only event included in the export.

Filters

Attendee

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.

Attendee

Advanced

Timezone: Choose what time zone to use in your Google Calendar/s export in this dropdown menu

Advanced timezone

Exporting The Google Calendar/S​

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)

Date range

Download the format you want

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.

Download

Conclusion

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.

We just demonstrated how to convert your Google calendar data to Excel, Spreadsheet or CSV. Hope you found the instructions helpful. TimeTackle also allows you to format and filter your calendar data in different ways.​

Export Google Calendar to Excel!