Export Routes – Download Route Data In CSV And Navigation File Formats

Route4Me’s dynamic routing software uses proprietary and patented route optimization algorithms that allow you to plan the most time-efficient and cost-effective routes with multiple stops in a smooth and effortless manner. With Route4Me route planning software, you can export optimized routes and use them on the preferred GPS devices. The exported route data can also be shared with your team of delivery drivers, sales reps, field technicians, dispatchers, route planners, etc. Moreover, you can also use the exported data to make reports, perform data analyses, audit your routing operations, and perform many other activities that can help you grow and improve your enterprise business. In this guide, you will learn how to export route data from the Routes List, Routes Map, Route Editor, export detailed route data with export profiles, and more.

Export Route4Me routes as CSV, XML, and more, or export routes for navigation on Garmin, TomTom, and more.

 

 

Export Route Data With Route4Me Route Management Tools

Route4Me’s Business Route Planning Software enables you to plan and manage routes with a variety of tools like the Routes List, where you can view all of the planned and optimized routes on your Route4Me account, the Routes Map, where you can view multiple routes on an interactive map simultaneously and move stops within and between routes, and the Route Editor, where you can access and modify route stop details, and more. Additionally, each of these tools enables you to export route data either as a CSV spreadsheet or as navigation data for use with a GPS navigation device.

Route4Me enables you to export routes as customizable CSV spreadsheets and export route data for GPS navigation on Garmin, TomTom, etc.

 

Routes List – Export Routes From Routes List

To export route data from your Routes List, go to “Routes” and then “Routes” from the Navigation Menu. Then, click the Gear Icon next to the route you want to export. After that, hover over “Export” and select the preferred option from the menu. You can see the descriptions of all export items and how to customize the export file further on this page.

Export a route from the Route4Me Routes List by clicking the Three-Dot Icon.

 

Additionally, you can export the data from multiple routes. To export multiple routes’ data from your Routes List, first check the boxes next to the routes that you want to export. Next, click “File” from the top menu bar and hover over “Export Routes“. Then, select one of the available export options from the menu. NOTE: When exporting multiple routes, export for navigation isn’t available.

You can see the descriptions of all export items and how to customize the export file further on this page.

Export routes from Route4Me Routes List by selecting routes for export.

 

Routes Map – Export Route Data From Routes Map

To export route data from the Routes Map, first go to”Routes” and then “Routes Map” from the Navigation Menu. Then, click the Gear Icon next to the route that you want to export. After that, hover over “Export” and select one of the options from the menu. You can see the descriptions of all route items and how to customize the exported file further on this page.

Export route from Route4Me Routes Map by clicking the Gear Icon and selecting route export options.

 

Additionally, you can export the data from multiple routes. To export multiple routes’ data from your Routes Map, first check the boxes next to the routes that you want to export. Next, click “File” from the toolbar and hover over “Export Route“. Then, select one of the available export options from the menu. NOTE: When exporting multiple routes, export for navigation isn’t available.

You can see the descriptions of all export items and how to customize the export file further on this page.

Export routes from Route4Me Routes Map by selecting routes for export.

 

Route Editor – Export Routes From Route Editor

To export route data from the Route Editor, go to “Routes” and then “Routes” from the Navigation Menu of your enterprise route optimizer. Next, click the Open Icon next to the route you want to export to open it in the Route Editor.

Export routes by opening the preferred route in the Route Editor from the Routes List.

 

In the Route Editor, click “File” in the toolbar, hover over “Export Route” and select one of the available export options from the menu. You can find more details about each option further in this guide.     When you export routes from the Routes List, Routes Map, or Route Editor, you can select a variety of export formats. You can export route data as a CSV spreadsheet, exports route notes and tracking history as CSV, and export a Route Map Picture.

 

Detailed Route Export – Customizable CSV Spreadsheets For Exporting Routes

When you export routes from the Routes List, Routes Map, or Route Editor, you can select a variety of export formats. You can export route data as a CSV spreadsheet, exports route notes and tracking history as CSV, and export a Route Map Picture when exporting individual routes. Additionally, you can export route data for import into navigation devices such as Garmin. In detail, you can find more information on exporting route data for navigation further in this guide.

Export OptionDescription
CSVAllows you to export routes as CSV files with customizable data columns. Additionally, you can create custom export profiles that include your preferred data.
Notes as CSVExports the route notes with the attached photos, videos, text, voice messages, etc. as CSV files.
Minimal AS CSVExports only the items from the Route, Time, Time Travel Details, Density, Driver, and User Notes sections of the full export file.
Tracking History as CSVExports the tracking history of the route as a CSV file.
XMLExports the selected routes as markup XML files for convenient import into other software or systems.
Route Map PictureExports a high-resolution image of the route map with marked stops and highlighted route path.
Route AttachmentsExport an archive of all documents, image, video, and other media files attached to destination notes on the route.

 

