Google Docs Geocoding Tutorial

You can use Google Sheets and the OpenCage Geocoder to quickly convert a list of coordinates to placenames (reverse geocoding) or vice versa (forward geocoding).

  1. register for an OpenCage Geocoder API key
  2. create a new Sheet in Google Docs
  3. open Tools > Scripts editor
  4. If you want to convert coordinates into placenames copy the script reverse.js into the scripts editor and save
  5. In your sheet use
    =reverse(longitude,latitude,YOUR-API-KEY,language)
    
The language parameter is optional, but if used should be a language code as defined in the API docs.

Example