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
The language parameter is optional, but if used should be a language code as defined in the API docs.