How to reverse geocode coordinates in Google Sheets
By Jake Marsh · Updated
To reverse geocode in Google Sheets, turning latitude and longitude into a street address for each row, open the Geocode & Map Addresses add-on's Reverse tab, pick the Latitude and Longitude columns, click Check rows, then Run N rows. The add-on adds an Address from coordinates column and a Reverse status column next to your data. Sheets has no built-in function that does this.
When you need it
Coordinates come from many places that don't record an address: GPS trackers and phone apps, photo metadata, field survey forms, delivery proof-of-visit logs and equipment telemetry. Reverse geocoding turns each point into the nearest street address so people can read the list.
Steps
- Check the coordinate format. The add-on reads decimal degrees, like
32.7767and-96.7970. If your coordinates are in degrees, minutes and seconds (32°46'36"N), convert them first; the free DMS to decimal converter converts a whole pasted list. - Open Extensions > Geocode & Map Addresses > Open geocoder and click the Reverse tab.
- Pick the Latitude column and the Longitude column. If one column holds both as "lat, lng", pick it as the latitude column and choose (same column) for longitude.
- Leave Where are the points? on United States, Canada, Mexico.
- Click Check rows to see how many rows have coordinates and the most lookups the job can use, then Run N rows.
- Read the results. Address from coordinates holds the street address, and Reverse status says whether each row matched.
Example
A landscaping crew logs each job from a phone app that records coordinates only:
| Job | Latitude | Longitude | Address from coordinates | Reverse status |
|---|---|---|---|---|
| Spring cleanup | 32.7767 | -96.7970 | written by the add-on | OK |
The office can now sort jobs by street, send invoices to the right address, and spot a log entry that landed somewhere unexpected.
Reading the status
| Reverse status | Meaning |
|---|---|
| OK | A street address was found for the point |
| Approximate | Only a less precise match was found, such as a street or area; check the row |
| No match | Nothing was found near the point; the row isn't charged |
| Not run: no lookups left | The balance ran out before this row |
Rows that finished are skipped the next time you run, so you can add new points to the bottom and run again without paying for the old ones.
Going the other way
To turn addresses into coordinates, use the Geocode tab. To plot the points you have, open Map preview; mapping uses no lookups.
What it costs
You can try it for 250 lookups or 14 days, whichever comes first, with no card. Then it's $9.99 a month or $79 a year per Google account, including 5,000 lookups every month, and each matched point is one lookup. Lookup packs of 5,000 for $10 never expire. Install it from the Geocode & Map Addresses page.
Geocode & Map Addresses by Great Work
Geocode, reverse geocode and map addresses in Google Sheets. No API key needed. $9.99 a month or $79 a year per Google account.
Questions
Is there a reverse geocode formula in Google Sheets?
No. Sheets has no built-in function for it. The add-on fills the address column for the whole list in one run.
Can I reverse geocode points outside North America?
Not yet. Reverse geocoding covers the United States, Canada and Mexico.
Does a point with no address cost anything?
No. Rows with no match are free.
My coordinates are in one column. Does that work?
Yes. Pick that column as the latitude column and choose (same column) for longitude.