Import Data – Plan Routes by Importing Data from the Cloud

For your convenience, the Route4Me easiest route optimization software enables you to effortlessly import route planning data from the most popular cloud-based storage services. Importing files containing delivery addresses and GPS coordinates from cloud-based storage services is a quick and easy route data import method that allows you to increase the efficiency and flexibility of your route optimization operations. You can import files from virtually any device and any location without having to rely on external hardware storage or inputting the data manually. Currently, the Route4Me Route Planner enables you to plan routes with cloud data files and supports data import from Google Drive, Dropbox, and Box.net.

To plan routes with cloud data files from a particular cloud-based storage service, first, go to Plan New Route from the Navigation Menu.

Next, select Import Data from the corresponding window.

After that, specify the preferred route parameters and then click on the corresponding button to proceed.

Next, select the preferred cloud-based storage service and then click on the Authorize button. Currently, Route4Me supports data import from Google Drive, Dropbox, and Box.net.

Then, follow further instructions of the selected cloud-based storage service respectively. After reading the terms of service and privacy policy, click on the corresponding button to allow the Route4Me route planning software to access the data on the selected cloud-based storage service.

After the authorization process, select the file that you want to import from the corresponding cloud-based storage service. Before importing a spreadsheet with route planning data, make sure that it corresponds to Route4Me’s spreadsheet guidelines and requirements. Currently, Route4Me supports CSV, XLS, and XLSX file formats.

Once you uploaded the spreadsheet with customers’ delivery addresses, Route4Me routing software processes the imported routing data and displays it in the corresponding window. For the route optimization system to process the data automatically, select the Auto (attempt detection) option respectively.

Alternatively, you can manually match column titles to the data contained in the corresponding columns.

Next, click Continue to Review.

In the Verify Addresses on Map window, you can view all imported and processed addresses on the map, as well as check their geocoding statuses. Green colored dots indicate that the corresponding shipping addresses were successfully geocoded with High Confidence. The delivery addresses that have yellow-colored dots next to them should be reviewed and fixed accordingly.

Geocoding is the process of giving/assigning latitude and longitude values/coordinates to street addresses for accurate location detection and GPS tracking.

To edit a particular address, first, click on it and then select Edit respectively.

After that, make the required modifications in the corresponding field and then click OK to apply the changes.

After reviewing the imported addresses, click Finish Import to plan the route.

Once the multi-stop route is planned, it is optimized and then opened in the Route Editor where you can modify it, as well as added to the Routes List with all your routes.