How to import store locations from a CSV
Nobody should type 80 addresses into a form. Here is how to go from a spreadsheet to a live store locator in one upload.
By Robin, who builds and runs StoreLo · Updated 2026-07-30
Prepare the spreadsheet
One row per location. The columns StoreLo understands out of the box:
- Name (required): the store name customers see.
- Address, City, Postal code: as complete as you can. Better input means better pins.
- Country: two-letter code like NL or DE. Optional, but it makes geocoding noticeably more precise near borders.
- Phone, Website, Email: shown on the store card when filled.
- Opening hours: per day, so the widget can show an open-now status.
- Store Type: tag rows like retailer or webshop to give each type its own pill and button. Optional.
Working in Excel or Google Sheets is fine: export with File → Save as CSV (UTF-8) or File → Download → CSV when you are done.
What happens on upload
In the dashboard go to Locations → Import and pick your file. StoreLo maps the columns, geocodes every address into coordinates automatically, and shows you what it found before anything goes live. You do not need to supply latitude and longitude yourself, although columns with them are respected if you have them.
The errors that trip most imports
- Wrong delimiter: some Excel locales export with semicolons. If every row lands in one column, re-export as comma-separated or let the import preview pick the delimiter.
- Special characters look garbled: the file was saved in a legacy encoding. Re-export as CSV UTF-8 and diacritics behave.
- Vague addresses: a bare street name in a big city can geocode to the wrong spot. Add postal code and country, they resolve almost everything.
- Header row imported as a store: check the first row in the preview, it should be recognised as headers, not as a location called Name.
Keeping the list current
Export works the other way too: download your locations as CSV, edit in your spreadsheet, and re-import. For quick fixes the Locations page has bulk actions, select rows and set store type, status or priority in one go. Fresh data matters more than most styling decisions: one permanently closed shop on your map costs more trust than any colour scheme wins back.