Importing locations

Your file needs one row per location. Every row needs a name and something to place it with — a street address, a town, a postcode, or latitude and longitude. Phone, website, description, tags and a pin colour are optional, now or later.

GeoJSON and TopoJSON files hold areas and lines, not locations — use Import shapes in the map editor for those.

No renaming needed. We read each column’s name and its values, in English, German, French, Spanish, Italian, Dutch and Polish. Columns called Column1 to Column9 still import — we go by the values.

These are the fields a column can be mapped to:

The five address fields are joined, in the order above, into one address, so addresses can be spread across several columns. Each column feeds one field only.

Add a column with a colour code for each row, for example #e03131. We recognise columns called Colour, Color, Pin colour, Marker color or Hex, or any column whose values are colour codes. The colour is used for:

• the location’s pin on the map,
• the Button on its card, unless you gave the Button its own colour,
• the pin drawn by the card’s Logo block.

Leave a cell empty and that location keeps its usual colour from its main tag or your map’s theme. Write codes as #rrggbb, rrggbb or #rgb. Colour names such as red are not read: the row is flagged on the Review step and keeps its usual colour. An uploaded logo image keeps its own colours.

1. Open the wizard

   Go to Locations in your map and press Import locations.

2. Upload a file, or point us at a sheet

   On Upload a file, press Choose file or drag the file onto the page. It is read in your browser, not uploaded.

   On Google Sheet, paste the link into Google Sheets link and press Read sheet. Share the sheet first: Share → General access → Anyone with the link → Viewer.

3. Pick a sheet, if there are several

   A workbook with more than one sheet shows a Sheet picker. Changing it re-reads the file you already chose.

Your file is shown as a table, with our reading of each column above it. Correct anything we got wrong.

1. Check the header row

   Exports often start with a title or a blank line, so the step says Using row N as your column names, or No header row found — we named the columns ourselves. If it picked the wrong one, press Change.

2. Check each column

   Each column is marked Detected, Likely, Guessed or No match. Open its picker to change it: fields that fit come first under Likely for this column, and Don’t import leaves it out. Edit any cell in place, and rename a column from the chevron beside its name.

3. Clear anything we flag

   A banner, One thing to sort out, lists what is missing — usually a name or an address column.

4. Press Continue

   Continue is above the table, and works once the flagged problems are cleared.

If one column holds both coordinates, press Split into Latitude and Longitude.

Addresses are looked up once, here. Rows with latitude and longitude are skipped, and identical addresses share one lookup, so lookups are usually fewer than rows.

The progress bar reads N of M addresses. Skip the rest stops and keeps what was found; place the rest by hand on the next step.

A map above your rows, and still nothing saved. The header says N of M rows are ready, with tallies for ready, need attention and not placed. Show only rows that need attention starts on.

For any row that needs work:

• Drag its pin on the map — fastest for the right street but the wrong building.
• Press the wrench beside a row (Fix row) to edit the address and search again, or to pick one of the other matches we found. The tick (Done with row) closes it.
• Press Place on map for a row that was never found, then click where it belongs.
• Leave a row out entirely by clearing its name on Back to columns.

Red rows can’t import until fixed or removed. Amber rows import as they are.

Press Import N locations. Tag columns become tags, the main tag goes first so it colours the pin, a Pin colour column colours its row’s pin and card instead, and you land back on your map.

From a Google Sheet on Starter or Pro, the Review step also offers Keep in sync with the sheet — see Google Sheets sync.

A map holds up to 25 locations on Free, 300 on Starter and 3,000 on Pro. The wizard checks the room left before writing anything, so an import over the limit is stopped rather than half applied.

On the Locations page, Show → Needs attention lists every location we are unsure about; the same menu offers Not placed, Rough match, Approximate address and Missing details. Open one to search its address again, or drag its pin in the map editor.