1. Home
  2. Import and Export
  3. How to Bulk Export Calendar Data

How to Bulk Export Calendar Data

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 supports two file formats for exporting calendar data:

  • iCalendar format (ICS, with .ics extension): The iCalendar 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. 
  • CSV format (comma-separated values, with .csv extension): The CSV format is well-supported by spreadsheet tools like MS Excel and many database products. You can export events, event signups, and/or event comments in the CSV format. If you plan to migrate calendar data from one Teamup calendar to another Teamup calendar we highly recommend using the CSV format. It supports the migration of data without any loss of information because it supports Teamup-specific features like multiple sub-calendars per event, custom fields, and the migration of an entire calendar in one file.

How to export events (ICS or CSV)

Export events in ICS format

  1. Choose iCalendar (.ics) for the export format.
  2. Select the calendar(s) to include.
  3. Set the date range.
  4. 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 the 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

  1. Choose Comma Separated Values (.csv) for the export format.
  2. Select the calendar(s) to include.
  3. Set the date range.
  4. Click the green Export button.
Advanced options for exporting events

In the Export Events dialog, scroll to Advanced Options and click the blue Show button.

Advanced options:

  • Date format
  • Unique event identifier
  • How to handle multiple sub-calendars per event: one row, or one row per sub-calendar. 
    • In Teamup, events can be associated with multiple sub-calendars. If you want to maintain that association, select “One row”. Otherwise, one record will be exported for each sub-calendar that is associated with an event. 
  • How to handle repeating events: “One row for each event instance”, or “One row for entire event series”.
    • Option “One row for each event instance” will export a record for each instance of a repeating event. Information about the repeating characters of a an event is lost.
    • Option “One row for entire event series” will export one single record to represent a repeating event. Choose this option if you plan to import the exported data into another Teamup calendar.

Export event signups or event comments (CSV)

  1. Choose Comma Separated Values (.csv) for the export format.
  2. Select the calendar(s) to include.
  3. Set the date range.
  4. 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

Updated on July 22, 2024
WordPress Cookie Notice by Real Cookie Banner