Required import fields
Upper needs only one mapped field to import stops: the address. Everything else is optional. Use a full address, separate columns, or GPS coordinates.
When you import a spreadsheet into Upper, only one piece of information is required for each stop: its address. During import you map your spreadsheet columns to Upper's fields, and the only mapping you must complete is Address Line 1. Every other field is optional. The more data you include, the more useful the import — but an address on its own is enough to create a route.
Why this matters
You don't have to wait until your data is perfect to start using Upper. If you have a list of addresses, you have what you need. Add the optional details — names, phones, time windows, service times, custom data — as your operation matures, either in the same import or later. An address-only file is a valid starting point.
The one required field
When you reach the Review & Import step of an import, Upper shows a column-mapping panel where each of your spreadsheet columns is matched to an Upper field. The address is the only mapping you must complete.
| Field | Required? | What it holds |
|---|---|---|
| Address Line 1 | Yes | The stop's delivery or service location |
If Address Line 1 isn't mapped, Upper won't let you finish the import. Any column you leave unmapped shows Needs mapping, and a counter (for example, "6 of 6 columns mapped") tracks your progress.
Map-to fields are grouped — Address, Contact, Stop, Other, and any Custom, Capacity, or Barcode fields you've defined. Only the address field is required; the rest are there if your data includes them.
Accepted address formats
Upper accepts your address in a few different shapes. The rule is consistency — pick one format and use it for the whole file.
| Format | What it looks like |
|---|---|
| Full address in one cell | 123 Main St, New York, NY 10001 |
| Separate columns | Individual columns for street, city, state, and zip / postal code |
| GPS coordinates | Latitude and longitude — either as separate columns, or as bracketed latitude,longitude in a single cell |
Pick the format that matches your source data. If your system exports addresses already combined, use the single full-address cell. If it exports street, city, state, and zip in separate columns, use the separate-columns format. For job sites or new builds without a standard address, use coordinates.
Don't mix formats in the same file. If you use a single-cell address, keep every row single-cell; if you use separate columns, keep every row in separate columns. Mixing single-cell and multi-column rows is the thing to avoid.
Include the full address — street, city, state or province, and zip or postal code — for the best geocoding accuracy. An incomplete address (for example, a street with no city) is the most common reason a stop comes back as Needs Review or Not Found.
What you can add later
Everything beyond the address is optional, and you can add it in two ways:
At import time
Add the column to your spreadsheet and map it during the Review & Import step. Optional fields include full name, nickname, business name, phone, email, notes, service time, time windows, stop type, pin color, parcel count, a pre-assigned driver, and any custom, capacity, or barcode fields you've set up.
After import
Open a stop and edit it from the Edit a Stop panel, where you can fill in contact details, service time, time windows, priority, stop type, capacity, and parcel info.
Some labels depend on how your workspace is configured. A workspace set up for service work may show Technician and Service where the default is Driver and Delivery — both refer to the same fields.
After the import: address validation
Once an import finishes, Upper checks the addresses and shows a single red validation icon. Click it to see your stops grouped by status:
- Verified — the address resolved cleanly.
- Needs Review — Upper found a likely match but wants you to confirm it.
- Not Found — Upper couldn't locate the address.
- Duplicate — the address matches another stop in the list.
Each row in the stop list also shows its state in the Review column. Address-only imports work fine here — the more complete each address is, the more rows land in Verified.
Troubleshooting
Related
Optional import fields
Reference for the optional fields you can map during an Upper import — contact info, stop settings, priority, parcels, capacity, barcodes, and custom fields.
Specify details for multiple parcels at the same stop
A stop with several parcels in Upper? Set the parcel count, choose where to load it in the vehicle, and add a reference photo so drivers load and hand off the right items.