Awesome Gapps
•  385,932
Overview
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.
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)
Reviews
Language:
Sort by:
Profile Picture
A User of Geocode by Awesome Table
July 7, 2020
Any idea how to create the range slider filter?
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
June 30, 2020
Premium version we can use for more than 1000 queries per day?
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
June 28, 2020
I will react when check-it-out the navigation of Goecode
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
June 27, 2020
Works like a Magic ! as I don't know the gs code and API behind it but the result and procedure are super easy and straight, Thanks to the Author.
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
June 24, 2020
Super easy to use! Was able to geocode all of my addresses quickly and easily.
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
May 29, 2020
What is that? ScriptError: Service invoked too many times for one day: geocode.??
Is this review helpful?
Yes
No
Profile Pciture
A user of Geocode by Awesome Table
June 30, 2020
Try next day. I think, that is 1000 addresses per day
Profile Picture
A User of Geocode by Awesome Table
May 26, 2020
Why did it show me that? ScriptError: Service invoked too many times for one day: geocode.
Is this review helpful?
Yes
No
Profile Pciture
A user of Geocode by Awesome Table
June 30, 2020
Try next day. I think, that is 1000 addresses per day
Profile Pciture
A user of Geocode by Awesome Table
June 10, 2020
You are allotted 1000 addresses per day
Profile Picture
A User of Geocode by Awesome Table
May 22, 2020
HI, i've been using it for a while, but now it seems to have a glitch where some of address is miss place and group at single lat long
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
May 11, 2020
It's free and it's working like a charm. I'm very happy with this tool.
Is this review helpful?
Yes
No
Profile Picture
A User of Geocode by Awesome Table
May 4, 2020
how to find address via longitude and latitude
Is this review helpful?
Yes
No
1-10 of 44
Additional information
Awesome Gapps
Terms of Service
Search
Clear search
Close search
Google apps
Main menu