Upload Route Spreadsheet in CSV or XLSX – Android Route Planner

With Route4Me’s Android Route Planner app, planning optimized delivery routes with multiple locations is extremely easy. Our route planner app provides multiple options for importing and adding addresses to your routes. For example, you can add route locations with the OCR address scanner, upload route spreadsheet, drag and drop addresses on the map, etc. The route file upload option enables you to plan multi-stop routes with hundreds of addresses on the go, using only your smartphone or tablet.

Specifically, all you need to do is upload a route spreadsheet in the CSV or XLSX file format from your device or Google Drive into the route planner. The app will automatically geocode all the locations from the file and validate the addresses. Next, simply tap on the “Optimize” button, and the route planner will sequence all the uploaded addresses in the most optimal order. You can then start the optimized route, navigate the route in real-time, collect electronic proof of delivery, and more.

Learn how to upload route files in CSV or XLSX on the iOS Route Planner app for iPhone and iPad.

 

 

Plan a New Delivery Route on Android Route Planner App

First, go to “My Routes” from the navigation menu and then tap on the “Add Route” button. After that, adjust the route optimization settings, schedule the delivery route, and select the preferred travel mode for driving, walking, or biking. Then, tap on the “Continue” button to save the route settings and proceed to add route destinations.

Plan and schedule a delivery route on the mobile route planner app for Android smartphones.

 

Upload Route Spreadsheet in CSV or XLSX into Route Planner

Next, tap on the “Set Your Departure Address” button to add route addresses and locations. Then, go to the “Import” tab and then tap on the “Upload CSV or XLS File” button.

Upload route spreadsheet into the route planner app to map multiple locations for delivery.

 

After that, you can upload route spreadsheet files from your Android smartphone or tablet using the “Recents” option(s). Additionally, you can upload route files from Google Drive. Specifically, select the preferred Google account and then navigate through the folders in the respective Google Drive to locate and select the file you want to upload.

NOTE: The Android Route Planner app supports route spreadsheets in the CSV or XLSX (XLS) file formats only.

Upload route spreadsheet as CSV or XLSX file from Google Drive into route planner app for Android.

 

Geocode Addresses and Validate Locations for Delivery

Once you’ve uploaded the spreadsheet, the app will automatically geocode the addresses and verify the locations in the file. By default, Route4Me imports addresses and aliases only. Learn more about Route4Me’s spreadsheet requirements. Next, you can view and manage all the imported addresses that have the following statuses:

  • Found: geocoded and successfully validated addresses that can be added to the route.
  • Review: geocoded and successfully validated addresses that may have multiple options and should be reviewed before adding them to the route.
  • Not Found: not recognized and invalid addresses.

To review and validate an address, tap on this address and then select the preferred address variant. To remove an invalid address, tap on the trash icon next to this address. Additionally, if you want to replace an invalid address, you can remove it and then add it manually.

Geocode locations and validate addresses from uploaded route spreadsheet on route planner app.

 

Upload Route Spreadsheet Addresses and Optimize Multi-Stop Route

Next, tap on the “Save & Close” button to save and add all the imported addresses to the route. After that, tap on the “Optimize” button to optimize the added addresses and locations based on the previously adjusted optimization settings. Then, the app will automatically sequence route stops in the most efficient order, schedule delivery route start, generate optimal driving directions, etc.

Optimize uploaded route spreadsheet addresses to plan a delivery route on route planner app.

 

Finally, you can start and navigate the optimized multi-stop route, collect electronic proof of delivery, mark route destinations as Arrived and Done, etc. First, to start the scheduled route on your Android Route Planner app, tap on the “Start Route” button. Next, tap on the “Navigation” button next to a route stop to start in-app voice-guided navigation or navigate the route with Google Maps, Uber, WAZE, and other apps.

Moreover, our route planner app enables you to track delivery route progress and confirm deliveries or visits using route destination statuses. Specifically, tap on the “Arrived” button when you arrive at a customer’s location. After that, tap on the “Done” button after you complete the respective delivery or service. Additionally, the app also supports the Arrived, Skipped, and Failed route stop statuses.

Navigate optimized delivery route with multiple locations and collect POD on route planner.

 

 

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

About Route4Me

Route4Me has over 34,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 a Reply

Your email address will not be published. Required fields are marked *