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:January 10, 2023
Works with:
1M+
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
Developer
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
PRANAV SATHYAN
October 5, 2023
It works really well and as advertised, worked for almost 1500 addresses, stopped working afterwards. But still really happy with the result, as how perfect it works. But I am unsure of all the permissions this plug in is asking. - "Allow this application to run when you are not present" - "See, edit, create, and delete all your Google Sheets spreadsheets" - "See your personal info, including any personal info you've made publicly available" Not sure about this part.
Is this review helpful?
Yes
No
Profile Picture
Suzanne Martin
November 8, 2023
Worked like a charm! Thank you for creating such a great app! Easy to use, fast output!
Is this review helpful?
Yes
No
Profile Picture
N.W.O Ne'wORd'er
April 7, 2023
Don't do what I say nor do what I do. Instead be like an actor was once long long time ago. 2023 years , 4 months and 7 days at around 1900 hours it's humanly version became wholy ghost spelling into words as we imagined words are powerfully yours too if that responsibility has been eLited, a tuned, reconstrucked, and then de-Construcked. Fore instrucktion. Maybe your will can meek me sum'd day and enhanced my works along all diSidePulls . Great One Doings, it's justisS like heaven justice. Please don't worry about me being the highest one on substance, lol. Nowknows thing. Stand firmly on all good belifes and prevail. My battle is just losing for today. I'm loving mine'd raw3Ewar. In joy me anyMe massAGE.... I count in you allsoul.
Is this review helpful?
Yes
No
Profile Picture
Nathan Quinn
April 4, 2023
Honestly this is the best thing I've used with sheets. As a massive advocate for using Looker Studio especially to visually graph addresses to determine geographic performance this has been a godsend. I can't comment enough on exactly how much this helps with everything we use it for! Thank you so much!
Is this review helpful?
Yes
No
Profile Picture
Keerthi Rahul
April 14, 2023
Saviour and excellent tool. Thank you so much developer.. U rock
Is this review helpful?
Yes
No
Profile Picture
James Kohl
May 31, 2023
Thanks, works great!
Is this review helpful?
Yes
No
Profile Picture
Ifbi dev
June 15, 2022
Works perfectly for my purposes! I have an address list and need the corresponding coordinates - this tool gives me the results in the most flexible way.
Is this review helpful?
Yes
No
Profile Picture
Dustin Moore
July 15, 2022
This thing is a godsend. Also, sorry for using 4,581 queries. <3 Thank you genius developers!
Is this review helpful?
Yes
No
Profile Picture
Sankar Das
June 1, 2023
Geocoding stops in mid way and shows "ScriptError: Service error: Google Maps".
Is this review helpful?
Yes
No
Profile Picture
Quinten Oustrup Laureijs
August 5, 2023
Just Works™.
Is this review helpful?
Yes
No
1-10 of 82
Search
Clear search
Close search
Google apps
Main menu