Excel → Google Maps

Import Excel addresses into Google Maps

The fastest way to turn an Excel or CSV address list into a navigable Google Maps route — with validation, optimization, and automatic zone splitting. Free, no login, works in any browser.

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 a sort order: manual drag, A→Z, nearest first from your GPS, or fastest route (2-opt algorithm). Click Create Zones — Mappy splits your list into groups of up to 10 stops (Google Maps' maximum). Each zone shows an "Open in Maps" button that opens Google Maps with all stops pre-loaded in optimized order. Navigate zone by zone, marking each as delivered.

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

Google Maps has a hard limit of 10 waypoints per route. This is a technical constraint of the Google Maps app, not something you can disable. If you have 50 addresses and try to add them all to one Google Maps route, only the first 10 will be used. Mappy solves this automatically: after optimizing your full list, it splits it into sequential zones of up to 10 stops each. Zone 1 covers stops 1–10, Zone 2 covers stops 11–20, and so on. You navigate each zone in sequence — one Maps session per zone. The order across zones is already optimized, so you're always driving the most efficient path.

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 and start navigating in under 2 minutes.