Route4Me’s fastest route management software allows you to easily customize the exported file for your convenience. To customize the exported file, click “File” from the top menu bar, hover over “Export Route“, and select “Export CSV” from the menu. This will open the “Export Route Data” window that allows you to customize the list of items that you want to include in the exported CSV file. Specifically, you can use the “Field Search” bar to find the items that you want to include in the exported file. Type the full or partial name of the item that you are looking for into the “Field Search” bar, and select the preferred items from the search results.

Use the Field Search bar to select different attributes for route export when you export routes as CSV.

 

Check the boxes next to the items that you want to include in the exported file. The added items are displayed in the right section of the window, where you can change their order, which will change the order of the columns in the exported CSV file, or remove them from your selected items.

Select export items when you export routes as CSV spreadsheets with Route4Me.

 

To export the items in a specific order, click and hold the Position Icon next to the preferred item and drag it to your preferred position in the list. Furthermore, this will adjust the column order in the exported route CSV.

Select items for CSV route export and re-arrange selected route export items.

 

Export Profiles allow you to create templates with specifically selected items that can be saved and reused in the future. To create an Export Profile, check the boxes next to the items you want to include in the exported file, then type a preferred export template name into the Export Profiles field. The Export Profile can then be reused to export route data CSV spreadsheets with the same series of preferred items. Finally, click Export to download the file with all selected items to your device.

After selecting route export items, save route export profiles by writing a custom profile name and clicking 'Export'.

 

You can refer to the glossary below for clarification of the terms in the exported files.

