How Do I Import Locations?

Add multiple locations to ActivityHero using import templates. Save time and streamline your setup process by uploading all your locations in bulk with just a few simple steps.

Import New Locations
Common Location Validation Errors
Location Data Fields

For an overview of importing in ActivityHero, and how locations, activities, sessions, and other data relate to each other, see our help article How do I import data into ActivityHero?

Import New Locations

1. Download the sample templates from the link below, and read the instructions on how to use the spreadsheet.

• The location name, address, city, state, and zip code are all required.
• Leave the location_id blank. ActivityHero automatically creates a location_id after upload. 
• The location name should be unique. If the location_name matches an existing location in ActivityHero, that location is updated instead of a new one being created.

3. Upload your CSV file by clicking Upload a new file. Select the Location file type.

4. After uploading your CSV file, click Validate to check whether your data is ready for import. 

5. If there are errors, Validation Failed is displayed. Click View Report to inspect the reason for the failure. Correct any errors, and then repeat step 3. For tips on frequent validation errors, see the section below.

6. When the file is validated successfully, the green Run option becomes available. Click Run to begin importing your information. This can take a few minutes, and changes might not be displayed in the marketplace right away.

Common Location Validation Errors ↑

Below is a list of common validation errors and how you might address them:

Missing Data - One of the most frequent issues when importing new locations is missing data in required fields. To avoid this, make sure to carefully check your template for all necessary fields before exporting it as a CSV.

You cannot change the location_name by reimporting a file. 

Location Data Fields ↑

Data fields (* required fields)

• location_name * - If the session is online, there is no need to add address, city, state, or zip code.
• is_main_location (yes or no)
• location_address *
• location_city *
• location_state (State should be a two-letter abbreviation, such as CA or TX.) *
• location_zip *
• location_country
• location_phone

If you have questions or problems, submit a support request.

Related Articles ↑

• How Do I Import Data Into ActivityHero?