Export routes to ExcelCopy link
Every optimized plan exports as one workbook. There is no print view or PDF.
Where to export fromCopy link
- Export in the header of the Optimize page downloads the full solution
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 Addresses, Orders, Depots, or Fleet page exports just that one list, plus a Documentation sheet scoped to it.
- More > Download template downloads an empty spreadsheet with the right headers and example rows for re-import.
The sheets in the solution workbookCopy link
| 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. Columns that would be empty for your plan are left out, so your workbook may have fewer columns than the tables below.
Routes stops columnsCopy link
One row per stop, grouped by route and ordered as driven. These tables are generated from the same definitions the exporter writes with. Columns marked Format: Time * hold real Excel time values rather than text, as explained in the 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, so they work from an emailed copy of the sheet.
Routes stats columnsCopy link
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). If not defined, the vehicle will have unlimited capacity. Note that the vehicle capacity must be greater or equal to the orders 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 sheetCopy link
In a solution export the Orders sheet gains an Unplanned column. It is empty for served orders; for dropped orders it carries the same explanation you see in the unassigned panel on the Optimize page.
Units follow your SettingsCopy link
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 limitsCopy link
Exporting is available on every tier, signed in or not. If your plan uses paid-tier features and your free trial budget is spent, the export shows a warning first, then proceeds. See Plans, billing, and free limits for how that budget works.
Next stepCopy link
The same workbook format imports back in, column for column: Import your stops.