Are you overwhelmed by the task of converting a large list of addresses into latitude and longitude coordinates? Don’t worry! In this tutorial, I will guide you step by step through the process of using Google Sheets and an add-on called “Geocode by Awesome Table” to achieve this effortlessly. Let’s dive in!

Step 1: Prepare Your Google Sheet

First, you need to create a new Google Sheet and paste all your addresses into it. Here’s how:

1. Open Google Sheets.
2. Create a new sheet.
3. Copy your addresses and paste them into the first column of the new sheet.

Step 2: Install the Geocode by Awesome Table Add-on

Next, you’ll need to install the necessary add-on to perform the geocoding:

1. Go to the Extensions menu in Google Sheets.
2. Select Add-ons and then Get add-ons.
3. In the search bar, type geocode.
4. Find and select Geocode by Awesome Table.
5. Click on Install and follow the prompts to allow access.

Step 3: Start the Geocoding Process

Now that you have the add-on installed, it’s time to start geocoding your addresses:

1. Go back to the Extensions menu.
2. Select Geocode by Awesome Table and then click on Start geocoding.
3. Ensure the address column is selected, then click on Geocode.

 

Step 4: Review Your Latitude and Longitude

The add-on will create two new columns in your sheet, one for latitude and one for longitude. Once it’s finished, you can review the coordinates generated:

1. Check the newly created columns for the latitude and longitude values corresponding to each address.
2. If you want to verify the accuracy, you can copy any address and paste it into Google Maps to see the coordinates.

Step 5: Combine Latitude and Longitude into One Column (Optional)

If you need to have both latitude and longitude in a single column, you can easily do this using the CONCATENATE function:

1. Create a new column for the combined data.
2. Use the formula =CONCATENATE(A1, ", ", B1), where A1 is the latitude and B1 is the longitude.

Conclusion

And that’s it! You now have all your addresses converted into latitude and longitude coordinates, and you can even combine them into a single column if needed. This method is quick and efficient, making it easy to handle large lists of addresses. Thank you for following along, and happy geocoding!