Excel → Google Maps

Import Excel addresses into Google Maps

A direct way to turn an Excel or CSV address list into Google Maps zones, with pin validation and straight-line ordering. The core planner works without login.

Open Mappy — Free, no login

How it works

3 steps from Excel to navigation

Upload your Excel or CSV file

Go to mappy.ba/app and drag your file onto the upload area. Mappy reads .xlsx, .xls, .csv and .json files. A preview shows the first 10 rows. Empty columns are hidden, and no address column is selected by default, so choose only the column or columns that really form the delivery address. If your file has a header row (e.g. "Address", "Street", "City"), click row 2 as the start row so Mappy skips the header.

Mappy validates and maps every address

After import, Mappy automatically geocodes every address — querying multiple external geocoding providers and pinning each one on the map. Green ✓ means the address was found with high confidence. Red ✗ means it couldn't be located — click the row to edit and retry. Yellow ⚠ means it was found but with lower confidence — verify the pin location on the map before including it in your route.

Sort, split into zones, open in Google Maps

Choose manual drag, A→Z, nearest first, or shortest air-distance route. Create Zones splits the list into groups of up to 10 stops and creates chained Google Maps links in that order.

Supported formats

What file formats work with Mappy

📊

Excel .xlsx and .xls

The most common format from tools like Microsoft Excel, Google Sheets (export as .xlsx), LibreOffice Calc. Mappy reads any sheet structure — select your address column from the preview.

📄

CSV (any delimiter)

Comma-separated, semicolon-separated, or tab-separated values. Exported from any ERP, dispatch software, or CRM. Mappy auto-detects the delimiter.

📋

JSON

Arrays of address strings or objects with an address field. Useful for developers or systems that export directly to JSON.

Tips for best results

How to structure your address data

✅

Use full addresses

Include street name, house number, and city in each row. "Ferhadija 1, Sarajevo" geocodes far more reliably than just "Ferhadija 1".

✅

Combine only address columns

If your file has separate Street and City columns, select both when importing. Mappy joins them automatically: "Ferhadija 1" + "Sarajevo" → "Ferhadija 1, Sarajevo". Avoid selecting CRM notes, categories, phone numbers or full CSV export rows as address input.

✅

Set the start row correctly

If row 1 contains column names (headers), click row 2 as the start row. Mappy uses the header row as column labels in the preview.

❌

Avoid addresses without a house number

Street-only addresses like "Ferhadija" (no number) often match to the centre of the street rather than a specific property. Add a number or a landmark reference.

Google Maps limit explained

Why Google Maps only allows 10 stops — and how Mappy fixes it

Mappy splits a long list into sequential zones of up to 10 stops. Zone 1 covers stops 1–10, Zone 2 continues with stops 11–20, and each Google Maps link starts from the previous zone's final stop. The order is based on local straight-line optimization; Google Maps calculates the actual road route.

Common questions

Frequently asked questions

Can I import addresses from Google Sheets?

Yes. In Google Sheets, go to File → Download → Microsoft Excel (.xlsx). Then import that .xlsx file into Mappy. Alternatively, download as CSV (File → Download → CSV) and import the .csv file.

My addresses are in two columns — Street and City. Can Mappy handle that?

Yes. In the column mapping step, select both columns. Mappy joins them with a comma: "Maršala Tita 54" + "Sarajevo" becomes "Maršala Tita 54, Sarajevo". The combined address is sent to geocoding.

How many addresses can I import from Excel?

Up to 1,000 addresses per import from files up to 10 MB. If you have more, import in batches of 1,000.

Do I need to install any Excel plugin or add-on?

No. Mappy is a web tool — no plugin, no add-on, no installation. Just go to mappy.ba/app in your browser, upload your file, and you're done.

Can I save my route for later?

Yes. With an optional account you can save routes and reopen them later across sessions and devices. Without an account, your current work still stays in your browser while you plan and deliver.

Ready to import your first file?

Drag your Excel or CSV file into Mappy, review the address columns and validate the imported stops.