Import Data

The “Import Data” feature is a functional alternative to uploading a spreadsheet file from your computer, and it allows you to import your addresses from one of the supported cloud storage services: Google Drive, Dropbox, and Box.net. The feature also supports imports from Xero and Quickbooks.

 

After selecting the “Copy-and-Paste” option on the home screen, set the routing parameters as described in our tutorial on “Setting the Route Parameters,” then click “Create Route and Proceed to Add Addresses.”

Create an optimized route by importing data using Route4Me

Before importing the data, make sure you have it in a formatted spreadsheet, as described in our “Uploading a File” section.

Next, follow the steps below. These steps apply to Google Drive, Dropbox, and Box.net file imports.

 

Importing Data from Google Drive

Click on the “Google Drive” tab.

Create optimized routes by importing data using Route4Me

 

Click the “Authorize” button to log in to the selected service.

Create optimized routes by importing data using Route4Me

 

Select the file you want to use for the import.

Create an optimized route by importing data using Route4Me

 

Importing Data from Box.com

Click on the “Box.net” tab.

Create optimized routes by importing data using Route4Me

 

Enter your Box.com credentials, then click “Authorize.”

Create optimized routes by importing data using Route4Me

 

Click “Grant access to Box.”

Create optimized routes by importing data using Route4Me

 

Select the route spreadsheet that you want to import.

Create an optimized route by importing data using Route4Me

 

Importing Data from Dropbox

Click on the “Dropbox” tab.

Create optimized routes by importing data using Route4Me

 

Enter your Dropbox credentials, then click “Sign In.”

Create optimized routes by importing data using Route4Me

 

Select the route spreadsheet that you want to import.

Create an optimized route by importing data using Route4Me

 

After performing these actions, click the “Import Selected,” and you will see a preview of the file you uploaded.

Create an optimized route by importing data using Route4Me

 

Click on the header of any of the columns and select a new option if you need to make any changes to how the information is mapped to the system.

Create an optimized route by importing data using Route4Me

 

Click “Continue” to proceed to the final review screen.

Create an optimized route by importing data using Route4Me

Click “Continue to Review” to verify the addresses on Map.

Route4Me uses geocoding to get latitude and longitude coordinates for each address. Geocoding will be more accurate for complete and properly written addresses.

After the geocoding is done, the software will display a dot next to each address. If the dot is green, that means the address is geocoded with high confidence. A yellow dot indicates that there was a small problem and the software wasn’t able to identify that precise address but found something similar which might be correct. A red dot means that the address couldn’t be geocoded. In this case, you have to either remove it from the list or edit it.

Route4Me, GPS tracking software, uses geocoding to get the latitude and longitude coordinates for each address

 

To edit an address, roll your mouse cursor over it and click on “Edit.”

Route4Me, GPS tracking software, uses geocoding to get the latitude and longitude coordinates for each address

 

You will be able to enter the new address and click “OK” when you’re done.

Route4Me, GPS tracking software, uses geocoding to get the latitude and longitude coordinates for each address

 

On the right side of the window, you will see the address map. If you need to, you can use it to fine-tune each address, simply by dragging the pin with the number for the corresponding address and dropping it to the new location.

As map route planner, Route4Me allows you to see addresses on a map

 

Rolling your mouse cursor over a destination will bring up detailed information about it, including the data from custom columns.

As map route planner, Route4Me allows you to see addresses on a map

 

You can also remove an address by right-clicking on its pin, then select “Delete.”

As map route planner, Route4Me allows you to see addresses on a map

When you’re done, click on “Finish Import.” At this point, your route will begin to optimize. The process might take anywhere from a few seconds to a few minutes, depending on the number of stops on your route.

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