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.
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.
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).
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.
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).
* 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.
After the script executes, two new columns will be added immediately after the Address column: Latitude and Longitude (image G) .
4 - Create your interactive Map with just 1 click.
Finally, click the Create Map button (image H).
Learn more about filters here.
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.
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.
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.