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 Google Maps for conversion; Sheets Geocoder does not store those inputs or results.
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 YorkCommon questions
The short version
Do I need a Google Maps API key?
No. Sheets Geocoder uses Google Maps through the add-on, so there is no API project or separate billing account for you to configure.
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 address or coordinate cells you choose are sent to Google Maps for conversion. Sheets Geocoder does not read the rest of your spreadsheet or store the addresses after processing.
Can I process a whole column?
Yes. Select a range and the add-on works through it in small batches, placing structured results in adjacent columns while keeping your sheet responsive.
Ready when your sheet is
Try it on your first 100 locations
No card and no trial timer. We will email you when early access is ready.
Join the launch list