ItemCSV TermDescription
Route
Sequence NumberSequence_NumberSequence number of the destination on the route.
Out Of Sequence DestinationsOut_of_Sequence_DestinationsNumber of destinations visited out of their planned route sequence position.
Destinations Arrived LateDestinations_Arrived_LateTotal number of destinations visited later than 1 minute 30 seconds after their Planned Visit Time.
Destinations Arrived EarlyDestinations_Arrived_EarlyTotal number of destinations visited earlier than their Planned Visit Time. Changes in value are triggered by marking Destinations as “Arrived” on the Mobile App earlier than and up to 1 second before their Planned Visit Time.
Destinations Arrived On TimeDestinations_Arrived_On_TimeTotal number of destinations visited within 1 minute 30 seconds of their Planned Visit Time.
Route IDRoute_IDThe unique internal identification number of the route.
Route NameRoute_NameThe name (alias) assigned to the route.
Route NumberRoute_NumberThe route number. This is relevant when you are exporting multiple routes.
Route Total DistanceRoute_Total_DistanceThe total distance traveled on the route.
Route Planned TimeRoute_Planned_TimeThe total estimated time required for completing the route.
Route Address CountRoute_Addresses_CountNumber of destinations on the route, excluding the departure address (depot).
Route Planned Total Drive TimeRoute_Planned_Total_Drive_TimeThe total drive time that is computed based on the Route_Planned_Time + Route_Planned_Total_Service_Time + Wait_Time variables.
Route Planned Total Service TimeRoute_Planned_Total_Service_TimeThe total planned time required for servicing all destinations on the route.
Scheduled ForScheduled_ForScheduled route start date and time.
Destination StatusStop_StatusThe last destination Status that was set or updated for the respective destination.
Destination Status Time UTCStop_Status_Time_UTCThe time (in UTC) when the respective destination Status was set or updated for the destination.
Destination Status TimeStop_Status_TimeThe time when the respective destination Status was set or updated for the destination in the time format of the main Route4Me account.
Actual Travel Distance (Mobile App)Actual_Travel_Distance_(Mobile_App)Actual Travel Distance traveled by assigned Users on the route. Actual Travel Distance is calculated based on the on-road Travel Distance between destinations and does not include distance traveled inside Geofences.
Actual Travel Distance (Telematics)Actual_Travel_Distance_(Telematics)Actual Route Travel Distance based on the received Telematics GPS data. Actual Travel Distance is calculated based on the on-road Travel Distance between destinations and does not include distance traveled inside Geofences.
Actual Travel Time (Mobile App)Actual_Travel_Time_(Mobile_App)Actual Route Duration is calculated based on the received Mobile App GPS data. Duration is measured from when the route was started to when the route was ended by the assigned User on the Mobile App.
Actual Travel Time (Telematics)Actual_Travel_Time_(Telematics)Actual Route Duration is calculated based on the received Telematics GPS data. Duration is measured from when the route was started to when the route was ended by the assigned User on the Mobile App.
Planned DestinationsPlanned_DestinationsTotal number of destinations currently without a status: Done, Skipped or Failed.
Failed DestinationsFailed_DestinationsTotal number of destinations marked as “Failed” by the assigned User via the Mobile App.
Skipped DestinationsSkipped_DestinationsTotal number of destinations marked as “Skipped” by the assigned User via the Mobile App.
Done DestinationsDone_DestinationsTotal number of destinations marked as “Done” by the assigned User via the Mobile App.”
Completed Planned Distance % (Telematics)Completed_Planned_Distance_%_(Telematics)Percentage of the route’s total planned distance that was traveled by the assigned Vehicle calculated based on the received Telematics GPS data.
Remaining Planned Distance % (Telematics)Remaining_Planned_Distance_%_(Telematics)Percentage of the route’s total planned distance that was not traveled by the assigned Vehicle calculated based on the received Telematics GPS data.
Deviated From Planned Distance % (Telematics)Deviated_From_Planned_Distance_%_(Telematics)Percentage of the route’s total planned distance that was deviated from by the assigned Vehicle calculated based on the received Telematics GPS data.
Completed Planned Distance % (Mobile App)Completed_Planned_Distance_%_(Mobile_App)Percentage of the route’s total planned distance that was traveled by the assigned User calculated based on the received Mobile App GPS data.
Remaining Planned Distance % (Mobile App)Remaining_Planned_Distance_%_(Mobile_App)Percentage of the route’s total planned distance that was not traveled by the assigned User calculated based on the received Mobile App GPS data.
Deviated From Planned Distance % (Mobile App)Deviated_From_Planned_Distance_%_(Mobile_App)Percentage of the route’s total planned distance that was deviated from by the assigned User calculated based on the received Mobile App GPS data.
Actual Travel Time (Mobile App + Telematics)Actual_Travel_Time_(Mobile_App_+_Telematics)Actual Route Duration is calculated based on the received Mobile App and Telematics GPS data.
Actual Travel Distance (Mobile App + Telematics)Actual_Travel_Distance_(Mobile_App_+_Telematics)Actual Travel Distance traveled by assigned User. Actual Travel Distance is calculated based on the on-road Travel Distance between destinations and does not include distance traveled inside Geofences.
Completed Planned Distance % (Mobile App + Telematics)Completed_Planned_Distance_%_(Mobile_App_+_Telematics)Percentage of the route’s total planned distance that was traveled by the assigned User calculated based on the combined Mobile App and Telematics GPS data.
Remaining Planned Distance % (Mobile App + Telematics)Remaining_Planned_Distance_%_(Mobile_App_+_Telematics)Percentage of the route’s total planned distance that was not traveled by the assigned User calculated based on the combined Mobile App and Telematics GPS data.
Deviated From Planned Distance % (Mobile App + Telematics)Deviated_From_Planned_Distance_%_(Mobile_App_+_Telematics)Percentage of the route’s total planned distance that was deviated from by the assigned User calculated based on the combined Mobile App and Telematics GPS data.
Address
Destination IDDestination_IDUnique internal identification number of the destination.
Destination UUIDDestination_UUIDUnique universal internal identification number of the destination.
AliasAliasСustom alias or name of the route destination. You can assign aliases to destinations for faster and easier route searches or other operating requirements.
AddressAddressInformation used for describing the location of a destination. Normally, an address should contain the location’s identifiers, such as street name and number, city, state, country, and zip code. An Address may also be referred to as a Stop or Destination. Learn more about Route4Me’s Standard Address Verification.
Address TypeAddress TypeType of action required at the Destination. Available destination Types: Delivery, Pickup, Break, Meetup, Service, Visit, Drive By. Destination Type can affect the optimization.
Address LatitudeAddress_latitudeLatitude of the destination (in decimal form) at the rooftop of the location.
Address LongitudeAddress_longitudeLongitude of the destination (in decimal form) at the rooftop of the location.
Curbside LatitudeCurbside_latitudeDestination curbside latitude coordinate in decimal value.
Curbside LongitudeCurbside_longitudeDestination curbside longitude coordinate in decimal value.
Customer
Address Book GroupAddress_Book_GroupCustom ID of the Address Book Group associated with the route destination.
Customer Purchase OrderCustomer_Purchase_OrderPurchase Order (PO) of the contact or customer associated with the route destination.
First NameFirst_NameFirst name of the recipient associated with the order or destination.
Last NameLast_NameLast name of the recipient associated with the order or destination.
EmailEmailEmail address of the recipient associated with the order or destination.
PhonePhonePhone number of the recipient associated with the order or destination.
Order
PriorityPriorityVisitation Priority of the destination or Order. The highest Priority is 1, and the lowest Priority is 65,535. Accordingly, destinations or Orders with higher priority are visited earlier on routes.
Invoice NumberInvoice_NumberCustom number of the invoice associated with the destination.
Reference NumberReference_NumberCustom reference number of the destination on the route. Useful for identifying individual destinations.
Order NumberOrder_NumberThe Order Number associated with the destination.
WeightWeightTotal weight capacity of a vehicle upon visiting a destination. Positive Weight values indicate the amount of loaded weight on the vehicle, while negative weight values indicate the total reserved weight capacity on the vehicle.
CostCostCost of the order associated with the destination.
RevenueRevenueRevenue generated from servicing the destination.
CubeCubeTotal cubical volume that is picked up or dropped off at the destination.
PiecesPiecesTotal number of pieces or deliveries that are picked up or dropped off at the destination.
Tracking NumberTracking_NumberTracking number associated with the destination or Order. Customers can use this number to track their visit or Order. Learn more about Route4Me Order Tracking.
Time
Service TimeService_TimeService Time (integer minutes or HH:MM:SS) of the destination. Service Time is the time assigned Users spend inside Destination Geofences.
Geofence Visited TimeGeofence_Visited_TimeAutomatically created timestamp of when the assigned User or Vehicle was detected as entering the Destination Geofence.
Geofence Departed TimeGeofence_Departed_TimeAutomatically created timestamp of when the assigned User or Vehicle was detected as leaving the Destination Geofence.
Geofence Time On SiteGeofence_Time_On_SiteTotal time spent by an assigned User on-site at a route destination calculated as the interval between the “Marked Arrival Time” and “Marked Departure Time”.
Geofence Local Visited LatitudeGeofence_Local_Visited_LatLatitude coordinate of the location where the destination was detected as visited through Geofencing with Mobile App tracking data.
Geofence Local Visited LongitudeGeofence_Local_Visited_LngLongitude coordinate of the location where the destination was detected as visited through Geofencing with Mobile App tracking data.
Geofence Local Departed LatitudeGeofence_Local_Departed_LatLatitude coordinate of the location where the destination was detected as departed through Geofencing with Mobile App tracking data.
Geofence Local Departed LongitudeGeofence_Local_Departed_LngLongitude coordinate of the location where the destination was detected as departed through Geofencing with Mobile App tracking data.
Time Window 1 StartTime_Window_StartStart Time of Time Window 1 (working hours) when the destination can be visited and serviced (Day 1, + HH:MM:SS or military time. For example: “Day 1, 9:00 AM”). Learn more about Route4Me’s Time Windows Route Optimization Constraint.
Time Window 1 EndTime_Window_EndEnd Time of Time Window 1 (working hours) when the destination can be visited and serviced (Day 1, + HH:MM:SS or military time. For example: “Day 1, 5:00 PM”). Learn more about Route4Me’s Time Windows Route Optimization Constraint.
Time Window 2 StartTime_Window_Start_2Start Time of Time Window 2 (working hours) when the destination can be visited and serviced (Day 2, + HH:MM:SS or military time. For example: “Day 2, 9:00 AM”). Learn more about Route4Me’s Time Windows Route Optimization Constraint.
Time Window 2 EndTime_Window_End_2End Time of Time Window 2 (working hours) when the destination can be visited and serviced (Day 2, + HH:MM:SS or military time. For example: “Day 2, 5:00 PM”). Learn more about Route4Me’s Time Windows Route Optimization Constraint.
Optimized Time Window StartOptimized_Time_Window_StartTime window start after applying time constraint relaxation.
Optimized Time Window EndOptimized_Time_Window_EndTime window end after applying time constraint relaxation.
Planned Arrival TimePlanned_Arrival_TimeDynamic predicted Arrival Time when the assigned User will arrive at the destination. The Arrival Time is calculated based on the route Start Time, the Travel Time to the next destination, the Wait Time (if applicable) to the next destination, and the Service Time at each destination.
Planned Departure TimePlanned_Departure_TimeDynamically predicted Departure Time when the assigned User will depart from the destination. The Departure Time is calculated based on the route Start Time, the Travel Time to the next destination, the Wait Time (if applicable) to the next destination, and the Service Time at each destination.
Predicted Arrival TimePredicted_Arrival_TimeWhen an assigned User arrives at the destination earlier or later, the Predicted Arrival Time of all remaining destinations on the route will be affected.
Predicted Departure TimePredicted_Departure_TimeWhen an assigned User departs from the destination earlier or later, the Predicted Departure Time of all remaining destinations on the route will be affected. The Predicted Departure Time constantly changes to accurately reflect when an assigned User will depart to the next destination on the route.
Time Impact (Driver Time Impact)Time_ImpactTime impact (duration expressed in minutes) the assigned User had on the destination from arriving early or late compared to the planned time.
User Opened RouteUser_Opened_RouteDate and time when the route was first opened by the assigned Driver. Applies only to the Driver User Type.
Planned End TimePlanned_End_TimePlanned route end time calculated based on the Scheduled Start Time + Planned Route Duration.
Actual Average Service TimeActual_Average_Service_TimeTotal amount of the average actual Service Time of visited destinations calculated based on the reported and geofence-detected Time On Site.
Planned Average Service TimePlanned_Average_Service_TimeTotal amount of the average planned Service Time of all destinations on the route.
Planned Route Start DatePlanned_Route_Start_DateDate when the route is or was planned to start.
Planned Route Start TimePlanned_Route_Start_TimeTime when the route is or was planned to start.
Route End DateRoute_End_DateDate when the route is planned to be or was completed.
Route End TimeRoute_End_TimeTime when the route is planned to be or was completed.
Route Start Button TimestampRoute_Start_Button_TimestampTimestamp of the time when the route was actually started.
Route End Button TimestampRoute_End_Button_TimestampTimestamp of the time when the route was actually completed.
Time From Start To First DestinationTime_From_Start_To_First_DestinationTime duration from the start of the route to the first destination on the planned route. Calculated based on the Planned Arrival Time of the first destination on the route. Represents the Travel Time between the route origin (depot) and first destination.
Time From Last Destination To StartTime_From_Last_Destination_To_StartTime duration from the last destination on the planned route to the route origin location (depot). Used for round trip routes where the assigned User returns to the route origin (depot) after completing the last destination on the route.
Address Visit Details
VisitedVisitedColumn indicating whether the address was marked as “Visited” or not.
Address Book Last VisitedAddressBook_Last_VisitedTime when the given address from the Address Book was last marked or detected as visited.
Address Book Last DepartedAddressBook_Last_DepartedTime when the given address from the Address Book was last marked or detected as departed.
Marked Arrival TimeMarked_Arrival_TimeTimestamp created when the assigned User manually marked the destination as “Arrived” on the Mobile App.
Marked Departure TimeMarked_Departure_TimeTimestamp created when the assigned User manually marked the destination as “Done” or “Failed” on the Mobile App.
Marked Destination TimeMarked_Stop_TimeTime assigned User spent on-site at the destination and marked manually on the Mobile App.
Visited LatitudeVisited_latitudeLatitude coordinates of the location where the address was marked as visited.
Visited LongitudeVisited_longitudeLongitude coordinates of the location where the address was marked as visited.
DepartedDepartedColumn indicating whether the address was marked as “Departed” or not.
Departed LatitudeDeparted_LatitudeLatitude coordinate of the location where the destination was marked as departed. Destinations are marked as departed when the assigned User sets a destination status on the Mobile app.
Departed LongitudeDeparted_LongitudeLongitude coordinate of the location where the destination was marked as departed. Destinations are marked as departed when the assigned User sets a destination status on the Mobile app.
Distance
Distance To NextDistance_to_NextTotal distance from the given destination to the next one on the planned route.
Travel Time Details
Drive Time To NextDrive_Time_to_NextDynamically predicted drive time from the given destination to the next one on the planned route.
Running Service TimeRunning_Service_TimeTotal time spent by an assigned User on servicing previous destinations on a route upon reaching the given destination.
Running Travel TimeRunning_Travel_TimeTotal time traveled by assigned User upon reaching the given destination on the planned route.
Running Wait TimeRunning_Wait_TimeTotal amount of inactive time spent by assigned User upon reaching the given destination on the route (i.e., arrived at an address before the opening hours and a driver had to wait, etc.)
Route Wait TimeRoute_Wait_TimeTotal amount of time that a driver spent being inactive while driving the route (i.e., a route started before the opening hours and a driver had to wait, a driver arrived at the address before the opening of the Time Window, etc.).
Travel Distance Details
Running DistanceRunning_DistanceTotal distance traveled by a User upon reaching the given destination on the planned route.
Fuel
Fuel From StartFuel_From_StartAmount of fuel (in gallons) consumed for getting to the route destination. This value is calculated based on the Travel Distance and Vehicle Fuel Consumption data part of the Fleet Vehicle Details.
Fuel Cost From StartFuel_Cost_From_StartTotal cost of the consumed fuel used for getting to the route destination.
Operations
Remaining WeightRemaining_WeightThe remaining Planned Weight amount to be completed for planned route destinations.
Remaining PiecesRemaining_PiecesThe remaining Planned Pieces amount to be completed for planned route destinations.
Remaining CubeRemaining_CubeThe remaining Planned Cube volume to be completed for planned route destinations.
Total CostTotal_CostCost associated with completing all destinations on the planned route.
Total WeightTotal_WeightTotal Weight value of destinations on the planned route. (Vehicle Capacity Profile doesn’t effect this this value)
Total CubeTotal_CubeTotal Cube volume of destinations on the planned route. (Vehicle Capacity Profile doesn’t effect this this value)
Total RevenueTotal_RevenueRevenue generated from completing all destinations on the planned route.
Total PiecesTotal_PiecesTotal Pieces amount of destinations on the planned route. (Vehicle Capacity Profile doesn’t effect this this value)
Weight Remaining At End (%)Weight_Remaining_At_End_(%)Percentage of the total planned Weight amount that remains not completed at the end of the route. Destinations are completed when manually marked as “Done” via the Mobile App.
Cube Remaining At End (%)Cube_Remaining_At_End_(%)Percentage of the total planned Cube amount that remains not completed at the end of the route. Destinations are completed when manually marked as “Done” via the Mobile App.
Revenue Remaining At End (%)Revenue_Remaining_At_End_(%)Percentage of the total planned Revenue amount that remains uncompleted at the end of the route. Destinations are completed when manually marked as “Done” via the Mobile App.
Pieces Remaining At End (%)Pieces_Remaining_At_End_(%)Percentage of the total planned Pieces amount that remains not completed at the end of the route. Destinations are completed when manually marked as “Done” via the Mobile App.
Weight Completed (%)Weight_Completed_(%)Percentage of the total planned Weight amount that has been completed. Destinations are completed when manually marked as “Done” via the Mobile App.
Cube Completed (%)Cube_Completed_(%)Percentage of the total planned Cube (volume) amount that has been completed. Destinations are completed when manually marked as “Done” via the Mobile App.
Revenue Completed (%)Revenue_Completed_(%)Percentage of the total planned Revenue amount that has been completed. Destinations are completed when manually marked as “Done” via the Mobile App.
Pieces Completed (%)Pieces_Completed_(%)Percentage of the total planned Pieces amount that has been completed, in number of units. Destinations are completed when manually marked as “Done” via the Mobile App.
Notes
Note Type (Note Status)Note_TypeThe type of Note (note status) attached to the destination.
Note Content (Note Text)Note_ContentThe content (custom text) of the Note attached to the destination.
Note Attachment URLNote_Attachment_URLWeb address URL of the file that is attached to the Note of the destinations.
Note TimeNote_TimeTimestamp that was created upon adding the Note to the destination.
Note LatitudeNote_LatLatitude coordinates received by Route4Me’s servers upon adding the Note to the destination.
Note LongitudeNote_LngLongitude coordinates received by Route4Me’s servers upon adding the Note to the destination.
Device TypeDevice_TypeThe type of device that was used for recording Note Data or sending and receiving GPS signals and other data from Route4Me’s servers (iPhone, Android, etc.).
Route NotesRoute_NotesTotal number of Notes attached to destinations on the route. Normally, Notes are attached to destinations by the assigned User using the Mobile App.
Actual Visit Details
Actual Arrival Time ComputationActual_Arrival_Time_ComputationActual Destination Arrival Time timestamp computed according to the Actual Arrival Computation Method.
Actual Departure Time ComputationActual_Departure_Time_ComputationActual Destination Departure Time timestamp computed according to the Actual Departure Computation Method.
Actual Arrival TimeActual_Arrival_TimeTime when a driver actually arrived at the destination. The Actual_Arrival_Time is calculated based on the most accurate data, i.e., when the destination was marked as visited by a User or when a User entered the geofence around the destination and Route4Me automatically generated the Detected as Visited timestamp (M/D/YYYY HH:MM).
Actual Departure TimeActual_Departure_TimeTime when a driver actually departed the destination. The Actual_Departure_Time is calculated based on the most accurate data, i.e., when the destination was marked as departed by a User or when a User left the geofence around the destination and Route4Me automatically generated the Detected as Departed timestamp (M/D/YYYY HH:MM).
Actual Service TimeActual_Service_TimeTotal time spent by an assigned User on servicing a route destination. Value is the duration from when the Destination Geofence was detected as arrived to when it was detected as departed.
Expected Actual Distance from Previous DestinationExpected_Actual_Distance_From_Previous_DestinationExpected actual distance traveled from the previous destination on the route to the respective one.
Expected Actual Time from Previous DestinationExpected_Actual_Time_From_Previous_DestinationExpected actual time traveled from the previous destination on the route to the respective one.
Expected Actual Running DistanceExpected_Actual_Running_DistanceActual distance traveled by a driver by the time of reaching the given destination on the route.
Expected Actual Running Drive TimeExpected_Actual_Running_Drive_TimeActual time that has been driven by a driver by the time of reaching the given destination on the route.
Expected Actual Running Service TimeExpected_Actual_Running_Service_TimeActual time spent by a driver on servicing previous destinations on the route by the time of reaching the given destination.
Actual Distance Computation MethodActual_Distance_Computation_MethodMethod used for computing the actual traveled distance on the route (based on the Tracking Data, Estimated, etc.).
Actual Drive Time Computation MethodActual_Drive_Time_Computation_MethodMethod used for computing the actual driven time on the route (based on Mark_As_Visited_And_Departed, Geofence_Departed_And_Arrived, etc.).
Actual Arrival Time Computation MethodActual_Arrival_Time_Computation_MethodMethod used for computing the actual arrival time (based on Mark_as_Visited, Geofence_Entered, etc.).
Actual Departure Time Computation MethodActual_Departure_Time_Computation_MethodMethod used for computing the actual departure time (based on Mark_as_Departed, Geofence_Departed, etc.).
Actual Service Time Computation MethodActual_Service_Time_Computation_MethodMethod used for computing the actual Service Time of the destination on the route (based on Mark_As_Visited_And_Departed, Geofence_Departed_And_Arrived, etc.).
Expected Actual Time from StartExpected_Actual_Time_From_StartDynamically predicted Travel Time from the start of the route to the given destination.
Expected Actual Distance from StartExpected_Actual_Distance_From_StartDynamically predicted Trasvel Distance from the start of the route to the given destination.
Total Actual Route DistanceTotal_Actual_Route_DistanceActual total distance to complete the route, accounting for detours, delays, and other factors
Total Actual Route TimeTotal_Actual_Route_TimeActual total time to complete the route, accounting for all wait times, delays, and other factors.
Actual Route Start TimeActual_Route_Start_TimeActual time when the route started.
Actual Route Start DateActual_Route_Start_DateActual date when the route started.
Actual Total Service Time Driver ActionActual_Total_Service_Time_Driver_ActionActual Service Time of all route destinations according to driver app. Specifically, the time between marking the destination as arrived and assigning a destination status is the Driver Action Service Time.
Actual Total Service Time GeofenceActual_Total_Service_Time_GeofenceActual Service Time of all route destinations detected by Geofencing. Specifically, the time between the Geofence Detected Arrival and Geofence Detected Departure is the Geofence Service Time.
Custom
Custom Datayour_custom_dataCustom Data added to the destination will appear as a new column with the respective header and data contained in the column.
BarcodeBARCODELabel code of the Order associated with the respective destination. Learn more about Order Barcode Label Scanning.
Load Assist IDload_assist_idUnique Load Assist ID of the Order associated with the respective destination. Load Assist ID usually matches the route sequence position of the destination and is used to more easily track the loading status of orders.
Density
Stops Per On-Road HourStops_Per_On-Road_HourDynamically predicted number destinations (stops) visited per hour spent driving the route. If the route is completed, this will reflect the actual average value instead of an estimate.
Transactions Per On-Road HourTransactions_Per_On-Road_HourDynamically predicted number transactions per hour spent driving the route. If the route is completed, this will reflect the actual average value instead of an estimate.
Driver
Vehicle IDVehicle_IdUnique identification number of the vehicle associated with the route.
Vehicle AliasVehicle_AliasAlias (name) of the vehicle associated with the route. Vehicle Alias can be used to search for vehicles in the Vehicles List and when assigning vehicles to routes or dispatching routes to vehicles.
User
Member IDMember IdIdentification number of the team member assigned to the route.
Member EmailMember EmailEmail address of the team member assigned to the route.
Member First NameMember First NameFirst name of the team member assigned to the route.
Member Last NameMember Last NameLast name of the team member assigned to the route.

 

