Export Routes – Download Route Data in CSV File

 

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 used for sharing with your team of delivery drivers, sales reps, field technicians, dispatchers, route planners, etc. Moreover, you can also use the exported data for making reports, conducting analysis or audits of your routing operations, and many other activities that can help you in growing and improving your business.

 

Exporting Route Data from Your Routes List

To export route data from your Routes List, first, go to Routes List from the navigation menu.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Next, click on the gear icon next to the optimized route that you want to export.

Detailed Route Data Export

 

After that, hover your cursor over Export, and then, select one of the provided options from the list. You can see the descriptions of all export items and how to customize the export file further in this tutorial.

Detailed Route Data Export

 

Exporting Multiple Routes’ Data from Your Routes List

To export multiple routes’ data from your Routes List:

  1. First, check the boxes next to the routes that you want to export;
  2. Next, click File in the toolbar, hover your cursor over Download as, and then, select one of the available options respectively.

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

Detailed Route Data Export

 

Exporting Route Data from the Routes Map

To export route data from the Routes Map, first, go to Routes Map from the navigation menu.

Detailed Route Data Export

 

Next, click on the gear icon next to the route that you want to export.

Detailed Route Data Export

 

After that, hover your cursor over Export, and then, select one of the provided options from the list. You can see the descriptions of all export routes items and how to customize the export file further in this tutorial.

Detailed Route Data Export

 

Exporting Multiple Routes’ Data from the Routes Map

To export multiple routes’ data from the Routes Map:

  1. First, check the boxes next to the routes that you want to export;
  2. Next, click File in the toolbar, hover your cursor over Download as, and then, select one of the available options respectively.

You can see the descriptions of all export routes items and how to customize the export file further in this tutorial.

Detailed Route Data Export

 

Exporting Route Data From the Route Editor

To export route data from the Route Editor, first, go to Routes List from the navigation menu.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Next, click on the route that you want to export to open it in the Route Editor.

Detailed Route Data Export

 

In the Route Editor, first, click File in the toolbar, hover your cursor over Download as, and then, select one of the provided file formats that you want to export.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

The descriptions of all available export formats are provided below:

  • Export CSV: Allows you to export routes as customizable CSV files;
  • Export Notes as CSV: Exports the route notes with the attached photos, videos, text, voice messages, etc.;
  • Export Minimal Without Addresses: Exports only the items from the Route, Time, Time Travel Details, Density, Driver, and User Notes sections of the full export file;
  • Export to TomTom: Exports an optimized route file with the route’s data that can be uploaded to TomTom devices and used for driving the exported route respectively;
  • Export to KML: Exports an optimized KML (Keyhole Markup Language) file that can be uploaded and used on the devices that support the corresponding format;
  • Export to 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;
  • Export to 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;
  • Export to Freshroute: Exports an optimized file that can be used on Freshroute;
  • Export to Navigon 5: Exports an optimized file with the route’s data that can be uploaded to the devices that support the Navigon 5 maps and used for driving the exported route respectively;
  • Export to Navigon 6: Exports 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;
  • Export to LMX: Exports an optimized file with the route’s data that can be uploaded to Nokia devices and used for driving the exported route respectively;
  • Export Tracking History as CSV: Exports the tracking history of the route as a CSV file.
  • Export Route Map Picture: Exports a high-resolution image of the route.

 

Customizing the Export File

Route4Me allows you to easily customize the export file for your convenience. To customize the export file, first, select the Export CSV option using one of the methods described earlier in this tutorial. Selecting the Export CSV option will open the Export Route Data window that allows you to customize the list of the items that you want to include in the export file.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Use the Field Search to find the items that you want to include in the export file.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Type the full or partial name of the item that you are looking for into the Field Search, and then, select the preferred item(s) from the search results.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Check the boxes next to the items that you want to include in the export file. The added items are displayed in the right section of the window.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

To export the items in a specific order, click on the three dots icon next to the item that you want to move and drag it to the preferred position on the list.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

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, first, check the boxes next to the items that you want to include in the export file, then, type the name of the template into the Export Profiles field and click Add. Once the Export Profile is added, it can be reused.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Finally, click Export to download the file with all selected items to your computer/device.

Export Routes and use them on other GPS Devices and Softwares with Route4Me - the Best Route Planner

 

Route Data Glossary

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

