Route4Me Bulk Geocoder
The Route4Me Bulk Geocoder is a standalone desktop application that acquires latitude and longitude coordinates for a large number of addresses at the same time. It also adds the geocoded addresses to the Route4Me Address Book.
To open the app, double-click the “geocoder” executable file, or right-click on it and select open.
Type in your Route4Me credentials in the “Email” and “Password” fields.
The Geocoder supports .CSV files. Prepare a .CSV spreadsheet containing all the columns you want to include and make sure your file has a header row.
Your file needs to include address columns, which must contain the street name and number (in the “Address” column) and separate columns for “City”, “State” and “ZIP.”
Click the upload icon, then browse for your file and upload it into the geocoder.
After the upload is complete, click the “Start Geocoding” button.
You can monitor the geocoding status in the progress bar.
When the geocoding process is completed, the geocoder will display 5 additional columns: the latitude and longitude columns (“lat”, “lng”, “curbside_lat” and “curbside_lng”) and a separate column for the geocoding confidence. Addresses that were geocoded with high confidence do not need to be reviewed. If the addresses were geocoded with low or medium confidence, you may need to verify and re-upload them, if the geocoded location is incorrect.
The geocoder will automatically add the addresses to your Route4Me Address Book.
It will also create a copy of your initial .CSV file, with the appended columns that resulted from the geocoding process: “lat”, “lng”, “curbside_lat”, “curbside_lng” and “confidence”.