App Icon
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.
Listing updated:August 31, 2021
Works with:
821,551
Overview
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)
Additional information
PricingNot available
Privacy policy
Terms of service
Geocode by Awesome Table will ask for the permissions shown below. Learn more
Geocode by Awesome Table will need access to your Google account
This will allow Geocode by Awesome Table to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Geocode by Awesome Table
August 25, 2015
The geocoding is great, the map is cool, but I had trouble figuring out how to get tooltips. I didn't notice the little green box that said "Create Tooltip." Luckily, the developer contacted me and helped me figure it out. Great tech support!
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
November 11, 2016
Amazing! I can save hours of work in google's API just using this. But I'm not sure if is my windows/chrome that is causing some problems in charge the add-in and its appearence. Is kind of annoying. Also, the responses of lat and long are with wrong masks (the number is correct) and I don't know if it is 'cause my data sheet and account are in portuguese. However, I can handle those problems and still save time.
Is this review helpful?
Yes
No
Profile Picture
Scott Snibbe
September 20, 2016
Terrific plug-in but just started hanging forever on Chrome Mac, despite browser restart, uninstall/reinstall. Any advice?
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
August 28, 2019
Does not work at all. (Spinning arrows)
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
May 10, 2018
WOW! Nice add on. Super easy and intuitive. Great job!!
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
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?
Is this review helpful?
Yes
No
Profile Picture
John Notgrass
August 1, 2016
Beautiful results that help to visualize geographic information.
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
January 31, 2019
Works very well. Would like the ability export image, KML file For a free product, its still awesome.
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
August 1, 2019
Doesn't work anymore.
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
July 9, 2017
Super easy to use! Was able to geocode all of my addresses quickly and easily.
Is this review helpful?
Yes
No
1-10 of 64
Search
Clear search
Close search
Google apps
Main menu