Using multiple columns for Geocoding with a Location template

posted Sep 5, 2017, 7:37 PM by Faustino Rodriguez [ updated Sep 6, 2017, 1:25 PM ]

In most cases, you might have the full address for Geocoding under a single column, like showing below

Address

100 City Centre Dr, Mississauga, L5B 2C9, Canada

In those cases you only need to select the column Address as the Location, in the sidebar (partial screenshot below)

However, it might be the case you have the full address split across several columns, like showing below for the same place

Address

City

Postcode

100 City Centre Dr

Mississauga

L5B 2C9

In that case you can combine several columns and even include some static content, instead of just using the column Address.

You can try as follow, using the same headers example

1. Select the column Address as the Location as you did before
2. 
   
3. Select Preferences from the 3-dot menu in the sidebar and then select the Document option from the menu

1. 
   
2. Finally create the Location template there to combine the headers Address, City and Postcode, also adding the country Canada (assuming all the locations are in the same country), as follow:
3. {{Address}}, {{City}}, {{Postcode}}, Canada

1. 
   
2. The text between {{ }} could be any of the headers in your Sheet
4. When building a new map, this template will produce an address for Geocoding matching the full address (e.g. 100 City Centre Dr, Mississauga, L5B 2C9, Canada)

Please, try this feature first with a few rows of data, until you get the desired results, to avoid unneeded calls to the Google Geocoding service