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

The Route4Me Android app is designed to make your routing operations and logistics transactions as fast and flexible as possible, allowing you to plan, optimize, and navigate routes of any complexity on the go. In addition to geocoding partial or incorrect addresses when adding them manually, Route4Me’s Android app also allows you to import spreadsheets with hundreds of thousands of addresses from the local storage on your Android device, as well as third-party cloud-based storage services. 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 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. To learn more about specifying the route parameters and adjusting the optimization settings, visit this page.

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 learn more about Route4Me spreadsheet requirements, visit this page.
To learn more about how many addresses you can import in a single upload, visit this page

 

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

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

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.

 

To learn more about the Route4Me spreadsheet requirements, visit this page. 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