Importing Locations
Bulk import locations from CSV files
CSV File Format
Your CSV file should include a header row with column names. The importer matches columns by name, so the order doesn't matter.
Required Columns
- name - Location name (e.g., "Downtown Store")
- address_line1 - Street address
Optional Columns
- address_line2 - Suite, unit number
- city - City name
- state - State or province
- postal_code - ZIP or postal code
- country - Country name or code
- phone - Phone number
- email - Email address
- latitude - Latitude coordinate (if you have it)
- longitude - Longitude coordinate (if you have it)
- visible - true/false to control visibility
Example CSV
name,address_line1,city,state,postal_code,country,phone
Downtown Store,123 Main St,New York,NY,10001,US,555-123-4567
Uptown Location,456 Park Ave,New York,NY,10022,US,555-987-6543
Brooklyn Branch,789 Atlantic Ave,Brooklyn,NY,11217,US,555-456-7890
Importing Process
- From the dashboard, click Import in the navigation
- Click Choose File and select your CSV
- Review the column mapping preview
- Click Import to start the import
- Wait for the import to complete
The app automatically geocodes addresses that don't have coordinates.
Handling Import Errors
If some rows fail to import:
- Check for missing required fields (name, address_line1)
- Verify addresses are valid and can be geocoded
- Look for special characters that might need encoding
- Ensure the CSV is saved with UTF-8 encoding
Failed rows are listed with error messages so you can fix and re-import them.
Updating Existing Locations
To update locations via import, include a column that matches existing locations:
- Use the same name to update by location name
- The importer will update matching locations instead of creating duplicates