Bulk upload locations
Import or update many locations at once via CSV.
For Hub admins. For a single location, just click Add Location. Use bulk upload when you have 5+ to add or update.
Workflow
Open the importer
Manage → Locations → Import.
Download the template
Click Download Template. The file is named location_import_template_{hubName}.csv and includes every standard field plus any Custom Variables you've defined.
Fill in the CSV
One row per location. Save as .csv (UTF-8).
Upload and validate
Drag-drop or click Choose File. The preview highlights errors in red — click a cell to edit inline and re-validate.
Import
Click Import Locations. Watch progress; review success/error counts when done.
Fields
| Field | Required | Notes |
|---|---|---|
_id | No | Existing location ID. Present = update; absent = create. |
name | Yes | Display name |
admin_name / admin_email | No | Location manager |
address / city / state / zip | No | Physical address |
contact_email / phone_number | No | Public contact |
website_url | No | Must include protocol or be a valid domain |
time_zone | No | IANA format, e.g. America/New_York |
| Custom variables | Depends | Marked * if required. Use field key names as headers. |
Custom variable column formats
| Type | Format |
|---|---|
| Text / Email / Phone / URL | Plain string |
| Number | Numeric only |
| Boolean | true / false |
| Select | One of the predefined options |
Example:
name,city,state,store_manager,local_offer*,has_parking
Downtown Studio,San Francisco,CA,Sarah Johnson,15% off first visit,true
Westside Location,Los Angeles,CA,Mike Chen,Free consultation,false
Validation rules
| Field | Valid | Invalid |
|---|---|---|
sarah@example.com | sarah@, sarah.example.com | |
| Phone | 5551234567, +15551234567, 555-123-4567 | 123, 555-CALL-US |
| Zip | US 94102 / Canada M5V 2T6 / UK SW1A 1AA | typos |
| URL | https://example.com, www.example.com | example |
Update vs create
- Row has
_id→ updates that location - Row has no
_id→ creates a new location
To update existing locations, Export first, edit the CSV (keeping _id), then re-import.
Troubleshooting
- File won't upload — save as
.csv(UTF-8), keep size reasonable - Headers not recognized — match field names exactly, no extra whitespace
- Special characters look wrong — use "Save As → CSV UTF-8" from your spreadsheet app
- Partial import — review the error report, fix flagged rows, re-import just those
Exporting
Manage → Locations → Export dumps standard fields as CSV. Use for backups, external tools, or as a starting point for bulk updates.