Import addresses from Excel, CSV or JSON
Load up to 1,000 addresses from Excel, CSV or JSON and keep useful delivery details such as priority, working hours and notes attached to the correct stop.
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.
Assign address and delivery columns
Select one or more columns that form the address, such as Street + City. Right-click a column or use its role tag to assign Priority, Available from, Available until, Working hours, Delivery note or Ignore. With a header row, Mappy suggests recognized delivery roles, but you should confirm them before importing.
Import and review every stop
Click Import. Address text is geocoded and recognized priority, availability and note values stay attached to the matching row. Green ✓ = found, red ✗ = not found, and yellow ⚠ = found with lower confidence. Open a stop to check or edit its delivery details.
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.
Choose an order and adjust zones
Use Recommended order when priorities or availability windows matter, or choose manual, A→Z, nearest first or shortest air-distance. After Create Zones, change the stop limit for each waiting zone or move a constrained stop earlier or later before opening Google Maps.
.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.
Which delivery-detail columns can Mappy import?
Priority, Available from, Available until, Working hours or Delivery window, and Delivery note. Common English, Bosnian, German and Spanish headers are detected when a header row is present; you can also assign those roles manually in the preview.
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.