From this: |
To this: |
To validate addresses in an Excel spreadsheet, download YAddress Excel Add-in to your computer:
Once downloaded, open the spreadsheet in Excel, click "Run YAddress" button and follow the instructions.