Export routes to Excel
By Nathan ColeUpdated
Every optimized plan exports as an Excel workbook from Export on the Optimize page. The Routes stops sheet lists every stop in driving order with its ETA. The Routes stats sheet has one summary row per route. The Orders, Depots, and Vehicles sheets repeat your inputs, with the reason for every unassigned order. Exporting works on every tier.
There is no print view or PDF. This page lists where to export from, every sheet in the routing plan workbook, and the columns of the two route sheets.
Where to export from
- Export in the header of the Optimize page downloads the full routing plan
workbook, named
{plan} - {optimization}.xlsx. - My Plans > Export Excel downloads the workbook for any saved plan without opening it first.
- More > Export to Excel on the Address Book, Orders, Depots, or Fleet page exports that one list only, plus a Documentation sheet scoped to it.
- More > Download template downloads an empty spreadsheet with the expected headers and example rows for re-import.
The sheets in the routing plan workbook
| Sheet | Purpose |
|---|---|
| Routes stops | Every stop of every route, in driving order, with ETAs. |
| Routes stats | One summary row per route: totals, load factors, cost. |
| Orders | Your full order list, plus the reason for every unassigned order. |
| Depots | Your depots as imported. |
| Vehicles | Your vehicle types as imported. |
| Documentation | A column-by-column reference for every other sheet. |
Routes stops is the first sheet in the workbook. The exporter omits columns that would be empty for your plan, so your workbook may have fewer columns than the tables below.
Routes stops columns
The Routes stops sheet contains one row per stop, grouped by route and ordered as driven. The tables below come from the same definitions the exporter writes with. Columns marked Format: Time * contain real Excel time values rather than text, as explained in the Spreadsheet column reference.
| Column | Meaning |
|---|---|
| Vehicle id | Format: Text·Required Route vehicle. Example: |
| Route # | Format: Number·Required Route index. Example: |
| Stop # | Format: Number·Required Stop index within the route. Example: |
| Trip # | Format: Number·Optional Trip number within the route (multi-trip / reloads). 1 for a single-trip route. Increments each time the vehicle returns to a depot mid-route to reload; the reload depot itself opens the next trip. Example: |
| AddressAliasesAdress | Format: Text·Required Street address in free format. Address will be geolocated automatically during Excel import if coordinates are not provided. If address is not known, a unique string and geographical coordinates should be used instead. Example: |
| AreaAliasesCity | Format: Text·Optional Address country, state, city, or area name in free format. Can be specified in addition to address to increase address geolocation quality. Example: |
| LatAliasesLatitude | Format: Number·Optional Address latitude. When used, must be defined together with "Lng". If omitted, the address will be geolocated automatically during Excel import. Example: |
| LngAliasesLonLongitude | Format: Number·Optional Address longitude. When used, must be defined together with "Lat". If omitted, the address will be geolocated automatically during Excel import. Example: |
| Address G map | Format: Text·Optional Google Maps™ URL for the address location. Example: |
| Address G directions | Format: Text·Optional Google Maps™ URL for the route from the previous stop to this stop. Example: |
| Stop | Format: Text·Required Stop unique identifier ("Order.id" or "Depot.id"). Example: |
| Type | Format: Text·Optional Stop type ("Order" or "Depot"). Example: |
| Travel dist, kmAliasesTravel dist, mi | Format: Number·Optional Estimated travel distance from previous stop to this stop, in km. Example: |
| Travel time | Format: Time *·Optional Estimated travel time from previous stop to this stop (HH:MM or HH:MM:SS). Example: |
| ETA | Format: Time *·Optional Estimated time of arrival at the stop. Example: |
| ETA day | Format: Number·Optional Day of the estimated time of arrival at the stop (e.g. +1 day indicates that time is for tomorrow). Example: |
| Open fromAliasesOpen at | Format: Time *·Optional Site time window start. Earliest time when the job can be started at this site. If not defined, the job can be started at any time. Add "Open from 2".."Open from 4" (+ matching "Open to N") columns for alternative delivery windows. Example: |
| Open from day | Format: Number·Optional Relative day of the site time window start. If not defined, time window starts on the same day. For value of "1", time window starts on the +1 day (next day), etc. Example: |
| Open toAliasesOpen until | Format: Time *·Optional Site time window end. Latest time when the job can be started at this site. If not defined, the job can be started at any time after time window start. Example: |
| Open to day | Format: Number·Optional Relative day of the site time window end. If not defined, time window ends on the same day. For value of "1", time window ends on the +1 day (next day), etc. Example: |
| Job timeAliasesService time | Format: Number·Optional Duration of the job at the stop. Example: |
| Order type | Format: Text·OptionalPRO Order type of the stop: "Pickup" or "Delivery" for the two ends of a site-to-site transfer, "Depot" for a regular order or a depot stop. A "Depot" stop is a regular order served from the depot (its load is delivered from the depot, or picked up and brought back to it), or a depot visit itself. A "Pickup" stop and its matching "Delivery" stop are the two ends of one transferred load: it is picked up at the "Pickup" stop and dropped at the "Delivery" stop later on the same route. Example: |
| DeliveryAliasesQuantity | Format: Number·Optional Total load delivered to the stop. Example: |
| Pickup | Format: Number·Optional Total load picked up from the stop. Example: |
| Carried load | Format: Number·Optional Current load carried by the vehicle when visiting the stop. Example: |
| Moved load | Format: Number·Optional Total load-distance metric (load units × km). Example: |
The two Google Maps™ columns link each row to the stop on the map and to turn-by-turn directions from the previous stop. The links resolve outside Routing24 and work from an emailed copy of the sheet.
Routes stats columns
The Routes stats sheet contains one row per route.
| Column | Meaning |
|---|---|
| Route # | Format: Number·Required Route index. Example: |
| Vehicle id | Format: Text·Required Route vehicle. Example: |
| Vehicle capacity | Format: Number·Required Vehicle capacity. Total load a vehicle can carry, in user-defined units (e.g., weight, volume, items, seats). This column is the plan's FIRST load unit; additional declared units have their own "Capacity, <unit>" columns (see that column). If not defined, the vehicle will have unlimited capacity. The vehicle capacity must be greater than or equal to each order's load. Example: |
| Trips | Format: Number·Optional Number of trips the vehicle made on this route (1 unless it reloaded). Example: |
| Vehicle cost | Format: Number·Optional Total cost of this route (fixed + distance + duration + per-stop). Example: |
| Load factor (Peak), % | Format: Number·Required Route vehicle load factor Calculated as F = L/C, where L is the maximum load the vehicle carries at any time during the route, and C is the total vehicle capacity. Example: |
| Load factor (DW), % | Format: Number·Required Route vehicle load factor, distance-weighted. Calculated as F = Σ(Load_i × Distance_i) / Σ(Capacity × Distance_i), where Load_i is the load carried on each route leg, and Distance_i is the distance traveled on each leg. Example: |
| Start time | Format: Time *·Required Route start time. Example: |
| End time | Format: Time *·Required Route end time. Example: |
| Total stops | Format: Number·Required Total number of stops on the route. Starting, ending and intermediate sepots are not counted. Example: |
| Total overload | Format: Number·Required Total vehicle overload on the route. Vehicles can be overloaded in case of vehicle shortage or when orders have loads larger than the capacity of any available vehicle view. The optimization will try to minimize overloads in that case, respecting other strict rules defined. Example: |
| Total delivered load | Format: Number·Required Total load delivered to stops on the route. Example: |
| Total picked up load | Format: Number·Required Total load picked up from stops on the route. Example: |
| Total job time | Format: Time *·Required Total job duration at stops on the route. Example: |
| Total travel time | Format: Time *·Required Total vehicle travel duration on the route. Example: |
| Total wait time | Format: Time *·Required Total waiting duration on the route. In certain cases vehicles can arrive at a stop before the job's earliest start time. In this case, the vehicle will wait until the earliest job start time before starting the job. Example: |
| Total travel dist, kmAliasesTotal travel dist, mi | Format: Number·Required Total travel distance by the vehicle on this route, km. Example: |
| Shared with | Format: Text·OptionalSTARTER Emails the route is shared with. Comma-separated list of emails with access to the shared route. Empty if the route is not shared. Example: |
Unplanned reasons in the Orders sheet
In a routing plan export the Orders sheet gains an Unplanned column. The column is empty for served orders. For a dropped order it contains the same explanation the Unassigned panel on the Optimize page shows. The full list of reasons is in Why an order went unassigned.
Units follow your Settings
Distances export in kilometers or miles and times in 24-hour or 12-hour format, as set in Settings. Column headers change with the unit ("Travel dist, km" becomes "Travel dist, mi"). If you switch units, re-run the optimization and re-download templates so files and plan agree.
Export and tier limits
Exporting works on every tier, signed in or not. When a plan uses paid-tier features and the free paid-feature budget is spent, the export shows a warning first, then proceeds. See Plans and billing for how the budget works.
Next step
The same workbook format imports back in, column for column: Import your orders.
FAQ
Where do I export the routes from?
Press Export in the header of the Optimize page to download the full routing plan workbook. My Plans, then Export Excel downloads the workbook of any saved plan without opening it. More, then Export to Excel on an editor page exports that one list only. Download template provides an empty sheet with the expected headers.
Which sheets are in the routing plan workbook?
The workbook has six sheets. Routes stops lists every stop of every route in driving order with ETAs. Routes stats has one summary row per route with totals, load factors, and cost. Orders repeats your order list plus the reason for every unassigned order. Depots and Vehicles repeat your inputs. Documentation explains every column. The exporter omits empty columns.
Do the Google Maps™ links in the export work outside Routing24?
Yes. The Routes stops sheet has two Google Maps™ columns per row. One opens the stop on the map and the other opens turn-by-turn directions from the previous stop. Both links resolve in Google Maps™ itself, not in Routing24, so they work from a copy of the sheet emailed to a driver or pasted into another system.
Can I export as PDF or print the routes?
No. Routing24 exports one Excel workbook and has no print view or PDF export. Open the workbook in Excel or Google Sheets and print the Routes stops sheet from there, filtered to one route per driver if needed. Drivers receive their route as a shared mobile link instead, which opens in the phone's browser with ETAs and navigation.
Why are distances in miles in my export?
Distances export in kilometers or miles and times in 24-hour or 12-hour format, as set in Settings at the bottom of the left menu. Column headers change with the unit, so Travel dist, km becomes Travel dist, mi. After switching units, run the optimization again and download templates again so the files and the plan agree.