Add this Script to your Google Sheet to get a menu item for looking up Census FIPS codes for addresses.
FPIS codes are geographic identifiers for US Census blocks, block groups, tracts, counties and states: https://www.geocod.io/guides/census/#geoids-and-fips
- Go the FIPS Lookup - Starter Template, sign in to your account, and File > Make a Copy to your Google Drive:
- Select two columns for each address: the source address and the empty column to put the result.
- Google Sheets script will ask for permission to run the first time
- In your Google Sheet, click on Extensions => Apps Script
- Click Close on the pop-up tutorial window, and delete the starter text.
- Copy the entire code in fips-lookup-google-sheets.gs and paste it in.
- Save it and give it a name like 'Census FIPS Lookup'
- Reload your Google Sheet and you will see a menu item at the top called 'Census FIPS Lookup'
- Follow the steps in Getting Started above!
- Derek Eder @derekeder
If something is not behaving intuitively, it is a bug, and should be reported. Report it here
- Fork the project.
- Make your feature addition or bug fix.
- Send us a pull request. Bonus points for topic branches.
Copyright (c) 2022 Derek Eder. Released under the MIT License.