Geocoding addresses in Google Sheets

Following on from my previous post on geocoding addresses using Opencage Data and JS code, I have found an even better solution:

It basically turns ordinary/regular formatted addresses in your Sheet into longitude and latitude values, which it does by creating additional 2 columns. You then need to create a column to join these values together and voila! More accurate map pins in Glide.

I’ve tested it and it works a treat!


Yep! This addon/script is a gem. I’ve been playing around with it for a few months now. Once Glide allows users to pass GPS or latlong as a special value in forms, I bet this script will be a crux to many location based apps.

1 Like