Additionally, for your convenience, the best route software enables you to export route data in a format that can be imported into navigation devices such as Garmin GPS devices and others. Below, you can see a description of the export options for different navigation devices. NOTE: When exporting multiple routes, export for navigation isn’t available.

Export routes for GPS navigation with devices such as Garmin, TomTom, and more. Export route data for import into GPS navigation.

File FormatDescription
TomTomExports an optimized route file with the route’s data that can be uploaded to TomTom devices and used for driving the exported route, respectively.
KMLExports an optimized KML (Keyhole Markup Language) file that can be uploaded and used on the devices that support the corresponding format.
FugawiExports an optimized route file with the route’s data that can be uploaded to Fugawi devices or software and used for driving the exported route, respectively.
Navigon 5Exports an optimized file with the route’s data that can be uploaded to the devices supporting the Navigon 5 maps and used for driving the exported route.
Navigon 6Exports an optimized file with the route’s data that can be uploaded to the devices that support the Navigon 6 maps and used for driving the exported route respectively.
FreshrouteExports an optimized file that can be used on Freshroute.
Garmin (GPX)Exports an optimized GPX file with the route’s data that can be uploaded to Garmin devices and used for driving the exported route, respectively.
Garmin (GPXX)Exports an optimized GPXX file with the route’s data that can be uploaded to Garmin devices and used for driving the exported route, respectively.
Garmin (GPXTRK)Exports an optimized GPXTRK file with the route’s data that can be uploaded to Garmin devices and used for driving the exported route, respectively.
Garmin (GPXRoute)Exports an optimized GPXRoute file with the route’s data that can be uploaded to Garmin devices and used for driving the exported route, respectively.
LMXExports an optimized file with the route’s data that can be uploaded to Nokia devices and used for driving the exported route, respectively.
TSXExports an optimized route file with the route’s data that can be uploaded to various devices or software and used for driving the exported route respectively.
UPDExports an optimized route file with the route’s data that can be uploaded to various devices or software and used for driving the exported route respectively.

 

