or click to browse · expects the standard RoutesETA .xlsx layout
Run Sheet
Project
Route
Output
More ▾
Action undone
Add Driver
Import Review
Edit Stop
Add Pickup & Delivery
Pickup
Delivery
Print Settings
Fleet Roster
The Daily Truck workbook joins its two sheets on Date + Fleet number, and the RoutesETA export has no fleet numbers in it. Map each driver to their fleet number here and the export fills columns A–D correctly on both sheets so the COUNTIFS / SUMIFS formulas resolve. Driver match is a partial, case-insensitive match on the run sheet driver name.
Service Level Rules
The Dispatch Science RoutesETA export has no service level column, so stops fall back to a default. Rules match text anywhere in the account name, reference fields or customer notes and set the service level for those stops. First matching rule wins. An actual Service Level / Delivery Type column in the file always overrides these.
Bulk Actions
0 selected stops. Pickup rows are skipped when changing service levels.