Calendar administrators can use the bulk export feature to export calendar data, including events, event signups, and/or event comments to a file.
The bulk export feature
To use the bulk export option (available only to calendar administrators), open your calendar in a web browser.
Go to Settings > Export Events.
Supported formats: ICS or CSV
Teamup currently supports two file formats for exporting calendar data:
- iCalendar (ICS, with .ics extension): The ics format is a standardized format for the exchange of calendar data among calendaring products. This format is useful for backup or the migration of calendar data from one product to another product. It provides full support for repeating events. You can export events (only) in ICS format.
- Comma Separated Values (CSV, with .csv extension): The CSV format is well-supported by spreadsheet tools like MS Excel and many database products. Support for repeating events is limited with this format. You can export events, event signups, and/or event comments in CSV format.
How to export events (ICS or CSV)
Export events in ICS format
- Choose iCalendar (.ics) for the export format.
- Select the calendar(s) to include.
- Set the date range.
- Click the green Export button.
Important notes:
- When exporting to an ICS file, each sub-calendar will be exported to its own file. All files are zipped in one file when downloading.
- Note that ICS files do not keep the custom fields in separate fields, but appended to the text in Description field. If you do not have custom fields, the ICS format is a good choice. If you do have custom fields, consider using CSV file format (see below for details).
Export events in CSV format
If you have custom fields, the CSV file format is typically a better choice for exporting.
- Choose Comma Separated Values (.csv) for the export format.
- Select the calendar(s) to include.
- Set the date range.
- Click the green Export button.
Advanced options for exporting events
Click the blue Show button to see advanced options:
- Date format
- Unique event identifier
- How to handle multiple calendars per event: one row, or one row per sub-calendar.
- Choose one row to keep events that are assigned to multiple sub-calendars the same as the source.
- How to handle repeating events: one row for each event instance, or one row for entire event series.
- One row for each event instance will export the event data, but will ‘lose’ the repeating series. If the exported file is imported into another calendar, there would not be a repeating series. So, to keep the repeating event series, choose one row for the entire event series. would keep the repeating series.
Export event signups or event comments (CSV)
- Choose Comma Separated Values (.csv) for the export format.
- Select the calendar(s) to include.
- Set the date range.
- Click Show to see the advanced options and set as desired. (See details below.)
Export event signups
Select Comma Separated Values (.csv) for the export format, select the calendar(s) to include, and set the date range.
In Advanced Options > What section, click the button next to Event Signups, then set the advanced options as preferred:
- Preferred date format
- Unique signup identifier
- Signups on repeating events exported with one row for each event instance or one row for the entire event series.
Export event comments
Select Comma Separated Values (.csv) for the export format, select the calendar(s) to include, and set the date range.
In Advanced Options > What section, click the button next to Event Comments, then set the advanced options as preferred:
- Preferred date format
- Unique comment identifier
- Comments on repeating events exported with one row for each event instance or one row for the entire event series.
Keywords: transfer, backup, migrating calendar data