How it works

From spreadsheet to Google Maps in 7 steps

Follow these steps to go from a raw address list to a navigable, optimized Google Maps route — in under two minutes.

Step by step

Open Mappy — no login needed

Go to mappy.ba/app in Chrome, Safari or any modern browser — on your phone, tablet or desktop. No account required, nothing to install. Mappy works entirely in your browser.

Import your address list

Drag your file onto the upload area or click to browse. Mappy reads Excel (.xlsx and .xls), CSV and JSON files up to 10 MB with up to 1,000 addresses. A 10-row preview appears — empty columns are hidden, no address column is selected by default, and you choose only the columns that really form the address.

Validate every address automatically

After import, Mappy immediately validates every address against real map data using multiple external geocoding providers with automatic fallback. Each row shows a live status: green ✓ (found and pinned on map), red ✗ (not found — click to edit), or yellow ⚠ (needs review). Catch and fix errors before you leave, not during your run.

Sort your route

Choose how to order your stops: Manual (drag cards or use arrow buttons), A→Z alphabetical, Nearest first (sorted by straight-line distance from your GPS position), or Fastest route (2-opt + or-opt algorithm that minimises total route distance). GPS is only requested when you choose Nearest or Fastest — never on load.

Create delivery zones

Click Create Zones. Mappy splits your validated address list into sequential groups of up to 10 stops. This is necessary because Google Maps supports a maximum of 10 waypoints per route. Each zone is ordered optimally and gets its own Google Maps link.

Navigate zone by zone

Tap Open in Maps on Zone 1. Google Maps launches with all stops pre-loaded in optimized order — ready to navigate. Complete the zone, tap Mark as Delivered, then open Zone 2. Mappy tracks your progress across all zones.

All done — Mappy resets automatically

When every zone is marked delivered, Mappy shows a summary of your delivery stats (zones completed, total stops) and automatically clears all data for the next run. Your language and theme preferences are preserved.

Detailed guides

Learn each import method

📊

Import from Excel, CSV or JSON

How to select columns, set the start row, and handle files with multiple address columns.

📷

Scan a printed address list

Use your phone camera to scan printed delivery manifests. Tips for better OCR accuracy.

🔲

Import via QR code

Scan QR codes that contain address lists. How to generate compatible QR codes.

📍

Tips for accurate addresses

Why addresses fail validation and how to format them for best geocoding results.

Common questions

Frequently asked questions

What file formats does Mappy support?

Excel (.xlsx and .xls), CSV, and JSON. Maximum file size is 10 MB; maximum 1,000 addresses per import. For CSV files, any delimiter is supported — Mappy auto-detects comma, semicolon, and tab.

How accurate is the geocoding?

Mappy validates every address against multiple external geocoding sources with automatic fallback. Accuracy is very high for addresses in Bosnia & Herzegovina, Germany and Austria. Always verify pin locations on the map before critical deliveries, especially for newly built addresses.

Does Mappy work offline?

No — geocoding and map tiles require an internet connection. However, once addresses are validated and zones are created, the delivery tracking panel continues working. If you lose connection mid-delivery, your zone progress is saved in the browser.

Can I use Mappy on my phone?

Yes. Mappy is fully responsive and works in Chrome on Android and Safari on iPhone. The sidebar slides in from the left on mobile. Tap "Open in Maps" to launch the Google Maps app directly with all stops loaded.

What happens if an address is not found?

Mappy marks it red (✗) with an inline edit dialog. You can correct incomplete addresses and tap Save & Retry — Mappy re-validates immediately. Common fixes: add the street name, city, postal code or country. If Mappy extracts an address from long text, confirm it before validation.

Ready to try it?

Drop your spreadsheet in and you're navigating in under two minutes.

Open Mappy — Free, no login

Keep exploring