App Icon
Awesome Gapps
•  566,554
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
Jungsoo Park
January 12, 2021
very easy to use and intuitive. as it says, Awesome.
Is this review helpful?
Yes
No
Profile Picture
فهد الباحوث
December 16, 2020
Tanks
Is this review helpful?
Yes
No
Profile Picture
digi rea
December 8, 2020
This tool is amazing. The only issue that I have is, it is not able to Geocode new addresses or update the lat/long automatically. I have a system that imports the new addresses in new rows of the google sheet (~1hour by 1 hour) and I need to do Geocoding from the scratch manually every time by deleting the existing Lat/Long and running the code to update the Map. [Pls, correct me if I'm not using this in the right way!!]
Is this review helpful?
Yes
No
Profile Picture
Sascha Goetz
December 8, 2020
Super amazing app. Love it
Is this review helpful?
Yes
No
Profile Picture
Andrew Staples
December 6, 2020
Very handy tool for getting locations into a format GIS software can read.
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
November 30, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Dhirendra Kumar Prajapati
November 4, 2020
Earlier it was working well, but from past two days its keep on giving server error not sure what's happening.
Is this review helpful?
Yes
No
Profile Picture
Solar Utopia
November 2, 2020
Cant start geocoding, stuck in step 1
Is this review helpful?
Yes
No
Profile Picture
Brennan Marque
October 28, 2020
Its a really good application in certain areas. I feel its one of the best out there. Some sets are perfect some are skewed. overall its a quality application I use it often
Is this review helpful?
Yes
No
Profile Picture
Mindful Eyeam
September 18, 2020
It's good - but I messed up my spreadsheet and had o reload the address and then I got bounced out :/ Hopefully will be able to use it again
Is this review helpful?
Yes
No
1-10 of 57
Additional information
Awesome Gapps
Terms of Service
Search
Clear search
Close search
Google apps
Main menu