User coordinates-> zip & postal code in sheets

Ask for Help
1

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 :slight_smile:

1 Like
2

You can, with this: 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.

2 Likes
3

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

1 Like