Import Spreadsheets with Addresses – Android Route Planner

The Route4Me Android route planner app is designed to make your route planning operations and logistics transactions as fast and flexible as possible, allowing you to plan, optimize, and navigate routes with multiple destinations of any complexity on the go. In addition to geocoding partial or incorrect addresses when adding them manually, Route4Me’s Android route planner app also allows you to import addresses individually, one by one, or import addresses in bulk through spreadsheets with hundreds of thousands of addresses from the local storage on your Android device, as well as third-party cloud-based storage services. With the Route4Me Android route planning app, you can leverage route planning with spreadsheets imported from your Android device, Google Drive, Dropbox, etc. Thus, you can effortlessly accommodate the particular routing and logistics needs of your business or unique business model using only your Android device without having to rely on stationary computers or adding numerous addresses manually.

 

To start route planning with spreadsheets stored on your device and upload a spreadsheet with addresses from the local storage on your Android device or the preferred cloud-based storage service and use the imported data for planning a new route, first, go to My Routes from the navigation menu and then tap on the Add Route button.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

 

After that, specify the preferred route parameters and optimization settings and then tap on the checkmark icon to finish and proceed to add addresses to the route.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

 

Next, tap on the Add Destination button to add addresses/stops to the route.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

 

After that, go to the Import tab from where you can upload route data spreadsheets into the app. To upload a route data file from the local storage on your Android device into the app, first, tap on the Upload CSV or XLS File button. Next, navigate through the local storage on your Android device to locate the spreadsheet that you want to import and then tap on the preferred file to upload it into the app. Once the spreadsheet is uploaded, all valid addresses are automatically geocoded and displayed in the Found tab accordingly.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

NOTE: The import spreadsheet must be in the CSV or XLS file format.

 

To kick off route planning with spreadsheets and upload a route data file from your Google Drive into the app, first, tap on the Import Addresses from Google Drive button. Next, sign into your Google Drive and navigate through the folders on your Google Drive to locate the spreadsheet that you want to import and then tap on the preferred file to upload it into the app. Once the spreadsheet is uploaded, all valid addresses are automatically geocoded and displayed in the Found tab accordingly.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

To import route data files from your Google Drive into the Route4Me Android app, make sure that the Google Drive app is installed on your Android device.

 

To upload a route data file from your Dropbox account into the app, first, tap on the Import Addresses from Dropbox button. Next, sign into your Dropbox account and navigate through the folders on your Dropbox account to locate the spreadsheet that you want to import and then tap on the preferred file to upload it into the app. Once the spreadsheet is uploaded, all valid addresses are automatically geocoded and displayed in the Found tab accordingly.

Importing Spreadsheets with Addresses from Your Android Device, Google Drive, and Dropbox for Planning Routes

To import route data files from your Dropbox account into the Route4Me Android app, make sure that the Dropbox app is installed on your Android device.

 

For your convenience, you can also download a sample route data file in the Import tab. To do so, tap on the Download Example Route Template button accordingly.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

 

After importing addresses into the app and adding them to the route, tap on the Optimize button to optimize the route and apply the predefined optimization settings for the most efficient sequence of stops. Once the route is optimized, it is automatically synchronized with the servers and the Unsynced and Synced icons next to the route’s stops will indicate so accordingly.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

 

Route4Me provides near real-time data synchronization across all associated computer and mobile devices so that all routes that are planned using the Route4Me iOS and Android mobile apps can be automatically synchronized with the Route4Me Web Platform in a matter of seconds and vice versa.

Uploading Files from Your Android Device, Google Drive, and Dropbox for Planning Routes (Android Devices)

 

 

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