[Part 2] Geocode addresses – Documentation - Awesome Table Support

In the previous tutorial, you learned how to install GeoCode. Here, you'll learn how to use the GeoCode add-on to transform postal addresses into coordinates.

info To immerse yourself in this tutorial, we recommend using this sample data in the following walk-through exercises.

1 - Initialize the GeoCode add-on wizard.

To start using GeoCode, open an existing Google Sheets with postal addresses in it. Once you're on the pertinent sheet (tab), select Add-ons > Geocode by Awesome Table > Start Geocoding.

Image A

info Depending on your use-case, you're not restricted to using just the complete postal address for GeoCode to work. You can even enter partial addresses using any of these combinations: city and state, city or state and country or just the country.

2 - Configure the address field.

If the complete address is stored in just 1 column, choose the appropriate column name from the dropdown menu under Address column (image B). Otherwise, click Are your addresses in multiple columns? (image C).

Image B

Image C

The Multiple Columns window shows the column names on the left and checkboxes on the right. You simply need to check the boxes where your separate address fields are stored (image D). Then click the Insert column button.

Image D

This will create a new column labeled Full Address right next to the country column - containing the concatenated values of the address fields you checked earlier (image E).

Image E

info Google Maps API has a built-in error management system. If addresses are not recognized, it will perform a broader search, guaranteeing you get the proper coordinates for each row.

* Note: Make sure that the Try wider results checkbox is checked.

3 - Start Geocoding.

Now click the Geocode! button (image F) to transform your addresses into coordinates.

Image F

not_interested Do not terminate or close the sidebar while GeoCode is running.

After the script executes, two new columns will be added immediately after the Address column: Latitude and Longitude (image G) .

Image G

info If you prefer not to have the longitude and latitude columns inserted between your datasource (to avoid altering your current column-order), simply place the address column(s) at the end of the datasource.

warning Information about the number of geocoded addresses is displayed in the sidebar (image G).

4 - Create your interactive Map with just 1 click.

Finally, click the Create Map button (image H).

Image H

The script will 1) insert a new row on your datasource that will be reserved for filters and keywords (image I) and 2) automatically generate your AwesomeTable view using the Map visualization type.

Image I

info The GeoCode script applies the appropriate filter based on the data-type of each column (i.e., numeric, string, or date). You can opt to accept the suggested filters, modify, or remove them.

Learn more about filters here.

warning The GeoCode add-on offers a pre-configured AwesomeTable Map-view allowing you to quickly sort, filter, and find the locations you need. If you click on a specific row in the table-view, the map-view will dynamically focus the corresponding marker-location linked to the pertinent row.

Geocoding phase: Complete.

You're now presented with the option to: Customize the Tooltip (which we'll tackle next) or Open the Map view (image J). For now, choose Open map to see the default view.

Image J

When you click on any marker, you'll be presented with a plain-vanilla tooltip displaying the city & country (image K). You can choose to accept this default or you could further customize your Tooltip to enhance it.

Image K

warning The generated map-view displays Markers (a single location on a map that resembles a red balloon, a.k.a. Map Pin, Drop Pin, or Push Pin) corresponding to each coordinate in your Google Sheets datasource.

info If there are too many markers in a single location, the GeoCode script performs automatic clustering to improve the map view (image L).

Image L

navigate_nextNext article :

In this tutorial, you learned how to use the GeoCode add-on to transform your addresses into coordinates.
In the next tutorial, you'll learn how to Customize the Tooltip.

Comments

6 comments

Francisca Benitez July 30, 2019 20:51

Hi! I love this feature. Is there a way to change the color of map clusters?

0

Comment actions Permalink
Randolph Abelardo July 30, 2019 23:14 (Edited July 30, 2019 23:21)

Hi @Francisca.

The Google Maps Marker Clusters are image-based. It's currently not possible to change the colors.

- Randy

0

Comment actions Permalink
Francisca Benitez July 31, 2019 21:52

Hi Randy, thanks for your response! Is it possible to change the image? I've been trying different options, but nothing has worked so far.

Thanks again!

0

Comment actions Permalink
Randolph Abelardo August 10, 2019 06:12

Hi @Francisca.

I'm not aware if this is possible.

0

Comment actions Permalink
Cesar Rodrigo October 21, 2019 02:11

how many addresses data i can do at the same time ?

0

Comment actions Permalink
Randolph Abelardo October 21, 2019 12:37

Hi @Cesar.

You can learn more about the quota here.

- Randy

0

Comment actions Permalink

Please sign in to leave a comment.

1 - Initialize the GeoCode add-on wizard.

2 - Configure the address field.

3 - Start Geocoding.

4 - Create your interactive Map with just 1 click.

Geocoding phase: Complete.

Articles in this section