Upload a File – Planning 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, Route4Me 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.
Next, select “Upload a File” from the corresponding window.
After that, specify the preferred route parameters and then click on the corresponding button to proceed.
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 CSV, XLS, and XLSX upload file formats. For the most accurate results, it is recommended to use CSV file format 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.
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 addresses were successfully geocoded with High Confidence. 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 precise 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.
Visit Route4Me's Marketplace to Check out Associated Modules: