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. copy the script opencage.js into the scripts editor and save
  5. For reverse geocoding (coordinates to places) in your sheet use
  6. For forward geocoding (places to coordinates) in your sheet use
In both cases the language parameter is optional, but if used should be a language code as defined in the API docs.


Start geocoding now with a free trial

2,500 API requests per day, for as long as you like.

No credit card required.

Start your free trial