TermDescription
 Actual_Arrival_TimeThis is the time when a driver actually arrived at the stop/address. The Actual_Arrival_Time is calculated based on the most accurate data available, for example when the stop was marked as visited manually by a driver or when a driver entered and triggered the geofence around the stop/address and Route4Me automatically generated the Detected as Visited timestamp (M/D/YYYY HH:MM).
 Actual_Arrival_Time_Computation_MethodThe method used for computing the actual arrival time (based on Mark_as_Visited, Geofence_Entered, etc.).
 Actual_Departure_TimeThis is the time when a driver actually departed from the stop/address. The Actual_Departure_Time is calculated based on the most accurate data available, for example when the stop was marked as departed manually by a driver or when a driver exited and triggered the geofence around the stop/address and Route4Me automatically generated the Detected as Departed timestamp (M/D/YYYY HH:MM).
 Actual_Departure_Time_Computation_MethodThe method used for computing the actual departure time (based on Mark_as_Departed, Geofence_Departed, etc.).
 Actual_Distance_Computation_MethodThe method used for computing the actual traveled distance on the route (based on the Tracking Data, Estimated, etc.).
 Actual_Distance_From_Previous_StopThe actual distance traveled from the previous stop/address on the route to the given one.
 Actual_Distance_From_StartThe actual distance traveled from the start of the route to the given stop/address.
 Actual_Drive_Time_Computation_MethodThe method used for computing the actual driven time on the route (based on Mark_As_Visited_And_Departed, Geofence_Departed_And_Arrived, etc.).
 Actual_Running_DistanceThe actual distance traveled by a driver by the time of reaching the given stop/address on the route.
 Actual_Running_Drive_TimeThe actual time that has been driven by a driver by the time of reaching the given stop/address on the route.
 Actual_Running_Service_TimeThe actual time spent by a driver on servicing previous stops on the route by the time of reaching the given stop/address.
 Actual_Service_TimeThe actual time spent on servicing the given stop/address.
 Actual_Service_Time_Computation_MethodThe method used for computing the actual service time of the stop/address on the route (based on Mark_As_Visited_And_Departed, Geofence_Departed_And_Arrived, etc.).
 Actual_Time_From_Previous_StopThe actual time traveled from the previous stop on the route to the given one.
 Actual_Time_From_StartThe actual time traveled from the start of the route to the given stop/address.
 AddressInformation used for describing the location of a stop or destination. Normally an address should contain the following identifiers: street name and number, city, state, country, and zip code. An Address may also be referred to as a Stop or Destination.
 Address_LatitudeThe latitude coordinates (decimal form, rooftop) of the stop/address.
 Address_LongitudeThe longitude coordinates (decimal form, rooftop) of the stop/address.
 AddressBook_Last_DepartedThe time when the given address from the Address Book was last marked or detected as departed.
 AddressBook_Last_VisitedThe time when the given stop/address from the Address Book was last marked or detected as visited.
 Address_TypeThe type of the stop/address: Pickup, Delivery, Break, Meetup, Visit, Service or Drive-By.
 AliasAlias (name) assigned to the stop/address.
 CostThe total cost of servicing the stop/address.
 CubeThe total cubical volume that is picked up or dropped off at the stop/address.
 Curbside_LatitudeThe stop’s latitude coordinates (decimal form, curbside).
 Curbside_LongitudeThe stop’s longitude coordinates (decimal form, curbside).
 Customer_POThe purchase order of the customer that is associated with the given stop/address.
 DepartedBinary column indicating whether the address was marked as departed (displays 1 if departed).
 Departed_LatitudeLatitude coordinates of the location where the stop/address was marked or detected as departed.
 Departed_LongitudeLongitude coordinates of the location where the stop/address was marked or detected as departed.
 Device_TypeThe type of device that was used for sending and receiving GPS signal and other data from Route4Me’s servers (iPhone, Android, etc.).
 Distance_to_NextTotal distance from the given stop/address to the next one on the route.
 Drive_Time_to_NextTotal travel time from the given stop/address to the next one on the route (HH:MM:SS).
 First_NameFirst name of the contact person at the receiving stop/address.
 Fuel_Cost_From_StartThe total cost of the consumed fuel used for getting to the given stop/address on the route.
 Fuel_From_StartThe amount of fuel (in gallons) consumed for getting to the given stop/address on the route.
 Geofence_Departed_TimeThe automatically created Detected as Departed timestamp that was generated upon departing from the geofenced area of the stop/address after staying in it for a predefined period of time.
 Geofence_Time_On_SiteThe total time spent by a driver inside the geofenced area of the stop/address.
 Geofence_Visited_TimeThe automatically created Detected as Visited timestamp that was generated upon entering a geofenced area of the stop/address and staying in it for a predefined period of time.
 GroupThe name of the group that is associated with the stop/address.
 Invoice_NoThe invoice number associated with the stop/address.
 Last_NameLast name of the contact person at the receiving stop/address.
 Marked_Arrival_TimeThe timestamp that was created when a driver manually marked the stop/address as Visited.
 Marked_Departure_TimeThe timestamp that was created when a driver manually marked the stop/address as Departed.
 Marked_Stop_TimeThe time that a driver spent on site of the given stop/address and marked it respectively.
 Member_EmailThe email address of the member assigned to the route.
 Member_First_NameFirst name of the member assigned to the route.
 Member_ID Identification number of the member assigned to the route.
 Member_Last_NameLast name of the member assigned to the route.
 Note_Attachment_URLURL of the file that is attached to the note of the stop/address. 
 Note_ContentThe content of the note attached to the stop/address (custom text).
 Note_LatThe latitude coordinates received by Route4Me’s servers upon adding the note to the stop/address.
 Note_LngThe longitude coordinates received by Route4Me’s servers upon adding the note to the stop/address.
 Note_TimeThe timestamp that was created upon adding the note to the stop/address.
 Note_TypeThe type of note attached to the stop/address (note status).
 Optimized_Time_Window_EndTime window end after applying time constraint relaxation.
 Optimized_Time_Window_StartTime window start after applying time constraint relaxation.
 Order_NoThe number of the order associated with the stop/address.
 PhoneThe phone number of the contact person associated with the stop/address. 
 PiecesThe number of pieces to be delivered or picked up from the stop/address.
 PriorityThe priority of the stop/address on the route (1 – highest priority; 255 – lowest priority).
 Predicted_Arrival_TimeWhen a driver arrives at the stop/address a little early or a little later, the Predicted_Arrival_Time of all remaining stops on the route will be affected. The Predicted_Arrival_Time constantly changes to accurately reflect when a driver will arrive at stops/addresses later on the route. 
 Predicted_Departure_TimeWhen a driver arrives at the stop/address a little early or a little later, the Predicted_Departure_Time of all remaining stops on the route will be affected. The Predicted_Departure_Time constantly changes to accurately reflect when a driver will depart to the next stop/address on the route.
 Reference_NoThe reference number of the stop/address on the route.
 Remaining_CubePositive Remaining_Cube values indicate the occupied space on a vehicle when negative values indicate the reserved/free space on a vehicle upon reaching the stop/address.
 Remaining_PiecesPositive Remaining_Pieces values indicate the occupied space on a vehicle when negative values indicate the reserved/free space on a vehicle upon reaching the stop/address.
 Remaining_WeightPositive Remaining_Weight values indicate the occupied space on a vehicle when negative values indicate the reserved/free space on a vehicle upon reaching the stop/address.
 RevenueThe revenue generated from the stop/address.
 Route_Addresses_CountNumber of stops/addresses on the route (excluding the departure address).
 Route_ID The unique internal identification number of the route.
 Route_NameThe name assigned to the route.
