StoreRocket is a store locator with CSV import and bulk upload: you upload a CSV, TSV, TXT, XLS or XLSX file of up to about 15 MB, StoreRocket matches its columns, places each address on the map, and shows you what will change before anything is published. You choose to add the rows to your current locations or replace the list.
That makes it practical to load hundreds or thousands of locations in one go, and to repeat the import whenever your master list changes. We make StoreRocket, so weigh our view with that in mind.
Related: Store locator that syncs with Google Sheets | Store locator for 1,000+ locations | What is geocoding? | How to add a store locator to your website
The short answer
- Put one location on each row. A name and an address are enough; phone, hours, filters and the rest are optional columns.
- Upload the file in the dashboard. Columns are matched for you, and you can change any match.
- StoreRocket places each address on the map. Rows that already have latitude and longitude keep them.
- In the review, nothing changes until you publish. Rows already on your map, possible duplicates and addresses that could not be found are shown first.
- Not ready to pay for a locator? For a short list that rarely changes, the free store locator options may be enough.
How bulk import works in StoreRocket
- Prepare the file. Use the spreadsheet you already have, or start from one of StoreRocket's templates. One location per row, with a heading row on top.
- Upload it. Choose Import in the dashboard and pick the file. CSV, TSV, TXT, XLS and XLSX are accepted.
- Check the columns. StoreRocket matches headings such as Name, Address, City, Phone or Latitude to the right fields. Anything it could not match is shown for you to pick, and Change columns reopens the list later.
- Let it place the addresses. Each address is looked up and put on the map. A big file takes a few minutes, and the check keeps running if you close the page.
- Review. The review shows what publishing will do:
- new locations to add
- rows that match a location already on your map
- possible duplicates, which you can leave out or keep
- rows marked Address not found, which you can fix in place and Save and check, or give exact coordinates with Use coordinates instead
- Publish. Choose to add the rows to your current locations, or replace the list. Replacing asks you to confirm, and rows whose StoreRocket ID matches an existing location keep that location and its click history.
The locator on your website shows the new list through the embed code already on your page. Every import is kept in Import history.
What a good import file looks like
- One location, one row. No totals, merged headings or notes rows.
- Complete addresses with the country. "12 High Street, Bath, BA1 1AA, United Kingdom" is found more reliably than "High St, Bath".
- Postcodes as text, so a leading zero survives the spreadsheet.
- Latitude and longitude, if you have them. They are kept as they are, which is useful for rural sites or a shop inside a mall.
- Filters as one comma-separated cell, spelled the same way on every row: "Coffee, Parking".
- Hours per weekday, one column for each day.
To see the columns StoreRocket expects, download your locations as a CSV file from the dashboard and use it as the template for your next import.
Re-importing when your list changes
An import is not a one-off. When stores open, close or move:
- Add a file of new stores to grow the list.
- Replace with your full master file to make the locator match it exactly.
- Keep the StoreRocket ID column from an export in the file, so each row updates its own location instead of creating a new one.
If the list changes every week and lives with a team that works in spreadsheets, a Google Sheets sync saves the export and re-import. If it lives in your own system, the REST API can keep the locator up to date, depending on the plan.
How many locations your account holds depends on the plan, see pricing. The review says so before publishing if a file has more rows than the plan holds, and the draft is kept.
What to check when comparing CSV import
Most store locators import a spreadsheet; the differences show up on your second and tenth import. These checks work on any tool, StoreRocket included, and a free trial is the place to run them with your real file.
- Which file types. Excel files straight from your system, or CSV only?
- Column matching. Does it read your headings, or must you rename every column to the vendor's?
- Geocoding. Is every address placed for you, and are your own coordinates kept?
- A preview before publishing. Can you see added, changed and failed rows first, and fix a failed row without editing the file?
- Duplicates. Does a second import of the same file double your map?
- Add versus replace. Can you choose, and does replacing keep the history of locations that stay?
- Large files. Does the import keep running if you close the tab?
Frequently Asked Questions
Which store locator costs less to run over time?
Count the subscription, the map provider's bill and the hours spent keeping locations right. A free plugin costs nothing to license, but you keep it updated on your own site. With StoreRocket, imports, the hosted locator and its updates are part of the subscription, and after the trial you connect your own Google Maps or Mapbox key and pay that provider directly. Plans are on the pricing page.
What file formats can I import?
CSV, TSV, TXT, XLS and XLSX, up to about 15 MB per file. A Google Sheet can be downloaded as CSV or XLSX and imported, or kept in sync with Google Sheets sync.
Do I need latitude and longitude?
No. StoreRocket finds the coordinates from each address. If your file has latitude and longitude, they are kept, which helps where an address alone is imprecise. More on how this works: what is geocoding?
What happens if an address is not found?
The row is marked Address not found in the review. Correct the address and press Save and check, enter exact coordinates, or leave the row out. Once each such row is fixed or left out, the rest of the file publishes.
Will importing the same file twice create duplicates?
The review shows which rows are already on your map and which look like possible duplicates, so you decide before publishing. Keeping the StoreRocket ID column from an export makes each row update its own location.
StoreRocket gives businesses with several locations a store locator for their own website: import your locations from a spreadsheet, match it to your brand and paste one embed code. Create your locator with a free trial, no credit card needed.