Using the what3words for Google Sheets add-on
The what3words for Google Sheets add-on brings the functionality of the what3words API to Google Sheets. You can use the add-on to convert from coordinates to 3 word addresses or from 3 word addresses to coordinates using formulas within Google Sheets.
The add-on can be with Google Sheets in any browser.
Install the Add-In
To install the add-in, visit this page for what3words for Sheets in the Google Workspace Marketplace. You will need to be logged in with your Google account in order to install it.
Alternatively, you can install the add-in directly from a Google Sheet. If you have a Sheet open, select “Add-ons” from the top menu, followed by “Get add-ons”. You can then search for “what3words for Sheets” and install in the same way.
Configure Your Settings
Once installed, open any Google Sheet in a browser. From the top menu, select “Add-ons”, and here, you will see “what3words for Sheets”. From this, select “Settings” after you have enabled the add-on. You will then be prompted to log into your Google account, and you can enter your what3words API key.
When you have done this, you’ll be ready to start using the add-on!
Please note that what3words for Sheets’ use of information received from Google APIs adheres to the Google API Services User Data Policy including the Limited Use requirements.
If you shared your Google sheets containing your what3words addresses calculations to someone else, you will display an Error, as shown on this screenshot.
Currently it is only possible to use the Google Sheet add-on reliably if you are the owner of the sheet.