Developer

All tutorials

Using the what3words for Google Sheets add-on

easy

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.

1Get an API Key
Signup to create key
2Install 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.

3Configure 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!

4Privacy

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.

5Troubleshooting

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.

If you encounter errors or issues related to convert-to-coordinate requests while using the Free plan, please check the network panel for the following error message Error 402 payment required and its response, indicating the need to upgrade to a higher plan:

{
    "error": {
        "code": "QuotaExceeded",
        "message": "Quota Exceeded. Please upgrade your usage plan, or contact support@what3words.com"
    }
}
Copied

For more information, visit our API plans page. If you need further assistance, contact support@what3words.com.

SpreadsheetUse 3 word addresses in a spreadsheetGoogle Sheets

Related tutorials