You can use the OpenCage geocoder inside Microsoft Excel to convert a list of coordinates to placenames (reverse geocoding) or placenames/addresses to coordinates (forward geocoding).
- register for an OpenCage Geocoder API key
- Download and install the OpenCage Excel Add-in.
Once installed the add-in enables to new formulas
=RGEOCODEfor reverse geocoding, and
=FGEOCODEfor forward geocoding notice that the parameters are slightly different for the two functions.
- Within the Add-in you'll find detailed examples in the "Examples" sheet
- Before either command will work you will need to enter your OpenCage Geocoder API key in the "Get Started" sheet.