AddressPlotter

CSV to map

Drop a CSV exported from a CRM, a store list or a form, and see every row on the map. The delimiter and text encoding are detected automatically.

Loading the tool… Your file stays in your browser: only the text of each address is sent to place it on the map.

Example data from the City of Toronto, Licensed Child Care Centres. Contains information licensed under the Open Government Licence – Toronto.

Any CSV, as it comes

CSV files are simple until they are not. The tool reads them the way they are actually written:

  • Separator: comma, semicolon (Excel in France, Quebec and most of Europe), or tab.
  • Encoding: UTF-8, UTF-8 with BOM, UTF-16, or Windows-1252 from older Excel versions. Accented names stay readable.
  • Quotes: fields with commas or line breaks inside quotes, as in an address written on two lines.
  • Line endings: Windows, Mac or Linux, even mixed in one file.
  • With or without a header row: title lines above the header are skipped; a list without a header gets “Column 1, Column 2…” and you say what each holds.

From CSV to pins

After the file is read, the first rows are shown with a dropdown menu under each column. Check that the street, city, state or province and ZIP or postal code columns are right; the tool has filled them in. Before anything is sent, you see how many addresses will be looked up, how many rows repeat an address above, and how many already have coordinates.

Press Place on the map. The first pins show up within seconds and the rest follow. A progress bar tells you how many are left.

Typical CSV exports

  • CRM and email tools (Salesforce, HubSpot, Mailchimp): Mailing Street, Mailing City, Billing Postal Code… are recognized.
  • Shopify or WooCommerce orders: shipping address columns.
  • Google Forms answers saved as CSV, with one free-text address column.
  • Open data downloads from a city or state portal, often with latitude and longitude already there: those rows are placed directly.

Private by design

The CSV is read in your browser and is not uploaded. Only the text of each address is sent to be placed on the map. Downloading your CSV with latitude and longitude added is part of Pro ($19 for 7 days); the map, the corrections and the PNG image are free.

Questions

My CSV uses semicolons. Does it work?

Yes. Commas, semicolons and tabs are all recognized, as written by Excel in Europe and Quebec. Decimal commas in latitude and longitude columns are read too.

Accented characters look wrong in other tools. Will they display correctly here?

The encoding is detected for each file. UTF-8 (with or without BOM), UTF-16 and the Windows encoding that older Excel versions use all show "Montréal" correctly.

How big can the CSV be?

Files up to 30 MB are read. The free map takes the first 500 rows; Pro ($19 for 7 days) takes up to 25,000.

My export has 40 columns. Do I need to clean it first?

No. The tool finds the address columns among the others. The rest stay in your browser; a column with a few distinct values can be used to color the pins.

Other ways to use AddressPlotter

Guides