Geocode addresses in Google Sheets

You can use Awesome Table Connectors to convert addresses into geographic coordinates (latitude and longitude) through a process called geocoding, and conversely, through reverse geocoding. Geocoding a list of addresses can be useful if you want to locate them on a map.

This article demonstrates how to use the Google Maps Geocode connector to convert a list of addresses into geographic coordinates, all from a Google spreadsheet.

Prerequisites

You have logged in with the Awesome Table Google Maps Geocode connector.

1. Open the Select data drop-down, then click Geocode.

   

   The Address column dropdown appears and lists the columns from the current sheet.

   note

   Awesome Table only displays columns that contain data.

2. Select the Address column you want to convert into geographic coordinates.

   
   note

   If your spreadsheet is empty, Awesome Table prompts you to populate it with sample data.

   

3. Click Geocode to start converting the list of addresses.

You have successfully converted the list of addresses into geographic coordinates in Google Sheets. Successful requests are automatically saved and displayed in the Home screen.

What's next

• You can schedule a Refresh to automatically convert additional addresses into geographic coordinates.
• You can plot these locations on a Maps app for an interactive and dynamic experience.