Upload Routes as CSV & XLSX Files – iPhone Route Planner App

With Route4Me’s iOS Route Planner app, planning delivery routes on the go is extremely easy and fast. Our app supports multiple options for adding and importing route addresses and customer locations. Namely, you can use the OCR address scanner, upload route as a CSV or XLSX file, pick addresses right from the map, and more.

For example, to plan a route with hundreds of locations right on your smartphone, you can upload a spreadsheet with addresses from your device. The route planner will automatically geocode and validate each uploaded address and then sequence all the locations in the most efficient and optimal order. Once you’ve optimized the route, you can start route navigation, collect electronic proof of delivery, etc.

Additionally, you can import route addresses into the route planner app from such cloud storage apps as Google Drive, OneDrive, Dropbox, and more.

Learn how to upload route spreadsheets in CSV or XLSX on the Android Route Planner app.



Plan Delivery Route on Route Planner for iPhone and iPad

First, go to “Routes” from the navigation menu at the bottom and then tap on the “Add New Route” button. Next, specify route optimization settings, schedule your delivery route using the calendar, and select the travel mode for driving, walking, or biking. After that, tap on the “Continue” button to save the route settings. Then, tap on the “Set Your Departure Address” button to add route addresses.

Plan a delivery route from a CSV or XLSX file on the iOS route planner app for iPhone or iPad.


Upload Route as CSV or XLSX File into Route Planner App

Next, select the “Upload CSV or XLS File” option for importing route addresses into the route planner app. After that, tap “Browse” in the bottom right corner and then select the preferred address import method. NOTE: The route planner app supports route upload in the CSV or XLSX (XLS) file formats only.

Upload CSV or XLS route files from your iPhone into the iOS route planner app.


Upload Route Addresses File from iCloud into Route Planner

Next, to import a route file from your iCloud account, select “iCloud Drive” and then navigate to the folder with the route file that you want to upload.

Upload CSV or XLS files with route addresses from iCloud to your iPhone route planner app.


Upload Route Files from Google Drive, Dropbox, OneDrive

Additionally, you can import addresses from such cloud storage apps as Google Drive, OneDrive, Dropbox, and more. To do so, go to “Browse” when uploading a file, select “More Locations” to open the list of additional locations. The route planner app will automatically detect all available cloud storage apps on your device and suggest them for selection.

Upload route addresses into route planner from cloud storage like Google Drive, Dropbox, OneDrive.


Geocode Addresses and Validate Customer Locations

Next, the app will automatically geocode the addresses and verify the locations from the uploaded spreadsheet. By default, the app imports addresses and aliases only. Learn more about Route4Me’s spreadsheet requirements. On the “Uploaded Addresses” screen, you can view and manage all imported addresses that have the following statuses:

  • Valid addresses: successfully geocoded and validated addresses that you can include into the route.
  • Review addresses: successfully geocoded and validated addresses that may have multiple options and should be reviewed before including them into the route.
  • Invalid addresses: not recognized and invalid addresses.

To review a valid address, tap on the given address and then select the preferred address option. To review an invalid location, tap on the respective location and then edit its address until it’s geocoded and validated.

Geocode addresses and validate customer locations from the uploaded CSV file on route planner app.


Add Route Destinations and Optimize Multi-Stop Route

Next, tap on the “Done” button to add all imported addresses to the route. Then, tap on the “Plan Route” button to optimize all added addresses and locations based on the specified optimization settings. After that, the app will automatically sequence all the route destinations in the most optimal order, prepare driving directions, schedule the delivery route start, etc.

Upload route as CSV or XLSX file and optimize uploaded addresses on iOS route planner app.


Finally, you can start and navigate the planned route in real-time, mark route stops as Arrived and Done, collect and attach proof of delivery to route stops, and more. Specifically, tap on the “Start Route” button to start the route on the iOS Route Planner app. After that, you can tap on the “Navigation” button next to the preferred route destination to enable route navigation with voice and navigate the route in real-time.

Furthermore, you can track and record route progress and confirm deliveries or visits using route stop statuses. Namely, tap on the “Arrived” button when you’ve arrived at the customer’s location. Then, tap on the “Done” button once you’ve completed the delivery or service. Additionally, you can set the Arrived, Skipped, and Failed statuses to route destinations. To do so, tap on the “Arrived” button next to a route stop, tap on the “Set Status” button, and then select the preferred status.

Navigate the planned route and collect electronic proof of delivery on iPhone route planner app.



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

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.