Add multiple locations to your Storepoint store locator at once using our bulk import feature. Import from a CSV or Excel spreadsheet, and the import tool walks you through each step, from uploading your file to mapping columns.
New to Storepoint? Start a free trial and follow the Quick Start Guide to set up your store locator.
On this page: How It Works · Preparing Your Spreadsheet · Mapping Columns · Supported Fields · Common Questions
How It Works
- Upload your CSV or Excel file
- Map your spreadsheet columns to Storepoint fields
- Preview how your data will look
- Import all locations at once
Storepoint handles geocoding automatically. Just provide the address and we'll pinpoint each location on the map.
Preparing Your Spreadsheet
You can use our template or your own spreadsheet.
Download a Template
Quick start template: includes all standard fields. Works without an account.
Your account template: includes your custom fields if you've set any up.
Neither template includes latitude and longitude columns by default since coordinates aren't required. If you prefer to define your own coordinates, you can add these columns manually and Storepoint will use them instead of geocoding. See Supported Fields for all available columns.
Use Your Own Spreadsheet
Upload any CSV or Excel file and use the mapping system to match your columns to Storepoint fields.
Basic Requirements
- First row should contain column headers
- Include at least name and address details for each location. You can use
nameandaddresscolumn headers or your own naming, then map them during import. - Save as CSV (.csv) or Excel (.xlsx, .xls)
For field formatting details, see Supported Fields.
Uploading Your File
- Go to Import Locations
- Drag and drop your file, or click to browse
- Wait for the file to process
Once uploaded, you'll see a summary showing how many locations were found and which columns Storepoint detected.
Mapping Columns
After uploading, you'll map your spreadsheet columns to Storepoint fields.
Automatic Mapping
Storepoint automatically detects common column names. If your spreadsheet has columns like name, address, phone, or email, they'll be mapped automatically.
Manual Mapping
For columns that weren't auto-mapped, select a Storepoint field to map them to. You can also choose to ignore columns you don't want to import. The mapping page shows each column name along with a sample value from your file.
Combining Columns
optional You can map multiple columns to the same Storepoint field and they'll be combined automatically.
For example, if your spreadsheet has a location type column and a products available column, you can map both to the tags field. Storepoint will merge them together so all of those values become tags for each location.
This works with any field. For most fields, you can choose how to separate the combined values (space, comma, or dash).
Transformation Rules
optional Transformation rules let you modify data during import so you don't have to edit your spreadsheet first. For example, if some locations are missing a country, you can add a rule: "If Country is empty, set it to United States." You can also append values to fields, like automatically adding tags based on another column's value.
Saving Mapping Presets
optional If you regularly import from the same data source, save your mapping as a preset. The next time you upload a file with matching columns, Storepoint will detect your preset so you don't have to redo the mapping each time.
Supported Fields
The following fields are available for import. Only Name and Address are required, everything else is optional.
Required: name, address
Optional: description, city, state, zip/postal, country, phone, email, website, image url, monday through sunday (hours), facebook, instagram, twitter/x, tags, latitude, longitude
The address field can contain the full address (e.g., 123 Main St, Boston, MA 02101, USA). The city, state, zip/postal, and country fields are available if your existing data has these in separate columns, but they're not required if your address is complete.
Store Hours
Use columns for each day: monday, tuesday, wednesday, thursday, friday, saturday, sunday.
Use a simple format like 9:00am - 5:00pm or Closed. If a location has a break (like a lunch closure), separate the time ranges with a comma: 9:00am - 12:00pm, 1:00pm - 5:00pm.
See the Opening Hours guide for all supported formats and display options.
Tags
Use a tags column to categorize locations for filtering. Enter tags as a comma-separated list:
Coffee, WiFi, Parking, Drive-Thru
Include all relevant tags for each location in a single cell.
Just include your tags for now. You can organize them into filter groups later in your dashboard. Learn more about filters and tags.
Images
The image_url field accepts a direct link to an image file. Images display on your locations in the locator.
Getting image URLs:
- From your website: Right-click an image and select "Copy image address"
- From image hosts: Services like Cloudinary provide direct image URLs
Example: https://example.com/images/store-photo.jpg
Learn more about location images
Coordinates
Storepoint automatically geocodes each location based on the address provided.
If you do have specific coordinates, add latitude and longitude columns to your spreadsheet. Storepoint will use your coordinates instead of geocoding.
Our template doesn't include coordinate columns by default to keep things simple. Just add latitude and longitude columns yourself if you need them.
Custom Fields
If you've set up custom fields, they'll appear in the mapping dropdown under "Custom Fields". Download the template from your dashboard to see the exact column names for your custom fields.
After Importing
Once your import completes:
- Your locations appear in the Manage Locations page
- They're immediately visible in your locator widget
- You can edit any location individually if needed
After importing, go to Tags & Filters to organize your tags into filter groups. This lets customers filter locations in your locator by category, service, or any other criteria.
Common Questions
Do I need to update my embed code after importing?
No. Once you've embedded the Storepoint widget on your website, it automatically shows your latest locations. Import new locations anytime and they'll appear in your locator immediately.
Is there a limit to how many locations I can import?
The limit depends on your plan. Check your account settings for details.
What if I need to update locations regularly?
For ongoing updates, consider syncing with a Google Sheet. It automatically updates your locator whenever your spreadsheet changes, no manual imports needed. See Google Sheets Sync for full details.
My spreadsheet format doesn't match the template. Can I still import?
Yes. Upload your spreadsheet as-is and use the column mapping feature to match your columns to Storepoint fields. You can also save your mapping as a preset for future imports.