Go to Awesome Table Contact us
Getting started
App types
Filters and
keywords
Templates
Embed apps
in your website
Go further with Awesome Table
Add-ons
Troubleshooting
Data security and policies
Billing

[Part 2] Geocode addresses

Avatar
Awesome Table
Updated
Follow

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 This article is only for Google users.

1. Initialize the Geocode add-on wizard

To start using Geocode, open an existing Google Sheets with postal addresses in it.  Run Geocode before adding any keywords or filters. From your data sheet, select Add-ons > Geocode by Awesome Table > Start Geocoding.

Image A

Screenshot_2020-04-23_at_16.15.04.png 

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-b_orig.png

Image C

image-c_orig.png
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

image-d_orig.png

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

image-e_1_orig.png

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.

Make sure that the Try wider results checkbox is checked:


try-wider-results-orig-orig-2_orig.png

 

3. Start Geocoding

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

Image F

image-f1_orig.png

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

image-g1_1_orig.png 

4. Create your interactive Map

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

Image H

image-g_orig.png

A new row is created on your datasource. This row is for filters and keywords  (image I). Geocode automatically generate your Awesome Table app using the Map visualization type.

Image I

Screenshot_2020-04-23_at_16.43.29.png

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

Read our filter article to know more. 

Geocoding phase: Complete.

You are now presented with the settings (optional) to: Customize the Tooltip or Open the Map app (image J). For now, choose Open map to see the default app. 

Image J

Screenshot_2020-04-22_at_15.08.55.png

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

Image K

geocode-plain-default-vanilla-tooltip_orig.png 

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

10 comments

Sort by Date Votes

Please sign in to leave a comment.

Articles in this section

Help us improve this documentation! Was this article helpful?
4 out of 6 found this helpful