Forward geocoding of addresses, which can be multicolumn addresses. Reverse geocoding of latitude, longitude into nearest address.
Simple script to help people forward geocode addresses into latitude, longitude pairs; or reverse geocode latitude, longitude pairs into the nearest known address.
It can handle addresses spread out over multiple columns, so the street, then city, then country could be in separate columns. It will copy the address data into a single string, then geocode it.
There's an example sheet with data that can be copied and tried out:
https://docs.google.com/spreadsheets/d/1PZGulsMOTAjJxjPDzMrkunTCXQlFYOga50m3ZouzxHg/edit?usp=sharing
Should do what it says on the box, but feel free to report bugs at the Github repository -- https://github.com/nuket/google-sheets-geocoding-macro/issues