Export Route Notes With Route4Me Route Management Tools

Route4Me’s best route planner enables you to add notes to routes which can serve as proof of delivery (POD) and proof of service. The Android and iOS route planner apps instantly sync data with the Web Platform. They enable you to increase the security of your operations and make POD files instantly available across devices connected to your account. Notes can contain delivery statuses, text, images, video, audio files, and other types of important data. You can export POD files and route notes, share the exported files with your team members, make reports, and conduct analyses or audits of your routing operations.

 

Routes List – Export Route Notes From Routes List

To export route notes from your Routes List, go to “Routes” and then “Routes” from the Navigation Menu. Then, click the Three-dot Icon next to the route that contains the notes and POD files you want to export. Next, hover over “Export” and select “Export Notes as CSV“. You can see all available export items and how to customize the export file further in this guide.

You can export proof of delivery files and route notes from the routes list for individual or multiple routes.

 

Additionally, the most reliable route management software enables you to can export notes from multiple routes simultaneously. To do so, select your preferred routes by checking the boxes next to them. Then, click “File” from the top menu bar, hover over “Export Routes“, and select “Export Notes as CSV“. You can see all available export items and how to customize the export file further in this guide.

You can export notes from multiple routes simultaneously on the Routes List by selecting them. To do so, check the boxes next to the preferred routes.

 

