1 - Install the add on
In your spreadsheet, go to "Add-ons" > "Get Add-ons".
In the add-ons pop-up:
- Type "Geocode" in the search bar (1)
- Click "Free" for Geocode by Awesome Table (2) to install the add-on.
2 - Geocode addresses
Once the GeoCode add-on is installed, you will learn how to retrieve the coordinates of physical addresses.
Click Add-ons > Geocode by Awesome Table > Start Geocoding:
With the correct sheet and column selected in the sidebar menu wizard, click "Geocode!". The latitude & longitude data will automatically be generated on new columns (duration will depend on the number of rows or records that you have).
Now that your datasheet has the appropriate coordinates to all of your addresses, you will learn how to use these GeoCodes to create an Awesome Table map in the next tutorial.