Importing your data

Upload, paste, or link a sheet — and how columns and addresses are matched.

Mapize reads your locations from a spreadsheet. There are three ways to bring data in, and Mapize figures out the columns for you.

Ways to import

  • Upload a file — CSV, TSV, or Excel (.csv, .tsv, .xlsx, .xls), up to 10 MB. For Excel workbooks, the first sheet is used.
  • Paste rows — copy cells straight from Excel or Google Sheets and paste them in. Include the header row.
  • Google Sheet link — paste a link to a sheet shared as Anyone with the link (or published to the web). Live, auto-refreshing sheet connections are a Solo feature — see Live data with Google Sheets.

Your file is read in your browser — the raw file is never uploaded to our servers.

Row limits

  • Up to 10,000 rows map smoothly on any plan. Larger files still work; you'll see a nudge to export as CSV for best performance.
  • 50,000 rows is the maximum per import.

Row count is not a paid limit — these ceilings apply to everyone.

How columns are matched

Mapize detects two things automatically:

  1. Location — either latitude/longitude columns, or an address (a single full-address column, or separate street / city / state / ZIP / country columns).
  2. A label — a name-like column (business, company, store, customer, etc.) used as each marker's title.

Detection uses both the column headers and the actual values, so a clearly-numeric coordinate column is recognized even if its header is unusual. Address matching is tuned for US-style addresses today.

The match panel

Before you make the map you'll see the detected mapping. You can:

  • Switch between address mode and coordinate mode.
  • Reassign any column (which is the address, which is the label) or reset to auto.
  • Choose which columns show as the marker label.

Rows that can't be placed appear in the Attention tray with a plain-language reason (no address found, coordinates out of range, empty row, and so on). You can exclude or restore them — they never block the rest of your map. See FAQ & Troubleshooting for fixes.

Addresses become points

When you make the map, addresses are geocoded to coordinates. Rows that already have valid latitude/longitude plot instantly with no lookup. Low-confidence matches are flagged as Approximate location on the map so you can spot them.

Still need a hand? Contact support.