Routes Map – Export Route Note Data From Routes Map

To export route notes from the Routes Map, go to “Routes” and then “Routes Map” from the Navigation Menu. The “Notes” column shows which routes contain attached notes and the number of the attached notes, respectively. If the header in your “Routes Map” doesn’t have the “Notes” column, right-click the header and select “Notes” from the list. Then, click the gear icon next to the route that contains the notes you want to export, hover over “Export” and select “Export Notes as CSV“. You can see all available export items and how to customize the export file further in this guide.

Export route destination notes from the Routes Map. The Notes column shows which routes contain attached notes and the number of the attached notes, respectively.

 

Additionally, you can export notes from multiple routes simultaneously. To do so, select your preferred routes by checking the boxes next to them. Then, click “File” from the top menu bar, hover over “Download as“, and select “Export Notes as CSV“. You can see all available export items and how to customize the export file further in this guide.

You can export notes from multiple routes simultaneously on the Routes Map.

 

Route Editor – Export Route Notes From Route Editor

To export route notes from the Route Editor, go to “Routes” and then “Routes” from the Navigation Menu to open the Routes List. Then, click Open Icon next to the route that contains the notes you want to export to open it in the Route Editor.

Open routes from the Routes List to export route destination Notes on the Route Editor.

 

Any destinations with Notes have a corresponding Note Icon with a number under their address showing the number of notes attached to the respective destination. To export Notes on the Route Editor, click “File” from the top menu bar, hover over “Export Route“, and select “Export Notes as CSV” from the list.

