Geocode a whole column of addresses 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 the column with your addresses and what you want filled in, and click Geocode. GeoFill adds the columns and fills every row:
• 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, country)? Pick a second column and GeoFill joins them. 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.

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 are cached, so recalculating costs nothing.

PLANS
Free: 100 addresses a day, every day. No sign-up, no card.
GeoFill Pro: no daily cap, the formulas, and your own Google 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.

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.