Address to Coordinates: Latitude & Longitude
This add-on writes the latitude and longitude of a column of addresses in Google Sheets™, from any country, using the geocoder Google™ builds into Sheets scripts. It also works the other way round: two columns of coordinates become addresses. It is free: 1,000 addresses a day on personal accounts and 10,000 on Google Workspace™ accounts, with no API key and no account to create.
Install it from the Google Workspace Marketplace™, or from Extensions › Add-ons › Get add-ons inside Google Sheets™.
How to use it
- Select the cells with your addresses (one column). The two columns to the right must be empty: that is where the coordinates go.
- Open the Extensions menu, find Address to Coordinates and choose Get latitude and longitude, or Get latitude, longitude and matched address to also write the address Google recognised in a third column.
- For the reverse, select two columns (latitude, longitude) and choose Get address from coordinates. Ctrl+Z (Cmd+Z on Mac) takes it all back.
What it takes care of
- Rows that already have both coordinates are left alone, so you can run it again after adding addresses.
- Addresses that cannot be found stay empty and are counted in the final message.
- Results follow the language and region of your Google™ account, so local addresses resolve well.
- Up to 1,500 addresses per run; long runs save their progress every few rows, and the add-on stops with a clear message if Google's daily limit or the time limit is reached.
Languages
The menus and messages follow the language of your Google account: English, Spanish, Portuguese, French, German and Italian. Any other language shows English.
Questions
Where do the coordinates come from, and where do my addresses go?
Each address is sent to the geocoder that Google™ builds into Google Sheets™ scripts, the same engine behind Google Maps™. Nothing else leaves your spreadsheet: no servers of ours, no tracking. See the privacy policy.
Each address is sent to the geocoder that Google™ builds into Google Sheets™ scripts, the same engine behind Google Maps™. Nothing else leaves your spreadsheet: no servers of ours, no tracking. See the privacy policy.
How many addresses can I do?
Google™ allows 1,000 geocoding calls per day for personal accounts and 10,000 for Google Workspace™ accounts. When the limit is reached the add-on stops, keeps the rows it has done and tells you; run it again the next day and it continues where it stopped.
Google™ allows 1,000 geocoding calls per day for personal accounts and 10,000 for Google Workspace™ accounts. When the limit is reached the add-on stops, keeps the rows it has done and tells you; run it again the next day and it continues where it stopped.
Does it work with addresses from my country?
Yes: street addresses, postcodes, cities and place names from any country Google Maps™ covers. Writing the city and country in the cell helps with ambiguous street names.
Yes: street addresses, postcodes, cities and place names from any country Google Maps™ covers. Writing the city and country in the cell helps with ambiguous street names.
Can I undo?
Yes. Ctrl+Z (Cmd+Z on Mac) puts the previous values back.
Yes. Ctrl+Z (Cmd+Z on Mac) puts the previous values back.
Does it work in the mobile app?
No. Google Sheets™ add-ons run in the web version only.
No. Google Sheets™ add-ons run in the web version only.
Anything else: support@singletasktools.com.