Importing your data

Mapize reads your locations from a spreadsheet and 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 — available on Pro and Pro Plus. The sheet must be shared as Anyone with the link or published to the web. See Live data with Google Sheets.

Free users can import Google Sheets data by downloading it as CSV or pasting the rows.

Uploaded files are read in your browser — the raw file is never uploaded to our servers.

Row and map limits

Mapize separates the size it can read from the number of locations a plan can save:

• 50,000 rows is the maximum per file import.
• Files up to 10,000 rows are the recommended range for smooth browser processing.
• The number of locations you can save on one map depends on your plan: Free 50, Lite 250, Pro 1,000, and Pro Plus 5,000.

Rows that do not resolve to locations do not become map points. See Plans & billing for all plan limits.

How columns are matched

Mapize detects two things automatically:

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

Detection uses both column headers and actual values, so a clearly numeric coordinate column can be 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 or reset the mapping to automatic.
• Choose which columns show as the marker label.

Rows that can't be placed appear in the Attention tray with a plain-language reason. You can exclude or restore them, and 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 with valid latitude and longitude plot instantly with no lookup. Low-confidence matches are flagged as Approximate location so you can review them.