1. Home
  2. Calendars
  3. How to Create a Color-Coded Calendar Structure from a CSV File
  1. Home
  2. Import and Export
  3. How to Create a Color-Coded Calendar Structure from a CSV File

How to Create a Color-Coded Calendar Structure from a CSV File

One of the most visible characteristics of Teamup is color-coded events. The primary color-coding system is the sub-calendars, which can be used to group people, resources, spaces, jobs, etc. Calendar administrators can create and manage sub-calendars through the calendar settings; you can also quickly create a color-coded sub-calendar structure by importing a CSV template.

Step 1: Create the CSV template

To create a calendar structure like this:


You can use a CSV template like this:

Create the template

It’s important to format the CSV file correctly for importing. See this article for details.

  1. Create a new CSV file with the column headings as shown above:
    • Calendar Name
    • Color ID
    • (optional) Allow Overlap
  2. Add the information for each sub-calendar on a separate row: name, color, and overlap permission. list each sub-calendar on a separate row.
    • You can use the > symbol to create folder hierarchies for the sub-calendars, e.g. Team > Amy.
    • To allow overlapping events, put 1 (yes/true) in the column. To disallow overlapping events, put 0 (no/false) in the column.
    • Set the color id for each sub-calendar (details below).
  3. Save the CSV file.

Assign color-coding

Teamup has 48 colors which can be assigned to sub-calendars through the color selector when managing individual sub-calendars:

Each of these colors has a corresponding color ID. To color-code the calendar structure when importing a CSV template, enter the color ID to designate the color for each sub-calendar.

Here are the color IDs:

If you don’t have the color ID palette on hand or haven’t decided which colors to assign, simply put any number between 1 and 48 for each sub-calendar. Once you’ve imported the calendar structure, you can adjust the color for each sub-calendar in Settings > Calendars by using the color selector:

Step 2: Upload the CSV file

  1. Open the calendar where you wish to set up the color-coded calendar structure.
  2. If you already have sub-calendars created which you no longer want, you can delete or deactivate all but one. (You will have to leave one sub-calendar active; you can delete it after importing the CSV template if no longer needed.)
  3. Go to Settings > Import Events, then click sub-calendars at the top:
  4. Choose the CSV template you just created, upload it, then click Save:

Calendar limit error

If you upload a CSV template with more sub-calendars than currently allowed on your subscription plan, you will receive an error when uploading:

  • Go to Settings > Calendars and deactivate or delete any unneeded sub-calendars.
  • Go to Settings > Subscription to upgrade your plan and increase your sub-calendar amount.

Step 3: Modify as needed

Once you have completed the import, you can still make any modifications as needed:

  • Change sub-calendar colors.
  • Adjust sub-calendar names.
  • Rearrange sub-calendars.
  • Add or remove sub-calendars.
  • Organize in different folders.

To make any of these changes, to go Settings > Calendars, then adjust as needed. See more about how to manage sub-calendars.

Try it out

Try it out on a live demo calendar that shows how to bulk import sub-calendars from a CSV template.

This demo calendar allows you to test how to quickly create sub-calendars from a template .csv file. You can use the CSV template on the demo calendar or make your own and test it out. Open the demo calendar.

Updated on September 8, 2023
WordPress Cookie Notice by Real Cookie Banner