Route_NoThe route number (relevant for multi-route exports).
 Route_NotesAll notes that are attached to the route.
 Route_Planned_TimeThe total estimated time required for completing the route.
 Route_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_TimeThe total estimated time required for servicing all stops on the route.
 Route_Start_TimeThe time when the route started.
 Route_Total_DistanceThe total distance traveled on the route.
 Route_Wait_TimeThe total 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.).
 Running_DistanceThe total distance traveled by a driver upon reaching the given stop/address on the route.
 Running_Service_TimeThe total time spent by a driver on servicing previous stops/addresses on the route upon reaching the given stop/address.
 Running_Travel_TimeThe total time traveled by a driver upon reaching the given stop/address on the route.
Planned_Arrival_TimeThis is the estimated arrival time when a driver will arrive at the stop/address. The arrival time is calculated based on the route start time, the travel time to the next stop, the wait time (if applicable) to the next stop, and the service time at each stop.
Planned_Departure_TimeThis is the estimated departure time when the driver will depart from the stop/address. The departure time is calculated based on the route start time, the travel time to the next stop, the wait time (if applicable) to the next stop, and the service time at each stop.
 Scheduled_ForThe scheduled time and date of the route’s start.
Sequence_NoThe sequence number of the stop/address on the route.
 Service_TimeThe expected amount of time required for servicing the corresponding stop/address (integer minutes or HH:MM:SS).
 SPORHThe estimated number of stops visited per on-road hour.
 Stem_In_TimeThe time spent on getting from the depot to the first stop on the route. 
 Stem_Out_TimeThe time spent on getting to the depot after visiting the last stop on the route.
 Time_ImpactThe time impact that the earliness or tardiness of a driver had on the stop/address (expressed in minutes).
 Time_Window_EndThe estimated end time of the first time window of the stop/address (HH:MM:SS, military time).
 Time_Window_End_2The estimated end time of the second time window of the stop/address (HH:MM:SS, military time).
 Time_Window_Start The estimated beginning time of the first time window of the stop/address (HH:MM:SS, military time).
 Time_Window_Start_2The estimated beginning time of the second time window of the stop/address (HH:MM:SS, military time).
 TPORHThe estimated amount of transactions per on-road hour.
 Vehicle_AliasThe alias/name of the vehicle associated with the route.
 Vehicle_ID The unique identification number of the vehicle associated with the route.
 Visited_LatitudeLatitude coordinates of the location where the address was marked as visited.
 Visited_LongitudeLongitude coordinates of the location where the address was marked as visited.
 Wait_Time_From_StartThe time of the driver’s inactivity from the start of the route. 
 WeightTotal weight capacity of a vehicle upon visiting a stop/address. Positive Weight values indicate the amount of loaded weight on the vehicle when negative weight values indicated the total reserved weight capacity on the vehicle.

 

 

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

About Route4Me

Route4Me has over 35,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.

Leave Your Comment or Question

Your email address and phone number will not be published.