Hill Country Bots
Google Sheets™ add-on

Address Geocode and Map


Turn a column of US addresses into latitude, longitude and a shareable map, right inside Google Sheets™. Look-ups use the free US Census Geocoder.

What it does

If you keep addresses in a spreadsheet, you already know the busywork. Copy them out, geocode them somewhere else, paste the coordinates back, then try to get a map you can send to a client. This add-on does that in the sheet you already have.

Select the column with the addresses (or pick separate street, city, state and ZIP columns) and run Geocode this column. Results go to a new tab, so your own data is left alone. For each row you get latitude, longitude, the matched address, and a clear match status: Match, Tie, No_Match, or Outside coverage.

The look-ups use the US Census Geocoder, which is free and needs no API key from you. It covers the United States, Puerto Rico, and the US Island Areas. Addresses clearly outside that area are marked Outside coverage and are not sent to Census. Coordinates are approximate, because Census interpolates them along its street address ranges. Some campus or named-building addresses will not match, even when they are well known. Ordinary street addresses are what this engine is built for. This product uses the Census Bureau Data API but is not endorsed or certified by the Census Bureau.

When the run is done, click Make a shareable map. You get an HTML file you can download and send. The points live in that file. They are not uploaded to our website. The map uses OpenFreeMap tiles and OpenStreetMap data, not Google Maps™.

Long lists are fine. Runs go in batches, save their progress, and pick up where they left off. For a quick check of a few addresses there is also a formula: =HCB_GEOCODE(A2).

What it asks permission for

The add-on asks Google for three things only, and only so these features can work:

  • See and edit only the spreadsheet you open it in. It reads the address column you pick and writes a new results tab in that same file. It cannot open your other spreadsheets, your Google Drive™, or your Gmail™.
  • Connect to external services. It sends the selected US-coverage addresses to the US Census Geocoder so it can return coordinates. Later, if you buy a plan and paste a license key, the key is sent to Lemon Squeezy to confirm it is active. There is no narrower permission for this: Google Apps Script™ needs this exact access for any call to an outside web service, and the Census look-up is the core feature, so the add-on cannot work without it.
  • Show a sidebar and a menu under Extensions. That is how you run a look-up and download a map. No narrower permission exists for an add-on sidebar.

The privacy policy explains this in more detail, including how Google user data is used. The terms cover use of the add-on, pricing, cancellation, and refunds.

Pricing

Free to start, 500 address look-ups a month, no card needed. Paid plans are not open yet. When they are, payments will go through Lemon Squeezy. Hill Country Bots is the seller, not Google.

Plan Price What you get
Free $0, no card 500 address look-ups a month
Pro $7 a month, or $59 a year 10,000 look-ups a month

Prices were set on November 12, 2026. They will be the total price, including any mandatory tax, once checkout is open.

Support

Questions or a bug? Email [email protected]. We read every message.

Built by Hill Country Bots. Legal name: Jerry N. Wiggins Jr, 4301 Hookbilled Kite Drive, Bee Cave, TX 78738.

Related tools

Google Sheets™, Google Maps™, Gmail™, Google Drive™ and Google Apps Script™ are trademarks of Google LLC.