Upload a File – Planning Routes by Uploading Spreadsheets

With Route4Me you have multiple options for importing route data when planning your routes. Uploading spreadsheets with routing information enables you to effortlessly import numerous addresses, contacts, coordinates, as well as relevant custom data into the system in a matter of seconds. Once you upload a spreadsheet, Route4Me takes care of all computing and geocoding processes and uses the results for delivering the most efficient optimized routes.

 

To plan a new route by uploading a file/spreadsheet, first, go to “Plan New Route” from the navigation menu.

Upload a File - Planning Routes by Spreadsheets

 

Next, select “Upload a File” from the corresponding window.

Upload a File - Planning Routes by Spreadsheets

 

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

Upload a File - Planning Routes by Spreadsheets

 

Then, either drag and drop the file/spreadsheet into the corresponding window or click “Browse File to Upload” and then upload the file from your device. Currently, Route4Me supports CSVXLS, and XLSX upload file formats. For the most accurate results, it is recommended to use CSV file format spreadsheets.

Upload a File - Planning Routes by Spreadsheets

 

Once you uploaded the spreadsheet, Route4Me processes the imported data and displays it in the corresponding window. For the system to process the data automatically, select the “Auto (attempt detection)” option respectively.

Upload a File - Planning Routes by Spreadsheets

 

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

Upload a File - Planning Routes by Spreadsheets

 

Next, click “Continue to Review.”

Upload a File - Planning Routes by Spreadsheets

 

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 addresses were successfully geocoded with “High Confidence.” Addresses that have yellow colored dots next to them should be reviewed and fixed accordingly.

Upload a File - Planning Routes by Spreadsheets

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

 

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

Upload a File - Planning Routes by Spreadsheets

 

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

Upload a File - Planning Routes by Spreadsheets

 

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

Upload a File - Planning Routes by Spreadsheets

 

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

Upload a File - Planning Routes by Spreadsheets

 

Visit Route4Me's Marketplace to Check out Associated Modules:

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