GeoFill: Geocode Address to Lat Long Coordinates

Batch geocoding in bulk: a column of addresses to latitude, longitude and a clean address, or GPS coordinates back to addresses (reverse geocode). 100 a day free. Reaches only the sheet you use.

Pro $4.99 a monthInstall add-on

GeoFill: Geocode Address to Lat Long Coordinates screenshot

GeoFill is an add-on for Google Sheets™ that turns a column of addresses into latitude, longitude and a clean formatted address, and coordinates back into addresses, for the whole sheet at once.

From a sidebar: pick the address column (or the latitude and longitude columns) and what to fill in: latitude, longitude, the full address, postcode, city, region, country. Each row also gets a Match: Exact, Street, Area, Approximate or Not found. Long lists carry on where they stopped.
As a formula (Pro): =GEOCODE(A2) or =GEOCODE(A2:A500, "lat, lng, city"), and =REVERSE_GEOCODE(B2, C2).
Narrow access: GeoFill only reaches the spreadsheet you use it in, never your other files.

It runs on Google’s own geocoding service, within your account’s daily allowance (1,000 lookups a day on a personal account, 10,000 on Workspace).

Plans

Free: 100 addresses a day, every day.
GeoFill Pro: no daily cap, the formulas, and your own Maps Platform key to go past Google’s daily allowance. $4.99 a month or $39 a year, with a 7-day free trial. Cancel any time from the sidebar.

Install it from the Google Workspace™ Marketplace, then open it from Extensions > GeoFill in any spreadsheet.

Guides: Convert addresses to latitude and longitude in Google Sheets™ · Geocode by Awesome Table stopped working: what works now