Creating backupsThere are two ways to create backups of your calendar data:
- Using the Google Calendar website: This is the easiest way to create a backup of all your personal events in Google Calendar:
On the Google Calendar website, http://calendar.google.com, you can download a ZIP file that contains one ICS file per calendar (of your personal calendars under “My calendars” but not your shared calendars under “Other calendars”): Click “Settings”, “Calendar settings”, “Calendars” (tab), “Export calendars”:
These ICS files (i.e. you have to unzip the ZIP file) can be imported into another Google Calendar account with “Settings”, “Calendar settings”, “Calendars” (tab), “Import calendar”:
- Using iTunes: iTunes automatically creates a backup of your iPhone/iPod/iPad every time you sync it via USB (but it keeps only the latest backup by default, if you would like to have additional backups you have to create them manually as described on the following website:), please see here: “iTunes”, “How to back up” on http://support.apple.com/kb/HT1766
This backup can be used to either restore your device (or a new device) or you can use the instructions on the Recover page to extract ICS files from this backup that can be imported into Google Calendar as described above.
Exporting calendar as CSV fileIf you would like to export your calendar as CSV file to use it e.g. with Excel, you can use this program, but be aware that it doesn’t expand recurring events yet (they will be saved as a single event with the description of the recurrence rule):
To start it, just click the link. You need to have Java installed. If you don’t have Java, install it from http://www.java.com.
First you have to grant the application access to your computer to allow it to write the CSV file to your hard drive:
Then you have to enter your Google Calendar email and password and click “Sign in”:
Select a calendar and click “Search” or set a search phrase, a time range, a sort order and if recurring events should be expanded into multiple events or if they should occur as a single event:
Select the events you would like to export. Select a single event and then press CTRL-A/⌘-A to select all events. Then click “Export as CSV” to write these events into a CSV file:
If you like you can see the whole procedure in this video: