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.

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 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 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.

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.

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.

Navigate Uploaded Route and Collect Proof of Delivery

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.