Import addresses from Excel, CSV or JSON
The fastest way to load a large address list into Mappy. Supports .xlsx, .xls, .csv and .json files up to 10 MB and 1,000 rows.
Open Mappy and click the upload area
Go to mappy.ba/app. The upload area is at the top of the sidebar. Drag your file directly onto it, or click anywhere on the upload area to open a file browser. Mappy accepts .xlsx, .xls (older Excel format), .csv (comma, semicolon, or tab-delimited), and .json files. Maximum file size is 10 MB.
Review the file preview
A preview of the first 10 rows appears immediately after the file is read. Empty columns are hidden, and no address columns are selected automatically. Use the preview to intentionally choose which column or columns contain address data. If your file has no header, columns are labelled A, B, C automatically.
Set the start row
Click on the row in the preview that represents your first data row. If your file has a header row (row 1 = column names like "Address", "Street", "City"), click row 2 as the start row — Mappy uses row 1 as column labels. If there's no header and your data starts on row 1, click row 1. You can click the same row again to deselect. The Import button stays disabled until a start row is selected.
Select one or more address columns
Click the larger left side of each column header to include it in the address. Use the smaller sort area only when you want to reorder the preview. You can select multiple columns — for example "Street" and "City" — and Mappy joins them with a comma. Do not select CRM notes, categories, phone numbers or full CSV export rows unless they are truly part of the address.
Click Import
Click the Import button. Mappy adds all rows to your address list and immediately starts geocoding each one in a background queue (3 parallel workers, with retry logic). You can see validation status update in real time next to each address. Green ✓ = found, red ✗ = not found (click to edit), yellow ⚠ = found with lower confidence (verify pin on map).
Fix any invalid addresses
Before creating zones, fix any red addresses. Click the red ✗ indicator or the edit pencil (✎) to open an inline editor. Correct the address — add the city name, fix a typo, or add the country — and click Save & Retry. Mappy re-validates immediately. If an address genuinely doesn't exist, click the trash icon to remove it.
Sort and create zones
Once validation is complete, choose a sort order (manual, A→Z, nearest first, or fastest route). Click Create Zones. Mappy splits your list into groups of up to 10 addresses and generates a Google Maps link for each zone. Tap Open in Maps to start navigating.
.xlsx and .xls (Excel)
Standard Microsoft Excel format. Exported by Excel, Google Sheets (File → Download → .xlsx), LibreOffice Calc, Numbers (Mac). Mappy reads the first sheet only. If your addresses are on a different sheet, move them to Sheet 1 before importing.
.csv (comma-separated values)
Plain text format exported by nearly every spreadsheet, ERP, CRM or dispatch system. Delimiter can be comma (,), semicolon (;) or tab — Mappy detects automatically. Encoding: UTF-8 preferred. Files with Windows-1250 encoding (common in Central/Eastern Europe) are also supported.
.json
Accepts a JSON array of strings (["addr1", "addr2"]) or an array of objects with any key containing address data. In the column mapping step, select the key that holds your address. Useful for developers or systems that export to JSON directly.
- Use full addresses including street name, number, and city. "Ferhadija 1, Sarajevo" geocodes far better than just "Ferhadija 1".
- If addresses are split across columns (Street | City), select both. Mappy joins them automatically.
- For files with inconsistent formatting, clean obvious issues first: remove leading/trailing spaces, correct encoding (UTF-8 is safest).
- Do not mix address formats in the same column — e.g. some rows with city included and some without. This produces inconsistent geocoding results.
- Files exported from older systems sometimes have Windows line endings (\r\n) or BOM markers — Mappy handles both automatically.
Can I import addresses from Google Sheets?
Yes. In Google Sheets: File → Download → Microsoft Excel (.xlsx). Import that .xlsx file into Mappy. Alternatively, download as CSV.
My file has a header row. Does Mappy handle that?
Yes. Set the start row to row 2 (the first data row). Mappy treats row 1 as column labels shown in the column selector chips.
Can I combine Street and City columns?
Yes. Click both column chips in the mapping step. Mappy joins them: "Maršala Tita 54" + "Sarajevo" → "Maršala Tita 54, Sarajevo". The combined string is sent to geocoding.
What happens if I import a duplicate address?
Mappy detects duplicates (case-insensitive) during import and skips them — existing addresses in your list are never overwritten.
My file has 1,200 rows. What do I do?
Mappy imports a maximum of 1,000 rows per file — a warning is shown and extra rows are dropped. For larger files, split into two imports.