User coordinates-> zip & postal code in sheets

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

You can, with this:

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.


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

1 Like