Help & Support
Send Feedback
Geocode by Awesome Table
Geocode is a tool that helps you get latitudes & longitudes from addresses in a Google Sheet to display them on a map you can share.
2 users
Works with
Geocode is a map tool that helps you get latitudes and longitudes from addresses in a Google Sheet and display them on a Google map you can share.

Easily get geographic data
Addresses are converted into Maps coordinates: longitudes and latitudes. Geocode uses Google's services to retrieve these data and is optimized for address recognition thanks to a built-in error management system: if Google doesn't recognize an address, Geocode can perform a broader research, making sure you get a result for each row of your spreadsheet. And then we display all your data on a map.

How does it work?
Create a spreadsheet (or reuse one of your existing ones)
Add physical addresses and other info
Use the spreadsheet menu Add-on > Geocode
Indicate the column containing your addresses 
Click on the button to start the geocoding
That’s all! Once the geocoding is done, you will see two more columns in your spreadsheet (for latitude and longitude data) and a link to the Maps view created.

The Google Maps view is powered by Awesome Table
All rows of your spreadsheet are displayed as markers on the map
If you have too many markers we do some automatic clustering to improve the display
You can filter the data displayed on the map based on the data in your spreadsheet (we have filters for every type of data - lists, dates, numbers,...)
A table is displayed (and can be hidden) below the map, listing all information from your spreadsheet (if you click on a specific row in this table, the Map is automatically centered on the location linked to this row)
On each marker displayed on the map, a tool-tip is available (pop-up with additional info) and you can customize this tool-tip to display the info you want (you can even add some HTML, to add links or images)
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
January 31, 2019
Works very well. Would like the ability export image, KML file For a free product, its still awesome.
Submit reply
October 25, 2018
Easy to use. However I found that when using a dynamic field as address it could run into some problems. I'm not sure but I tried the "submitting from form" option and it did not seem to work. I'm guessing maybe because the field to use is dynamically populated?
Submit reply
June 6, 2018
used to work but doesn't work anymore. Don't bother using until it's fixed
Submit reply
July 3, 2018
I installed it yesterday and it doesn't show the map. Any solution coming soon? The tool seems super useful but if I can't see the map in the background it misses the whole point of it.
June 27, 2018
Same here. Bummed because it's super useful.
May 10, 2018
WOW! Nice add on. Super easy and intuitive. Great job!!
Submit reply
September 18, 2017
Works as expected. Good tool!
Submit reply
September 5, 2017
Works Great
Submit reply
It's fast and easy for students to map case studies in class and make connections for global understanding.
Submit reply
July 27, 2017
It did just what I wanted nice and quickly and hid all of the background details (I just wanted to quickly geocode 400 city/state to lat/lon). I've written code to do this with Google's Maps' API and didn't want to take the time to dig it out and set it up (with this tool glad I didn't).
Submit reply
Super easy to use! Was able to geocode all of my addresses quickly and easily.
Submit reply
December 1, 2016
It works. Only issue is one can only perform 1000 lines per day. When working on big sheets - this is a problem. 35000+ lines = 35+ days. Bad when trying to map customers.
Submit reply
February 1, 2019
Create several accounts/ask friends to run splitted chunks of data. I know this is 2 years late but still want to tell new people who will come to read here.
January 22, 2017
I too need the ability to run this function across thousand of entries
1-10 of 24
Additional information
Clear search
Close search
Google apps
Main menu