How to import store locations from a CSV file into a Wix store locator

By Jake Marsh · Updated

To import store locations from a CSV file into Wix, open Locatewell from your site's dashboard, click Import, then Import a CSV file and choose the file. Locatewell reads the column names in the first row, matches them to name, address, city, state, zip, country, latitude, longitude, phone, email, website, category and hours, and shows the first rows with any problems before you click Add to my locations. Rows without coordinates get them looked up for you (US and Canada addresses).

Before you start

  • Locatewell installed on the site from the Wix App Market. The import works before your trial starts, so you can load and check everything first.
  • Your list in Google Sheets, Excel or Numbers, saved as CSV. Commas, semicolons and tabs between columns all work.
  • One row per location and column names in the first row.

The columns Locatewell recognizes

You don't have to rename your columns to match exactly. Each field accepts several common names:

FieldColumn names it matches
Name (required)name, store, store name, location, location name, business name, dealer, branch
Streetaddress, street, street address, address 1, address line 1
Citycity, town, locality, suburb
State or regionstate, region, province, county
Zip or postal codezip, zip code, postal code, postcode
Countrycountry, country code
Latitude / longitudelat, latitude / lng, lon, long, longitude
Phone, email, websitephone, telephone, tel / email / website, url, link
Categorycategory, type, group, tag, segment
Hourshours, opening hours, business hours, schedule

If a column wasn't matched, or was matched to the wrong field, change it in the import screen before you go on. Columns you don't need are ignored.

Steps

  1. Click Import in the Locatewell dashboard, then Import a CSV file, and pick your file (up to 8 MB; split bigger files and import the parts).
  2. Check the column matching. Each field shows which of your columns it reads from.
  3. Read the preview. It lists the first rows with name, address, category and a Problems column. "OK" means the row is ready.
  4. Fix the rows with problems in your spreadsheet if needed. The common ones are a missing name, no address and no coordinates, a website that isn't an http or https link, or an email that isn't valid. Rows with problems are skipped; the rest still import.
  5. Click Add to my locations to keep what's already there, or Replace my locations to remove your manual, CSV and demo locations first. Locations copied from Business Info stay either way.
  6. Wait for coordinates. Rows with an address and no latitude or longitude show "Waiting for coordinates" while Locatewell looks them up, then appear on the map.
  7. Open Maps and click Preview to search the new list the way a visitor will.

Coordinates: when to include them

Each address Locatewell turns into coordinates uses one lookup from your plan (2,500 a month on Standard, 25,000 on Pro, 25 in total before the trial). Rows that already have latitude and longitude use none, so for a big import, or for locations outside the US and Canada, include them.

Coordinates must be decimal degrees, such as 32.7767, -96.7970. If your list has them as degrees, minutes and seconds (32°46′36″N), convert the column first with the DMS to decimal converter.

Coordinates you import or type are never replaced by a lookup. If you later edit the address of a location whose coordinates Locatewell found, it looks the new address up again.

Example file

Name,Address,City,State,Zip,Phone,Category,Hours
Elm Street Store,412 Elm St,Dallas,TX,75201,(214) 555-0100,Retail,Mon-Sat 10:00-19:00
North Pickup Point,88 Park Ave,Plano,TX,75074,,Pickup point,Mon-Fri 08:00-18:00

Both rows import, get coordinates, and show up under the categories Retail and Pickup point. With two or more categories on a map, visitors get a Category filter above the list.

What it costs

Locatewell is billed through Wix per site, with a 14-day free trial: Standard is $24 a month ($20 a month billed yearly) for up to 1,000 locations, 3 maps and 2,500 address lookups a month; Pro is $49 a month ($40 billed yearly) for up to 25,000 locations, unlimited maps, 25,000 lookups, pin colors by category and the search report. You can import and check your whole list before the trial starts; the map shows on your published site once it begins.

Locatewell: Store Locator Map

Show every store on a searchable map with radius and filters From $24 a month per site, or $20 a month billed yearly.


Questions

Can I update my locations by importing the same file again?

Importing adds the rows as new locations. To start over from an updated file, use Replace my locations, which removes your manual, CSV and demo locations before adding the new ones.

Why does a row say "Address not found"?

The lookup couldn't place that address. Check the spelling and the zip code, or type the latitude and longitude into the location yourself.

How many locations can I import?

Standard holds up to 1,000 locations and Pro up to 25,000 per site.

Can I import my Wix Business Info locations instead?

Yes. Click Import Wix locations on the Import tab. Those come in with coordinates and opening hours already filled in, so they need no lookups.

Can a cell put HTML or a script on my map?

No. Every value is stored and shown as plain text, and websites must be http or https links.


More Locatewell guides


More Wix guides