Export route destination Notes from the Route Editor.

 

Detailed Notes Export – Customizable CSV Spreadsheets For Exporting Notes

After you select one of the above export methods, you can customize the Note export file to your preference. When exporting route Notes, the Export Route Data window allows you to customize the list of items that you want to include in the exported CSV file. Specifically, you can use the “Field Search” bar to find the items that you want to include in the exported file. In the “Notes” section, check the boxes next to the items you want to include in the export file. The added items are displayed in the right section of the window, where you can change their order, which will change the order of the columns in the exported CSV file, or remove them from your selected items.

You can customize the Note export file to your preference. When exporting route Notes, the Export Route Data window allows you to customize the list of items that you want to include in the exported CSV file.

 

You can refer to the glossary below for clarification of the terms in the exported files.

ItemDescription
 Note TypeThe type of the note attached to a stop (note status).
 Note ContentThe content of the note (custom text).
 Note Attachment URLURL of the file (image, video, etc.) that is attached to the note.
 Note TimeThe timestamp that was created upon adding the note to the stop.
 Note LatThe latitude coordinates of the location where the note was added to the stop.
 Note LngThe longitude coordinates of the location where the note was added to the stop.
Device TypeThe type of the device that was used for adding the Note to the stop (iPhone, Android, Web, etc.).
Route NotesThe content of all notes attached to a stop (custom text).

 

 

Was this article helpful?
Still can't find what you're looking for? Contact us
Route4Me

About Route4Me

Route4Me has over 40,000 customers globally. Route4Me's Android and iPhone mobile apps have been downloaded over 2 million times since 2009. Extremely easy-to-use, Route4Me's apps create optimized routes, synchronize routes to mobile devices, enable communication with drivers and customers, offer turn-by-turn directions, delivery confirmation, and more. Behind the scenes, Route4Me's operational optimization platform combines high-performance algorithms with data science, machine learning, and big data to plan, optimize, and analyze routes of almost any size in real-time.