Upload a File – Plan Routes by Uploading Spreadsheets

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

 

To plan routes with spreadsheets containing customers’ addresses, 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
Route4Me

About Route4Me

Route4Me has over 40,000 customers globally. Route4Me's Android and iPhone mobile apps have been downloaded over 2 million times since 2009. Extremely easy-to-use, Route4Me's apps create optimized routes, synchronize routes to mobile devices, enable communication with drivers and customers, offer turn-by-turn directions, delivery confirmation, and more. Behind the scenes, Route4Me's operational optimization platform combines high-performance algorithms with data science, machine learning, and big data to plan, optimize, and analyze routes of almost any size in real-time.