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 for making reports, data analysis, audits of your routing operations, and many other activities that can help you grow and improve your 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.

 

 

Exporting Route Data With Route4Me Route Management Tools

Route4Me’s Route Planning and Optimization 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 – Exporting 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 – Exporting 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 – Exporting Routes From Route Editor

To export route data from the Route Editor, go to “Routes” and then “Routes” from the Navigation Menu. 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.     

 

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.

 

Route4Me allows you to easily customize the exported file for your convenience. To customize the exported file, first 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
Route IDRoute_IdThe unique internal identification number of the route.
Route NameRoute_NameThe name assigned to the route.
Route Numberroute_noThe 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 Addresses CountRoute_Addresses_CountNumber of stops or addresses 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 estimated time required for servicing all stops on the route.
Scheduled forScheduled_ForThe scheduled time and date when the route will start.
Destination StatusStop_StatusThe last stop status that was set or updated for the route stop or address.
Destination Status Time UTCStop_Status_Time_UTCThe time in UTC when the respective stop status was set or updated for the stop or address.
Destination Status TimeStop_Status_TimeThe time when the respective stop status was set or updated for the stop or address in the time format of the main Route4Me account.
Address
Destination IDDestination_IDUnique internal identification number of the stop or address.
AliasAliasСustom alias or name of the route stop (address). You can assign aliases to route stops (addresses) for faster and easier route searches or other operating requirements.
AddressAddressInformation used for describing the location of a stop or 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.
Address TypeAddress TypeThe type of the stop or address from the available address types. Specifically, Pickup, Delivery, Break, Meetup, Service or Visit.
Address LatitudeAddress_latitudeLatitude of the stop or address in decimal form at the rooftop of the location.
Address LongitudeAddress_longitudeLongitude of the stop or address in decimal form at the rooftop of the location.
Curbside Latitude (Curbside Stop Latitude)Curbside_latitudeCurbside stop’s latitude in decimal value.
Curbside LongitudeCurbside_longitudeCurbside stop’s longitude in decimal value.
Customer
GroupGroupCustom ID of the Address Book Group associated with the route stop (address).
Customer PO (Customer Purchase Order)Customer POPurchase order (PO) of the contact or customer associated with the route stop (address).
First NameFirst_NameFirst name of the expected contact person at the receiving stop or address.
Last NameLast_NameLast name of the expected contact person at the receiving stop or address.
EmailEmailEmail address of the contact person for the receiving route stop or address.
PhonePhonePhone number of the contact person for the receiving route stop or address.
Order
PriorityPriorityVisitation priority of the route stop. The highest stop priority is 1, and the lowest stop priority is 999999. Accordingly, route stops (addresses) with higher priority are visited earlier on the route.
Invoice NumberInvoice_NoCustom number of the invoice associated with the stop or address.
Reference NumberReference_NoCustom reference number of the stop or address on the route. Useful for identifying individual stops.
Order NumberOrder_NoThe number of the order associated with the stop or address.
WeightWeightTotal weight capacity of a vehicle upon visiting a stop or address. 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 stop or address.
RevenueRevenueRevenue generated from servicing the stop or address.
CubeCubeTotal cubical volume that is picked up or dropped off at the stop or address.
PiecesPiecesTotal number of pieces or deliveries that are picked up or dropped off at the stop or address.
Tracking NumberTracking_NumberTracking number associated with the stop, address, or respective delivery.
Time
Service TimeService_TimeService Time (integer minutes or HH:MM:SS) required to service the route stop or address.
Time Window StartTime_Window_StartStart time of the Time Window (working hours) when the route stop 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 EndTime_Window_EndEnd time of the Time Window (working hours) when the route stop can be visited and serviced (Day 1, + HH:MM:SS or military time. For example: “Day 1, 5:00 PM”).
Time Window Start 2Time_Window_Start_2Start time of the Second Time Window (working hours) when the route stop can be visited and serviced (Day 2, + HH:MM:SS or military time. For example: “Day 2, 9:00 AM”).
Time Window End 2Time_Window_End_2End time of the Second Time Window (working hours) when the route stop can be visited and serviced (Day 2, + HH:MM:SS or military time. For example: “Day 2, 5:00 PM”).
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_TimeEstimated arrival time when a driver will arrive at the stop or 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 TimePlanned_Departure_TimeEstimated departure time when the driver will depart from the stop or 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.
Predicted Arrival TimePredicted_Arrival_TimeWhen a driver arrives at the stop or address earlier or later, the Predicted_Arrival_Time of all remaining stops on the route will be affected.
Predicted Departure TimePredicted_Departure_TimeWhen a driver departs from the stop or address earlier or 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 or address on the route.
Time Impact (Driver Time Impact)Time_ImpactTime impact (expressed in minutes) that the earliness or tardiness of a driver had on the stop or address.
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.
Stem In Time (Time to First Stop)Stem_In_TimeTime spent getting from the depot to the first stop on the route.
Stem Out Time (Time from Final Stop)Stem_Out_TimeTime spent getting from the last stop on the route back to the depot.
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 that was created when a driver manually marked the stop or address as Visited.
Marked Departure TimeMarked_Departure_TimeTimestamp that was created when a driver manually marked the stop or address as Departed.
Marked Destination TimeMarked_Destination_TimeTime that a driver spent on-site at the given stop or address and marked so respectively.
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 coordinates of the location where the stop or address was marked or detected as departed.
Departed LongitudeDeparted_longitudeLongitude coordinates of the location where the stop or address was marked or detected as departed.
Geofence Visited TimeGeofence_Visited_TimeThe automatically created Detected as Visited timestamp that was generated upon entering the geofenced area of the stop or address after staying in it for a predefined period of time.
Geofence Departed TimeGeofence_Departed_TimeThe automatically created Detected as Departed timestamp that was generated upon departing from the geofenced area of the stop or address after staying in it for a predefined period of time.
Geofence Time on SiteGeofence_Time_On_SiteTotal time spent by a driver inside the geofenced area of the stop or address.
Distance
Distance to NextDistance_to_NextTotal distance from the given stop or address to the next one on the route.
Time Travel Details
Drive Time to NextDrive_Time_to_NextEstimated drive time from the given stop or address to the next one on the route.
Running Service TimeRunning_Service_TimeTotal time spent by a driver on servicing previous stops or addresses on the route upon reaching the given stop or address.
Running Travel TimeRunning_Travel_TimeTotal time traveled by a driver upon reaching the given stop or address on the route.
Running Wait TimeRunning_Wait_TimeTotal amount of inactive time spent by a driver upon reaching the given stop or address 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.).
Distance Travel Details
Running DistanceRunning_DistanceTotal distance traveled by a driver upon reaching the given stop or address on the route.
Fuel
Fuel from StartFuel_From_StartAmount of fuel (in gallons) consumed for getting to the given stop or address on the route.
Fuel Cost from StartFuel_Cost_From_StartTotal cost of the consumed fuel used for getting to the given stop or address on the route.
Operations
Remaining WeightRemaining_WeightA positive Remaining_Weight value indicates the occupied space on a vehicle, while negative values indicate the reserved or free space on a vehicle upon reaching the stop or address measured in weight.
Remaining PiecesRemaining_PiecesA positive Remaining_Pieces value indicates the occupied space on a vehicle, while negative values indicate the reserved or free space on a vehicle upon reaching the stop or address measured in pieces
Remaining CubeRemaining_CubeA positive Remaining_Cube value indicates the occupied space on a vehicle, while negative values indicate the reserved or free space on a vehicle upon reaching the stop or address measured as cubic space.
Notes
Note Type (Note Status)Note_TypeThe type of note (note status) attached to the stop or address.
Note Content (Note Text)Note_ContentThe content (custom text) of the note attached to the stop or address.
Note Attachment URLNote_Attachment_URLWeb address URL of the file that is attached to the note of the stop or address.
Note TimeNote_TimeTimestamp that was created upon adding the note to the stop or address.
Note LatitudeNote_LatLatitude coordinates received by Route4Me’s servers upon adding the note to the stop or address.
Note LongitudeNote_LngLongitude coordinates received by Route4Me’s servers upon adding the note to the stop or address.
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_NotesAll custom text notes added to each stop, separated by vertical lines. If Note_Content is selected, it will show separate addresses and the text of each address next to it.
Actual Visit Details
Actual Arrival Time ComputationActual_Arrival_Time_ComputationTBD
Actual Departure Time ComputationActual_Departure_Time_ComputationTBD
Actual Arrival TimeActual_Arrival_TimeTime when a driver actually arrived at the stop or 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 or address and Route4Me automatically generated the Detected as Visited timestamp (M/D/YYYY HH:MM).
Actual Departure TimeActual_Departure_TimeTime when a driver actually departed from the stop or 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 or address and Route4Me automatically generated the Detected as Departed timestamp (M/D/YYYY HH:MM).
Expected Actual Distance from Previous DestinationExpected_Actual_Distance_From_Previous_DestinationExpected actual distance traveled from the previous stop or address on the route to the respective one.
Expected Actual Time from Previous DestinationExpected_Actual_Time_From_Previous_DestinationExpected actual time traveled from the previous stop or address 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 stop or address 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 stop or address on the route.
Expected Actual Running Service TimeExpected_Actual_Running_Service_TimeActual time spent by a driver on servicing previous stops on the route by the time of reaching the given stop or address.
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 stop or address on the route (based on Mark_As_Visited_And_Departed, Geofence_Departed_And_Arrived, etc.).
Expected Actual Time from StartExpected_Actual_Time_From_StartExpected actual time traveled from the start of the route to the given stop or address.
Expected Actual Distance from StartExpected_Actual_Distance_From_StartExpected actual distance traveled from the start of the route to the given stop or address.
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.
Custom
Custom Datayour_custom_dataCustom Data added to the stop or address will appear as a new column with the respective header and data contained in the column.
Density
SPORH (Stops Per On-Road Hour)SPORHEstimated number of stops visited per hour spent driving on the route. If the route is completed, this will reflect the actual average value instead of an estimated value.
TPORH (Transactions Per On-Road Hour)TPORHEstimated amount of transactions per hour spent driving on the route. If the route is completed, this will reflect the actual average value instead of an estimated value.
Driver
Vehicle IDVehicle_IdUnique identification number of the vehicle associated with the route.
Vehicle Alias (Vehicle Name)Vehicle_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 Route4Me 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 that support the Navigon 5 maps and used for driving the exported route, respectively.
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.

 

 

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.