Skip to content
bizwilliePublic

About

How to populate a cell with the ZIP Code Based on an Address in Google Sheets by using Google App Scripts

Resources

Stars

0 stars

Watchers

1 watching

Forks

Latest commit

 

History

4 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 

Repository files navigation

geo2zip

Hey! Here is the link to the article referencing this script. https://www.gislounge.com/populate-cell-zip-code-based-address-google-sheets/

I 100% recommend you give it a read but the sparknotes version is below:

How to populate a cell with the ZIP Code Based on an Address in Google Sheets by using Google App Scripts

  1. Navigate to Extentions > Apps Script (you may need to enable it as an extension if you have not done so yet) image

  2. Delete the default function from the script editor screen. Paste in the code from my repo. Give the project a name in the top left corner. image

  3. Choose the cell you want the outputs for and type in below (the referenced cell is the Full Address minus the state and zip code) image

  4. boom! After loading you will have your zip codes!

About

How to populate a cell with the ZIP Code Based on an Address in Google Sheets by using Google App Scripts

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages