MigrationUpdated 2026-08-25

Match CSV columns

What this article helps you do

Change column names from a previous store locator or spreadsheet to names that Mapstore accepts. Mapstore also accepts specified column aliases.

Before you start

  • You have a CSV or spreadsheet from a different app.
  • You can edit the header row in a spreadsheet app or text editor.
  • You know the columns that contain the store name, address, and other fields.

Step-by-step instructions

1. Required columns

Each row must have name and address. Mapstore skips a row if one of these values is missing.

2. Name column aliases

Mapstore accepts these store-name columns:

  • name, store_name, location_name, title

Use one of these as your header. Column names are case-insensitive.

3. Address column aliases

Mapstore accepts these address columns:

  • address, full_address, location, addr

Use one of these as your header.

4. Optional column aliases

Mapstore column Aliases you can use
phone phone, telephone, tel, phone_number
email email, email_address, contact_email
website website, url, web, site_url
description description, store description, desc, details, info
status status, active, enabled, visible
pinned pinned, featured
lat / lng lat, latitude, y / lng, longitude, lon, x
googlePlaceId googlePlaceId, google place id, google_place_id, place_id
filters filters, tags, categories, category
note note, notes, internal notes, internal_note, comments
image image, photo, picture, img_url
customMarkerImage customMarkerImage, custom marker image url, marker_image, icon
customDirectionsUrl customDirectionsUrl, custom directions url, directions_url, directions
sortOrder sortOrder, priority, order, position, sort_order, row order, row_order

Mapstore ignores unmapped columns. To import an unmapped column, rename its header to one of these values.

5. Keep or rename headers

Rename the exported headers to standard Mapstore names or to one of the aliases. For example, rename Store Name to name and Full Address to address.

6. Save and test

  1. Save the file as CSV.
  2. Select the file in Stores -> Bulk.
  3. Click Test CSV. The test does not import data.
  4. If Mapstore skips rows, correct the identified rows.
  5. Test the file again.

How to verify it worked

  1. Make sure that the import summary shows no unexpected skipped rows.
  2. Make sure that stores have the correct name, address, phone, and other data.
  3. Make sure that you can see filters and descriptions in the store editor.

Troubleshooting

Issue Fix
“Missing required column: name” or “address” Add a column with one of the required aliases. Make sure that each data row has a value.
Column not recognized Use a header from the alias table above. Unmapped columns are ignored.
Other columns ignored Rename to a Mapstore column or alias. See Prepare a CSV file.
Mapstore continues to skip rows Required columns must have values in each row. See Fix skipped CSV rows.