# Geocoding addresses in Google Sheets

**URL:** <https://community.glideapps.com/t/geocoding-addresses-in-google-sheets/10523>\
**Category:** Ask for Help\
**Created:** [June 8, 2020, 10:58am UTC](https://community.glideapps.com/t/geocoding-addresses-in-google-sheets/10523 "2020-06-08T10:58:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![garrison](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garrison/32/22059_2.png) [@garrison](https://community.glideapps.com/u/garrison)\
**Post date:** [June 8, 2020, 10:58am UTC](https://community.glideapps.com/t/geocoding-addresses-in-google-sheets/10523/1 "2020-06-08T10:58:45Z")

</div>

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

> **[Geocode](https://sites.google.com/site/scriptsexamples/available-web-apps/awesome-tables/add-ons/geocode)**
>
> \*\*\* This page is deprecated. Please click here for the new version\*\*\*

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!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 8, 2020, 12:47pm UTC](https://community.glideapps.com/t/geocoding-addresses-in-google-sheets/10523/2 "2020-06-08T12:47:24Z")

</div>

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.