Excel Geocoding Tutorial

Before we dive in to the tutorial ...

Please note: our Excel plugin is designed as a way to quickly test our service or to do a small (< 1,000 requests) volume of geocoding. It is not designed for high volume production use.

Secondly, this plugin is unlikely to work on older versions Windows and Excel, as we - like most other internet services - no longer support HTTPS requests made using unsafe TLS protocols. Sorry, you may instead with to try our Google Sheets plugin.

If your spreadsheet geocoding needs are more complex, or you'd just generally like someone else to solve this for you, we recommend you work with our friends at Clean Spreadsheets, who will gladly use our API to do the geocoding for you.

Ok, ready?

You can use the OpenCage Geocoding API inside Microsoft Excel to convert a list of coordinates to placenames (reverse geocoding) or placenames/addresses to coordinates (forward geocoding).

  1. Sign up for an OpenCage Geocoding API key, or if you already have one log in.
  2. Download and install the OpenCage Excel Add-in.
  3. Once installed the add-in enables to new formulas =RGEOCODE for reverse geocoding, and =FGEOCODE for forward geocoding

    OpenCage Excel geocoding tutorial step 1

    notice that the parameters are slightly different for the two functions.

  4. Within the Add-in you'll find detailed examples in the "Examples" sheet

    OpenCage Excel geocoding tutorial step 2

  5. Before either command will work you will need to enter your OpenCage Geocoding API key in the "Get Started" sheet.

    OpenCage Excel geocoding tutorial step 3

Further Reading

Start your free trial

2,500 geocoding API requests per day.

No credit card required.