Geocoding your addressed data

This a quickstart guide for geocoding (getting latitude & longitude values) your data

1) To display locations without latitude and longitude values.  Scroll to the right of your sheet until you see the Latitude & longitude columns and then select the small options triangle in the upper right of the latitude label.  Check the (Blanks) value and then press the OK Button to display locations without  lat /longs.



2) To start the geocoding process.  From the menu bar select Add-ons and then select Geocode by Awesome Table then select Start Geocoding. 


3) WTF


4) And then


5) And then here is the final results

Using Awesome Table in a spreadsheet Column Headings;