Difference between revisions of "Google Calendar Tricks"
From HeadBackup
Jump to navigationJump to searchm (moved Google Calendar Word Wrap to Google Calendar Tricks: Expanding to a broader focus.) |
|||
| Line 12: | Line 12: | ||
= Exporting Events to a Spreadsheet = | = Exporting Events to a Spreadsheet = | ||
| − | + | ||
| + | == Issue == | ||
| + | Agenda view comes close to doing what I want, but has the following limitations: | ||
| + | # Can't display events from an entire year in a single list | ||
| + | # Can't easily export/print events without including the event creator and calendar names (each event takes up several lines instead of just one) | ||
| + | |||
| + | == Fix == | ||
| + | To get around these I found the following helpful third party site which will export your events to a spreadsheet (Excel or Google Spreadsheet): | ||
| + | * http://www.gtimereport.com/Home.aspx/Export | ||
Revision as of 17:32, 22 May 2013
Contents
Word Wrap
Initial Install
- Install the Greasemonkey plugin for Firefox
- Install the Google Calendar Textwrap Events script
To enable wrapping on embedded calendars
- Once the above are installed, right click on the monkey icon at the bottom of the browser and then click on manage user scripts
- Under the Google Calendar Texwrap Events script add another URL as follows:
http*://www.google.com/calendar/embed*
Green key image
Exporting Events to a Spreadsheet
Issue
Agenda view comes close to doing what I want, but has the following limitations:
- Can't display events from an entire year in a single list
- Can't easily export/print events without including the event creator and calendar names (each event takes up several lines instead of just one)
Fix
To get around these I found the following helpful third party site which will export your events to a spreadsheet (Excel or Google Spreadsheet):
