Skip to content
Store LocatorHelp
Managing Stores

Import Stores with CSV

Upload all your store locations at once using a CSV file instead of adding them manually.

All Articles

If you have many store locations, you can upload them all at once using a CSV file instead of adding them manually.

CSV import upload screen
Upload your CSV file in the CSV Import section.
  1. 1Go to the Locations section in the Store Locator admin panel.
  2. 2Select Add Multiple Locations
  3. 3Download one of the provided CSV templates:
    • Address-based template
    • Latitude/longitude template
  4. 4Open the file in Google Sheets or Excel to edit it easily.
  5. 5Fill in your store data (name, address, hours, images, etc.).
  6. 6Upload the CSV file back into the app.
  7. 7Match your CSV columns to the correct store fields (address, name, description, hours, etc.).

The app will then automatically:

  • Geocode your store addresses (to transform the coordinate/address into a point in the map)
  • Add them to your store list
  • Display them on the map

This is the fastest way to bulk upload and manage large store networks.

CSV Templates#

Choose the template that matches your data format:

TemplateWhen to use
Address columnYou have full street addresses
Latitude & Longitude columnsYou have separate latitude /longitude columns

Download both templates on the Downloads page.

Required Fields#

Every row must include name and at least one location field:

FieldRequiredNotes
nameYesStore display name
addressOne of these twoFull street address — the app will geocode it automatically
latitude + longitudeOne of these twoDecimal coordinates (e.g. 48.8566, 2.3522)

Each row needs either a valid address or both latitude and longitude. Rows missing both will be skipped.

All Available Fields#

FieldExample
nameREWE Charlottenburg
address80-82 Otto-Suhr-Allee, Berlin, 10585
latitude52.5162
longitude13.3045
phoneNumber49152000999
emailAddresshello@example.com
websitehttps://www.rewe.de
websiteLabelVisit website
descriptionOpen daily, fresh produce available.
businessHours{'mon':['09:00-19:30'],'tue':['09:00-19:30']}
imagehttps://example.com/store-photo.jpg
iconLinkhttps://example.com/custom-pin.png
hyperlinkhttps://www.rewe.de/angebote
hyperlinkLabelWeekly offers
prioritizedTrue

businessHours uses a JSON-like format with day codes (monsun) and one or more time ranges per day. You can have a break mid-day by adding a second range (e.g. ['09:00-12:45','13:00-19:00']).

prioritized pins the store to the top of the results list. Set to True or leave blank.

Video Tutorial#

Video Tutorial

How to import store data using CSV

Still stuck?

We're here to help

Or email us at support-store-locator@mapular.com