Skip to content
JavaScript HTML
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md
geocoder-census-geographies.gs
geocoder-census-google.gs
geocoder-mapzen-testing.gs
google-sheets-geocoder-census-geographies.gif
google-sheets-geocoder-census-google.gif
googled411813f315d86cb.html

README.md

Google Sheets Geocoder

Geocode addresses into latitude/longitude coordinates inside Google Sheets, with US Census or Google Apps service

Demo Geocoder US Census or Google

Screencast

Demo Geocoder US Census Geographies

Screencast

About 15-character GeoID

  • Make sure that column G is formatted as text (to preserve leading zeros), not number
  • Break down a sample GeoID: 090035245022001
    • state = 09
    • county = 003
    • tract = 524502 = 5245.02
    • block group = 2
    • block = 001

How to insert script into any Google Sheet

  • Download or fork the Google Sheets scripts (.gs) from this GitHub repo
  • Go to your Google Sheets > Tools > Script Editor
  • File > Create New Script File
  • Copy and paste contents of your preferred script (such as geocoder-census-google.gs)
  • Save as Code.gs (or save, then rename to geocoder-census-google.gs)
  • Refresh your Google Sheet and look for new Geocoder menu

See also: Batch upload to US Census

  • Available at US Census Geocoder https://geocoding.geo.census.gov/geocoder/
  • Upload up to 1000 rows
    • Find Locations using > Address Batch (returns latitude, longitude coordinates)
    • Find Geographies using > Address Batch (returns lat, lng, census geographies)
  • Upload CSV table with up to 1000 rows for faster processing, in this format:

| AnyID | Street | City | State | Zip | | :----- | :----- | :--- | :---- | : --- | | 1 | 300 Summit St | Hartford | CT | 06106 |

Learn more

Credits

Testing

You can’t perform that action at this time.