Geocode by Awesome Table - Google Workspace Marketplace

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.

By:

Listing updated:January 10, 2023

Works with:

1,682,584

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

Support

ReportFlag as inappropriate

Reviews

Language:

Sort by:

Google doesn't verify reviews or ratings. Learn more about reviews

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

Adrian Mogosanu

November 4, 2022

A great tool to convert from locations/addresses to coordinates.

Is this review helpful?

Yes

Meghan Aines

May 17, 2022

This just saved me so many hours of work thank you so much for making this

Is this review helpful?

Yes

Winkert Khut

August 18, 2022

It overwrites the whole sheets to the first line of address... and everything became rubbish

Is this review helpful?

Yes

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

Tania Houston

October 13, 2022

Fantastic - so useful

Is this review helpful?

Yes

John Lynham

February 9, 2023

It works!

Is this review helpful?

Yes

Deshka Neill

February 15, 2022

struggled with a formatting issue so emailed support and they got back to me within the hour and solved my issue that i had been messing with for a day. STOKED!

Is this review helpful?

Yes

Nathan Smith

June 30, 2021

Seemed to work fine. Then I got an error saying that I invoked the service too many times for one day. What a load. Why is there an arbitrary limit on how many times this can be used?

Is this review helpful?

Yes

Vinubalan Krishnasamy

January 28, 2022

Works perfect..Thank you guys

Is this review helpful?

Yes

1-10 of 73

Clear search

Close search

Google apps

Main menu