Open the add-on
Launch Sheets Geocoder from the Extensions menu and choose address-to-coordinates or coordinates-to-address.
Forward and reverse geocoding
Sheets Geocoder
Addresses in. Coordinates out.
Sheets Geocoder is a Google Sheets add-on that converts selected street addresses into latitude and longitude coordinates and reverse geocodes coordinate pairs into formatted addresses. Process an entire column without an API key, export, or custom script.
100 geocodes free, one time · No credit card
Why Sheets Geocoder requests Google access
Sheets Geocoder accesses only the current Google Sheet and your Google account email. Your email identifies your account and applies the one-time 100-geocode allowance. Only the addresses or coordinates you select are sent to the applicable geocoding provider: Google for free lookups or Radar for paid lookups. Paid inputs and results are retained for less than 24 hours while the background job runs and retries safely. See our policy for complete details.
Read the privacy policy| A | B | C | D | |
|---|---|---|---|---|
| 1 | Address | Latitude | Longitude | Status |
| 2 | 1600 Amphitheatre Pkwy, Mountain View | 37.422408 | -122.085609 | OK |
| 3 | 350 5th Ave, New York, NY 10118 | 40.748440 | -73.985664 | OK |
| 4 | 221B Baker St, London NW1 6XE | 51.523767 | -0.158555 | OK |
3 of 3 locations geocoded
Simple by design
From messy locations to usable data
Sheets Geocoder keeps the workflow where your data already lives. Select, convert, and keep working.
Select your rows
Point it at one address column, or two columns containing latitude and longitude. Preview the output before it runs.
Get structured results
Receive coordinates, formatted addresses, city, region, postal code, country, and a clear status for every row.
Two-way conversion
Go there and back again
Address → coordinates
Turn street addresses, landmarks, cities, or postal codes into latitude and longitude.
1600 Amphitheatre Pkwy → 37.422, -122.086Coordinates → address
Reverse geocode a coordinate pair into a readable, structured location.
40.7484, -73.9857 → 350 5th Ave, New YorkStep-by-step guides
Turn location data into usable columns.
Follow the complete workflow, from preparing source rows to choosing output fields and resolving no-match results.
01
Address → coordinates
How to geocode addresses in Google Sheets
Prepare address columns, choose an output location, and bulk return latitude and longitude.
02
Coordinates → address
Convert latitude and longitude to addresses
Format coordinate pairs correctly and return only the address fields your spreadsheet needs.
Common questions
The short version
Do I need a Google Maps API key?
No. Free lookups use Google Maps through the add-on and paid lookups use Radar through our secure backend. You do not configure either provider or manage an API key.
Does it work in both directions?
Yes. Forward geocoding converts an address into latitude and longitude. Reverse geocoding converts a latitude and longitude pair into a formatted address.
How does the free allowance work?
Each account receives 100 geocodes total. It is a one-time allowance, not a monthly reset, and forward and reverse lookups both count toward it.
What happens to my spreadsheet data?
Only the cells you choose are processed. Free lookups go to Google through Apps Script; paid inputs and results are held in our secure backend for less than 24 hours while Radar processes the job. Trigger.dev coordinates background work without receiving your selected addresses or coordinates.
Can I process a whole column?
Yes. Select a range and the add-on processes it in the background, placing structured results in adjacent columns. Pro includes up to 75,000 rows per UTC calendar month; larger workloads require Enterprise.
Ready when your sheet is
Try it on your first 100 locations
No card and no trial timer. Sign in with Google and start geocoding.
Start free