This short article explains how to print customized lists of your Google Calendar Events using GCalToolkit, and export them in spreadsheet format.
If you came here looking for very basic Google Calendar printing then you'll want the "MORE" button, then "PRINT":
You can also choose to print the "Month" or "Week" view, or an "Agenda" view which displays the event range you have selected in a list. You can also change the font size, and print in black and white to save on expensive color ink. On the same subject, remember to print in "Draft" mode if you don't need a high quality copy.
That's all fine if you just want to print a copy of what you see in Google Calendar, but if you want to export custom lists of events filtering by keyword, type of event (free only, private only, all day only etc.) then GCalToolkit can help you. Use GCalToolkit to display or hide the columns you wish to print - very useful if you want to print out the full description field for each event, or the location, the busy/free status etc. You can also export in the TSV format, a spreadsheet format similar to CSV but using "tab" to instead of "comma" in the file. You can open and edit the output file with any text or spreadsheet software such as OpenOffice, Google Documents or Excel.
This is what Google List View (Agenda) will display, for example:
When you have formatted the CSV export from GCalToolkit you should have something similar to the picture below, complete with the description, and any other information you need such as busy/free status, location (where) etc. By configuring the "Date" column as a date in OpenOffice you can change the date format to include the week day, omit the time and so on.
When you load your calendar into GCalToolkit you can select the option "Download Date Range as Single Events", although this is not recommended (for quota reasons) unless you need to or print every instance of all repeat events, or need to delete multiple singles duplicating repeats. With this option the entire repeat series of every repeat in the date range will be displayed. By default, i.e without checking this option, a repeat event is a single row in GCalToolkit - but you can right-click on any event to expand its series to multiple single events... or select multiple events and use the "Edit" menu option, "Download Repeat Series". Repeat events have a black border around the Start. Right-clicking events also allows you to view them in Google Calendar directly.
Where you go from here is up to you: GCalToolkit helps you export the raw data that you need so that you can format the spreadsheet display to your heart's content. Let me know how you get on. Download GCalToolkit today below or from the "Download" page of this website.
GCalToolkit has many uses in addition to creating event lists:
- Repair calendar sync problems and undo iCal import
- Delete/Edit multiple calendar events based on date, type or content
- Bulk edit event reminders, busy/free, privacy etc.
- Export customized agenda event lists as CSV for printing or spreadsheets
- Multiple Copy/Move/Shift events between calendars
- Safe and Secure: uses OAuth 2.0 and the latest Google Calendar API
- UNLIMITED HELP from a Google Calendar expert
- 100% Satisfaction - Money Back Guarantee!