The Excel plugin brings the functionality of the what3words API to Excel. You can use the add-in to convert from coordinates to 3 word addresses or from 3 word addresses to coordinates using formulas with Excel.
The Add-in can be used on both MacOS or Windows.
You will need a what3words API key to complete this tutorial.
Download the Excel Add-in here. Extract the zip file and open the installer file. You will need to enable macros when prompted.
Click “Install” and when prompted, add your API key. Excel will then restart to complete the installation.
Once the installation is complete the Add-in allows you to use formulas to convert between coordinates and 3 word addresses.
View our tutorial to see how to use the formulas of the Excel Add-in to convert between coordinates and 3 word addresses.
Adding coordinates to a spreadsheet is easy using the what3words Excel Add-in. Once installed, you can use a formula to call the API and display a column of coordinates. To install our Excel Add-in, watch our simple tutorial: https://developer.what3words.com/tutorial/installing-the-excel-add-in/