Using the what3words for Excel add-in
The what3words for Excel add-in brings the functionality of the what3words API to Excel as part of Office 365. You can use the add-in to convert from coordinates to 3 word addresses or from 3 word addresses to coordinates using formulas within Microsoft Excel spreadsheets.
The add-in can be with recent versions of Excel for both Mac and Windows in addition to Excel via Windows 365 and Excel online.
You can download the add-in from the Office 365 store here.
Before you begin, you’ll need a what3words API key. If you don’t have one currently, you can register to get one here.
Once you have downloaded and installed the add-in, you will find a new what3words section under “Home” in your Excel toolbar. Here, you can set your API key and to begin using the add-in.
Please note – you may need to expand the “Home” section of your toolbar if you don’t see it initially!
There are several formulas you can use with the what3words for Excel add-on. Here, you can see the different options you have!
Convert to 3 word address
=W3W.CONVERTTO3WA(lat, long, lang)
To convert coordinates into the corresponding 3 word address, simply input the latitude and longitude as separate values and include the 2 digit ISO code for the language
=W3W.CONVERTTO3WA(51.5207944, -0.1973824, "en") will return the 3 word address
Convert to coordinates
To convert a 3 word address into the corresponding coordinates, simply input the 3 word address in the correct format (e.g. filled.count.soap) into this formula.
=W3W.CONVERTTOCOORD("filled.count.soap") will return the coordinates
Translate a 3 word address
With this formula, you can easily change the language of a 3 word address by having the 3 word address in question and the two letter code for the language as the input.
=W3W.LANGUAGECHANGE("index.home.raft", "de") will translate the 3 word address
///index.home.raft into German, and return the result
You can use this formula to return a result from the what3words AutoSuggest for an incomplete 3 word address. You just need to use the incomplete 3 word address up to the beginning of the third word along with the rank of the result you would like to return.
=W3W.AUTOSUGGEST("filled.count.so", 1) will return the first autosuggest result for the incomplete 3 word address
"filled.count.so". You can change the rank to return other autosuggest results.
Return AutoSuggest with focus
=W3W.AUTOSUGGESTFOCUS(“address”, rank, lat, long)
As with the previous formula, this allows you to return an AutoSuggest result for an incomplete 3 word address, but this time using coordinates formatted as latitude and longitude to specify a focus around which results will be centred.
=W3W.AUTOSUGGESTFOCUS("index.home.ra", 1, 51.520847, -0.195521) will return the first autosuggest result for the incomplete 3 word address
"index.home.ra" focused on the coordinates specified, which in this case would be
Return AutoSuggest with country clipping
=W3W.AUTOSUGGESTCOUNTRYCLIP(“address”, rank, “country”)
As with the previous, this allows you to return an AutoSuggest result for an incomplete 3 word address, but this time specifying a country within which results should be limited using the 2-digit country code.
=W3W.AUTOSUGGESTCOUNTRYCLIP("filled.count.so", 1, "GB") will return the first autosuggest result for the incomplete 3 word address
"filled.count.so", with results being limited to Great Britain only. You can specify the country you would like to clip to using the ISO 3166-1 alpha-2 country code.
If you have installed the what3words Add-in on your Excel Desktop and you see this issue, it could depend on which country and default system settings you have registered your Home Office.
In some instances also numbers had to be encased in quotes (not only strings) and the default separator is not always comma but it can be a semicolon e.g.:
=W3W.CONVERTTO3WA(51.5207944, -0.1973824, "en")
would in that case change to
=W3W.CONVERTTO3WA("51.5207944"; "-0.1973824"; "en")
How to uninstall the Excel Add-in
In case you wish to uninstall the what3words Excel Add-in, here are the steps to follow:
Click on Insert tab > My Add-ins > right-click on what3words for Excel > click on Remove.
Have any questions?
We’re here to support you! If you have any questions while using what3words for Excel, get in touch with us by writing us an email at firstname.lastname@example.org