Import store locations from a CSV file

Bulk-add hundreds or thousands of store locations using a spreadsheet.

Last updated April 27, 2026

CSV import is the fastest way to add a lot of locations at once. Maptera reads a standard spreadsheet, geocodes each address, and creates the matching store records automatically.

Required columns

Your CSV must include these column headers (exact names matter):

Column	Required?	Notes
name	Yes	Store name as it should appear publicly
address	Yes	Street number and name
city	Yes	City
state	Yes	State, province, or region
postal_code	Yes	ZIP or postal code
country	Yes	Two-letter country code (US, CA, GB, etc.)
phone	No	Optional contact number
email	No	Optional contact email
website	No	Optional URL to the store page
category	No	Comma-separated tags (e.g. "retail,outlet")
hours	No	Free-form business hours text

How to import

1
Download the template
On the Stores page, click "Import" and then "Download CSV template". This guarantees your headers are correct.
2
Fill in your data
Open the template in Excel, Google Sheets, or any spreadsheet tool. Add one row per location.
3
Save as CSV
Make sure to save in CSV format (not XLSX). UTF-8 encoding is recommended if you have accented characters.
4
Upload
Drag the file into the Import dialog. Maptera shows a preview of the first few rows so you can confirm the columns map correctly.
5
Confirm and run
Click "Import". Geocoding runs in the background — for large files this can take a few minutes. You can leave the page; we will email you when it finishes.

Common gotchas

If you see "Failed to geocode" errors, the most common causes are missing country codes, addresses with PO boxes, and very rural locations Google does not have data for.

Was this article helpful?

Add your first store location

A walkthrough of adding a single location to your store locator.

How geocoding works in Maptera

Understand how Maptera turns a street address into map coordinates.

Fix store locations that show in the wrong place

Troubleshooting steps when a store appears at 0,0 or in the wrong country.

Did this article miss your question?

Email our team and we will help directly.

Contact support