Many business people use spreadsheets. And many business people face the challenge of sometimes having to enrich their data with addresses and geo coordinates. However, many businesses don’t have the skills, the time or the resources to utilise more technical bespoke solutions for geocoding and address enrichment / validation.
In this blog post I wanted to share a custom script I found online that helps non-technical users easily implement a geocoding solution in Google Sheets. As can be seen from the video below, after the script has been loaded, the user can easily reference a list of places, for example, in a spreadsheet and then run the scripts to populate date relating to XY coordinates (latitude, longitude) and / or addresses.
The video below illustrates how it works once the script has been implemented:
And below is the original script which was sourced from the following github repository link:
More details on the Google Apps Script utilised can be found here.