GeoFill is an address and coordinate tool for Google Sheets™.

Geocode addresses from one or several columns to latitude and longitude (lat long coordinates) in bulk, right in Google Sheets™. Or reverse geocode GPS coordinates back to addresses, postcodes and zip codes.

HOW IT WORKS
Open GeoFill from the Extensions menu, pick your address columns and what you want filled in, and click Geocode. GeoFill adds output columns and fills eligible rows:
• Latitude and longitude
• The full, cleaned-up address
• Postcode or zip code, city, region, country and country code
• A Match column for each row: Exact, Street, Area, Approximate or Not found, so you know which results to check

Addresses split over several columns (street, city, state, postcode, country)? Add each column in address order and check the joined example before running. Empty parts are skipped and your input columns are preserved. Long lists run in batches you can stop and pick up later: rows already done are skipped. Prefer results in one country or language? Set it under More options.

REUSE YOUR SETUP
After you start a run, GeoFill remembers that tab's input columns, their order and your selected options for your Google account. Reopen the sidebar and check the restored choices. Changed or duplicate input headings require reselection. Forget this tab's saved setup removes its saved choices.

CHECK THE JOB BEFORE IT STARTS
See rows needing results, rows already processed, empty inputs and the remaining free allowance before GeoFill creates output columns. If the free allowance will not cover the job, choose explicitly whether to keep partial results now or cancel. The preview does not reserve allowance; each batch checks it again.

POSTCODE OUTPUT AS TEXT
Postcode results are written as plain text, so a leading zero survives: 02139 stays 02139. Input columns are read as displayed; format source postcodes correctly first. Geocoding returns Google's normalized address parts, rather than validating postal delivery or simply splitting your original text.

REVERSE GEOCODING
Pick your latitude and longitude columns and get the address, postcode, city, region and country of each point.

FORMULAS (PRO)
=GEOCODE(A2) gives latitude and longitude in the next two cells. =GEOCODE(A2:A500, "lat, lng, city, country") does a whole range. =REVERSE_GEOCODE(B2, C2) goes back. Results may be cached for up to six hours; new lookups use your allowance.

DISTANCE AND DRIVE TIME (PRO)
=DISTANCE(A2, B2) gives the driving distance in km, =DISTANCE(A2, B2, "mi") in miles, and =DRIVE_TIME(A2, B2) the driving time in minutes, without traffic. Use ranges for a whole column, or one fixed place against a column. In the sidebar, enter one place to add Distance and Drive time columns from every address to it. Routes come from Google Maps™ on your own daily quota.

PLANS
Free: 25 address or coordinate lookups in total. Existing users keep their current free allowance. No sign-up, no card.
GeoFill Pro: $9 once per Google account. Removes GeoFill's free cap, adds the formulas, distance and drive time, and lets you use your own Google Maps™ Platform key. Google's quotas still apply; any charges for your key are separate.

Each spreadsheet needs a successful purchase check at least every 30 days to keep Pro formulas calculating. Open GeoFill and click Refresh geocoding formulas if asked. Reopening the spreadsheet alone cannot renew the check, and an unavailable billing service cannot extend it.

Existing subscriptions and trials retain their original renewal and cancellation terms. Manage them from the sidebar; buy once after the existing entitlement ends. Buying once does not cancel a subscription.

GeoFill uses Google's own geocoding service, within your account's daily allowance (1,000 lookups a day on a personal Google account, 10,000 on Google Workspace™).

PRIVATE BY DESIGN
GeoFill only reaches the spreadsheet you open it in, never your other files. It has no servers of its own: your data goes only to Google's geocoding service, and payments go through Stripe.

Made for sales and field teams, real estate, logistics and delivery planning, researchers and anyone putting a list of places on a map.

Google Sheets™, Google Maps™ and Google Workspace™ are trademarks of Google LLC.