# How to perform forward & reverse geocoding in Google Sheets
**URL:** https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204
**Category:** Ask for Help
**Created:** [May 15, 2020, 2:38pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204 "2020-05-15T14:38:53Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@garrison](https://community.glideapps.com/u/garrison)
#### Post date: [May 15, 2020, 2:38pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204/1 "2020-05-15T14:38:54Z")
Maps are becoming a real pain point these days, especially as API pricing has increased more than tenfold with Mapbox and Google.
This has resulted in the need for ‘map optimisation’ techniques to limit the number of API calls, or mix and match various SKUs.
Here’s a neat little mashup that uses Open Cage Data’s geocoding service with Google Sheets…
> **[OpenCage Geocoding API Google Docs Tutorial](https://opencagedata.com/tutorials/geocode-in-googledocs)**
>
> Tutorial for using the OpenCage Geocoding API in Google Docs - An API for reverse and forward geocoding using open geo data
In short, you can use Google Sheets and the OpenCage Geocoder to quickly convert a list of coordinates to placenames (reverse geocoding) or vice versa (forward geocoding).
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 15, 2020, 2:49pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204/2 "2020-05-15T14:49:05Z")
Cheers for the tips, Garrison!
As it’s related to my thread the other day, my script took the numbers from Google, but did not require an API key.
Link for reference:
[https://community.glideapps.com/t/re-concept-for-5km-delivery-constraint-time-taken-to-travel/9130/](https://community.glideapps.com/t/re-concept-for-5km-delivery-constraint-time-taken-to-travel/9130/)
---
### Author:  [@garrison](https://community.glideapps.com/u/garrison)
#### Post date: [May 15, 2020, 2:57pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204/3 "2020-05-15T14:57:32Z")
@ThinhDinh: any method that doesn’t require an API key for Google Maps is fine by me!
This is tip will be particularly useful to those who have their address data as placenames and need to forward geocode them to get the coordinates for more accurate pin placements.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [May 15, 2020, 5:58pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204/4 "2020-05-15T17:58:37Z")
Hi,
You can use Geocode by Awesome Table too, I used to work with it months ago and made the job always. I don’t know if it is free yet
[https://gsuite.google.com/marketplace/app/geocode\_by\_awesome\_table/904124517349](https://gsuite.google.com/marketplace/app/geocode_by_awesome_table/904124517349)
Hi @ThinhDinh, although any script doesn’t use an API key, Google sets daily query limit (1000). Beyond, you will need your own API key
Saludos
---
### Author:  [@garrison](https://community.glideapps.com/u/garrison)
#### Post date: [May 15, 2020, 6:55pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204/5 "2020-05-15T18:55:03Z")
@gvalero: problem is it uses Google Maps API which is what we need to get away from 😉
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 15, 2020, 11:07pm UTC](https://community.glideapps.com/t/how-to-perform-forward-reverse-geocoding-in-google-sheets/9204/6 "2020-05-15T23:07:43Z")
Thanks for the info, Gustavo. I have only tested it in small scales, will have to give the customer a notice.