# User coordinates-\> zip & postal code in sheets

**URL:** <https://community.glideapps.com/t/user-coordinates-zip-postal-code-in-sheets/14265>\
**Category:** Ask for Help\
**Created:** [August 20, 2020, 8:56pm UTC](https://community.glideapps.com/t/user-coordinates-zip-postal-code-in-sheets/14265 "2020-08-20T20:56:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [August 20, 2020, 8:56pm UTC](https://community.glideapps.com/t/user-coordinates-zip-postal-code-in-sheets/14265/1 "2020-08-20T20:56:31Z")

</div>

Is there an easy way to convert coordinates to postal code using a formula in sheets?

I know one can use script but want something easier.

Your help is appreciated 🙂

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 21, 2020, 12:57pm UTC](https://community.glideapps.com/t/user-coordinates-zip-postal-code-in-sheets/14265/2 "2020-08-21T12:57:21Z")

</div>

You can, with this: [https://www.labnol.org/google-maps-sheets-200817](https://www.labnol.org/google-maps-sheets-200817)

Of course this requires Script, but at least you don’t have to write a new one.

The formula I am talking about is GOOGLEMAPS\_REVERSEGEOCODE.  
You can alter the script to only show post codes, or split the address to read only the post code in the final column.

---

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [August 21, 2020, 1:29pm UTC](https://community.glideapps.com/t/user-coordinates-zip-postal-code-in-sheets/14265/3 "2020-08-21T13:29:47Z")

</div>

Thanks Amit! So nice of you to share this. This is very helpful.
