Spreadsheet columns reference
Column names do not have to match exactly: the import recognizes common headers and proposes a mapping you can correct. Only an address (or coordinates) is required for orders, and a capacity for vehicles.
Orders file
| Column | Also recognized as | Format and default |
|---|---|---|
| Order reference | order id, order number, ref, invoice, job id | Text |
| Customer name | customer, client, name, recipient, company | Text |
| Address | street address, delivery address, destination | Street; add City, State / province, ZIP / postal code and Country columns if separate |
| Latitude, Longitude | lat, lng, lon | Decimal degrees; skip geocoding |
| Demand (load units) | quantity, qty, packages, pallets, boxes, cases | Number; 1 if empty |
| Service time (min) | service time, duration, dwell time, time on site | Minutes; 5 if empty |
| Window start, Window end | earliest / latest, from / to, ready time / deadline | 08:30, 8:30 AM or an Excel time |
| Weight, Volume | kg, lbs, gross weight; m3, cu ft, cube | Number, same unit as the vehicles' limits |
| Required skills | skills, requires, equipment, certification | Comma-separated tags |
| Priority | prio, importance, urgency, mandatory | high, normal, low (or 1/2/3, P1/P2/P3) |
| Pickup address | pickup, collection address, origin, collect from | Makes the row a shipment |
| Pickup latitude, Pickup longitude | pickup lat, pickup lng | Decimal degrees |
| Pickup from, Pickup until | pickup start / end, collect after / before | Time |
| Pickup duration (min) | loading time, pickup minutes | Minutes; the order's service time if empty |
| Assigned vehicle | vehicle, van, truck, route | A vehicle name from the plan |
| Phone, Notes | tel, mobile; instructions, comments | Copied to the driver sheets |
Vehicles file (optional)
| Column | Also recognized as | Format and default |
|---|---|---|
| Vehicle | vehicle id, van, truck, unit, plate | Name used in results and assignments |
| Driver | driver name, operator | Text |
| Capacity (load units) | capacity, max load, payload | Number, required |
| Shift start, Shift end | start time / end time, available from / until | Time; 08:00 to 18:00 |
| Fixed cost | daily cost, vehicle cost | Cost of using the vehicle in the plan |
| Max weight, Max volume | weight capacity, payload kg; cubic capacity | Number; no limit if empty |
| Skills | equipment, capabilities | Comma-separated tags |
| Break (min), Break from, Break until | break duration, lunch from / until | Minutes and times |
| Start address | depot, depot address, start location | Defaults to the depot |
| End address | return address, return to | Defaults to the start; none = ends at the last stop |
No vehicles file? Enter the number of vehicles, their capacity, shift and break directly in the plan form. Skills, weight and volume limits and per-vehicle start points need a vehicles file.