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:

Name Description LocationText Capacity
Session Name Describe the location. Address Must be greater than 0


For Meeting Locations, the following fields are required:

LocationName   LocationText   LocationDescription   LocationCapacity  
Name of venue Address Ex: "Please check-in at the front desk." 598
AreaName   AreaCapacity   StartDate   EndDate   DailyStartTime   DailyEndTime  
Table29 10 1/20/2020 1/24/2020 11:00 17:00


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: ClickLocations.png
2. Click Import Locations:  ClickImportLocations.png
3. Next, click on Start New Import in the right-hand corner: Start_Import_Button.png
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. ChooseDataType.png
5. Next click Upload File: Drop a file or click to upload: UploadFile.png

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: next.png

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. mapping_1.png
This is a crucial step in the import process, so make sure you map your fields correctly! mapping_2.png
Map your fields until all of them indicate a green checkmark.  mapping_3.png
When you're done mapping your fields, click the Next button to proceed: next.png


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. Location_Import_Review.PNG
Once everything is looking good to go, click the Import button in the top right corner to complete your import! import.png
Lastly, you'll be prompted to confirm your import: Import_Locations.PNG
Once you hit OK, you're all done! successful_import.PNG
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.