Location Import Guide

In our Session Locations Guide, we discussed the ins and outs of adding, editing and assigning individual locations to your sessions. However, as your event starts ramping up, you may find yourself working with many locations for all of your event's sessions. Rather than adding locations one at a time, you can bulk add users by importing a spreadsheet.

Creating the Spreadsheet

To import locations, you'll need to fill out a .xlsx or .csv file with all your location data and import it to your event site.

When you're importing your location data, you can select one of two data types:

1. Session Location Data
2. Meeting Location Data

You'll need to import these in separate spreadsheets. In order for the import to be successful, you're required to add some fields as headers along the first row (row 1) of each spreadsheet. 

For Session Locations, the following fields are required:

For Meeting Locations, the following fields are required:

A few things to keep in mind before importing:

• Please include the headers (first row) in the spreadsheet before you import it.
• Please use 24hr format when entering DailyStartTime and DailyEndTime.
• The uploaded file cannot exceed 1000 rows. If you need to import more than 1000 rows for either Sessions or Meetings, please break the import into multiple files.
• Your file must be in either .xlsx or .csv format.

Importing the Spreadsheet

Choose Data

1. From the Admin portal, click on Locations:
2. Click Import Locations:
3. Next, click on Start New Import in the right-hand corner:
4. On the next page, select which Data Type you'd like to import. In this example, we're going to select Meeting Location. Be sure to read the import instructions that display after selecting your data type. Next, we'll locate the spreadsheet file on our device.
5. Next click Upload File: Drop a file or click to upload:
6. Choose your file and click Open: Notice your file will appear under the Upload File tab.
7. When you're finished with this step, click Next to proceed:

Edit Mapping

Note: If your file's headers are exactly as they're written in this article, your fields should map automatically.

For the next step, you're required to map your file fields to their respective Event Cloud fields.
This is a crucial step in the import process, so make sure you map your fields correctly!
Map your fields until all of them indicate a green checkmark.
When you're done mapping your fields, click the Next button to proceed:

Review

On the last step, please review your import. Any errors with your data will be detected at this step; if there are any errors, please edit and re-upload your spreadsheet.
Once everything is looking good to go, click the Import button in the top right corner to complete your import!
Lastly, you'll be prompted to confirm your import:
Once you hit OK, you're all done!