Upload Spreadsheets with Addresses into the Address Book Map
When you need to import hundreds or thousands of customers’ locations, depots, commercial facilities, warehouses, or the information about any other relevant prospects and real-world locations into your account, you can simply upload a single spreadsheet, and Route4Me’s route optimization software will automatically create a separate address entry or customer profile for each imported entity. When using our route planner Excel upload capabilities, all customer data and addresses that are saved and modified using the Address Book Map can be automatically synchronized across all associated and authorized devices in real time. Thus, whenever you or your team members create a new entry using our route planner Excel upload solutions in the synchronized Address Book from the Route4Me Web Route Planning Platform, it instantly becomes available in Route4Me’s iOS and Android Route Planner apps.
To upload a spreadsheet with customer data, addresses, or contacts into the system, first, go to “Address Book Map” from the navigation menu.
Next, go to “File” in the top left corner of the screen and then select “Upload Addresses” from the list.
After that, upload the spreadsheet with customer data from your device into the system. Learn more about spreadsheet requirements.
For the spreadsheet that you want to import into the system to be successfully processed, it must contain a header row and data rows. The header row defines the type of information you are importing, while the corresponding data rows contain the actual data that is being imported into the system.
In addition to the obligatory “Address” column, you can also include other data columns with Route4Me reserved attributes and custom data:
- Reserved Attributes: Columns that contain Route4Me reserved attributes (i.e., address, alias, revenue, cube, priority, etc.) that are automatically recognized by the system and assigned to their corresponding user interface elements/components;
- Custom Data: Columns that contain the custom information that cannot fit into Route4Me’s predefined fields. Learn more about Address Book Custom Data Add-On.
Once you upload the spreadsheet, Route4Me processes the imported data and displays it in the corresponding window. Select the “Auto (attempt detection)” option for the system to automatically assign the right column titles to their corresponding reserved attributes and custom data columns.
Alternatively, you can manually match column titles to the data contained in each column.
By default, the data that is not recognized as one of the reserved attributes is assigned the “Custom” column title in addition to the original name of the corresponding column in the imported spreadsheet. Ensure that all columns have the titles that match their contents, and then click on the “Continue to Review” button to proceed.
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.
Once the spreadsheet with addresses and customer data is successfully imported and processed, Route4Me automatically creates a new profile for each customer or address in the synchronized Address Book and displays it accordingly on the Address Book Map. Learn how to edit existing customer profiles on the map.
Route4Me provides near real-time data synchronization across all associated computer and mobile devices so that any changes made from the Route4Me Web Platform can be automatically synchronized with Route4Me’s iOS and Android Route Planner apps in a matter of seconds. Thus, managers and dispatchers back at the office can create new customer profiles, addresses, or contacts on the Address Book Map, and the drivers who are out in the field will be able to view and use all that data right away.