Batch Geocoding

Input

clear input

Settings

Google API Key

Output Settings

Output Fields
Output Fields

Output

clear output
clear results
indicator

Results

Time:0 s #:0
Address:0
Street:0
Locality:0
General:0
FAIL:0

Notes

Problems? Questions? Suggestions? Please let us know.
Are you getting REQUEST DENIED errors? Please review Google's Geocoding API Usage and Billing page.

Instructions

Batch Geocoding

To convert addresses or locations into latitude-longitude coordinate pairs:

  1. Go get an API key from Google. You'll need to enter a payment method, though if you stay under their limits you won't have to pay.
  2. Enter your Google Cloud API into the Google API Key field.
  3. Enter your addresses/locations in the input field, one address per line, up to a few hundred addresses.
  4. Select the desired outputs via the checkboxes in the "Output Fields" box.
  5. Choose whether or not to include failed geocodes in your output via the checkbox in the "Settings" box.
  6. Likewise, choose whether or not you want a header row of field labels at the top of your output in the same box.
  7. Select a field delimiter (separates the output fields) for your output in the same box.
  8. Click the "geocode" button to begin geocoding.
  9. Your results will be displayed incrementally in the "output" field. The "Results" box will display the total number of addresses processed, the time it took to process them and the results of the processing.
  10. When processing is complete you can copy the results from the output field or click the
    button to save output to a csv/tsv/text file.

Input

Enter your addresses/locations in this field, one address per line, up to a few hundred addresses.

Example input:
Eiffel Tower
1600 Pennsylvania Avenue, Washington, DC
Great Pyramid of Giza
263 Prinsengracht, Amsterdam
1265 Lombardi avenue, Green Bay, WI
1060 West Addison Street, Chicago, IL
10 Downing Street, London, England

Settings

Google API Key - paste your Google API key into this field.
Notifications - if you wish to have your operating system notify you when your job is complete, or an error has occurred, select this checkbox.
geocode - clicking this button initiates the geocoding run (it also clears the output field of any previous output).

Output Settings

output type - select basic fields if you only wish to select from a few fields, select all fields if you wish access to all available fields. Select full raw json to receive Google's full response in JSON format, select full raw xml for the same in XML format.
output fields - if you selected either of the fields options from output type you can select which fields you wish to output.

include fails - include records for which we are unable to find a result in the output.

If you selected "fields" from the output type you'll have an output fields dropdown containing the following fields:
address in - this is the address or location you entered in the input field.
address out - the closest matching location in the geocode database.
latitude - output latitude.
longitude - output longitude.
accuracy - numerical representation of geocode accuracy (see key below).
status - geocode result code (see key below).

For "fields" you'll also have these selections:
field delimiter - select the delimiter (comma, pipe or tab) used to separate record fields in the output. (Selecting comma as the delimiter will cause the address fields to be double quote enclosed.)
coordinate format - select the latitude-longitude format used (degrees decimal, degrees minutes decimal or degrees minutes seconds decimal).
include header - include a header row in the output.
multiple results per record - return all results available for each record queried. It's strongly recommended that you include your input record in the output when using this option.
Select the checkboxes of the items you wish to be included in the output.

Accuracy
9 - rooftop
8 - address range
5 - city/municipality
3 - region
0 - fail

Status
200 - okay
602 - unknown address
610 - invalid address
620 - over query limit

Results

Time - elapsed time of the latest geocoding run.
# - total number of records processed during the latest geocoding run.

The remaining fields display the number of records of each result type listed below.

Accuracy
9 - address (rooftop)
8 - street (address range)
5 - locality (city/municipality)
3 - general (region)
0 - fail

Output

Output will be appended here. To save output to a text file click the
button.