Update Sessions Through a CSV
Aside from using the Session Bulk Edit feature, you can upload a CSV file to update your session information.
1. Download the Session Update CSV Template
The session update template is very similar to add sessions template, except when updating sessions, the template's first column label is ID.
2. Get the Session ID
The value to be added in the ID column is the Session ID and you you can get this by exporting the session CSV through Actions. Having the session id in the CSV allows the system to determine that the existing session with that session id must be updated instead of creating a new session.
3. Format Your CSV
The format of the template from step 1 is not the same as csv you downloaded from step 2, make sure to follow the format of the update session template, see the details of each column below:
Column | Format |
ID | Unique numeric code for each session |
Title | Text |
Format | Accepted values are the following:
|
Session Type | Accepted values are the following:
|
Location | Text
This should be left blank for virtual sessions
Note: If you're updating the location, it may not appear the first time you check the session, just refresh the page to see the location. |
Start Date | DD/MM/YYYY (e.g., 28/07/2025)
The date cannot be in the past
Notes:
When you open the template in Google Sheets, Numbers or Excel, the formatting may convert to that application's default settings. So even if we set the date in template as 28/07/2025, it's possible that when you open it with another application the format may change to 2025-08-07.
Double-check your format before you try to upload. We suggest changing the format to plain text to remove possible formatting.
The format does not change when opened through the TextEdit application. |
Start Time | 24-HR HH:MM (e.g., 13:00) |
End Time | 24-HR HH:MM (e.g., 13:00) |
Full Detail | Text |
Capacity | Number |
Short Description | Text |
Tags | Items should be comma separate (e.g., Tag 1, Tag 2)
If you're working directly on a CSV file instead of an Excel or Google Sheet, multiple tags in 1 cell should have a quote at the start and end of the content.
|
Tracks | Items should be comma separate (e.g., Track 1, Track 2)
If you're working directly on a CSV file instead of an Excel or Google Sheet, multiple tracks in 1 cell should have a quote at the start and end of the content.
|
Location ID | You can leave this blank, but make sure the column label is included |
4. Upload Your CSV
Select Import Sessions from the Actions button, then select the CSV file you want to upload.
Note: If you're updating the location, it may not appear the first time you check the session, just refresh the page to see the location.