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.
Table of Contents
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.
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.
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.
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.
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.
Navigate Uploaded Route and Collect POD on Route Planner
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.
Visit Route4Me's Marketplace to Check out Associated Modules:
- Route Optimization
Commercial Vehicle & Truck Routing