Ideal Postcodes
All updates

Address Cleanse Add-in for Microsoft Excel

Cleanse, verify, and enrich UK addresses without leaving Excel. The new Address Cleanse add-in matches your addresses against the Royal Mail Postcode Address File: drag-select the address column, click Cleanse, and corrected addresses with UPRNs and geocodes are written alongside your data. No exports, no code.

Details

  • Cleanse in place: Select one column of freeform addresses, or two columns with a postcode hint, and results are written immediately to the right
  • 31 columns per row: Status, formatted address, confidence and fit scores, per-element match levels, geocodes, UPRN, UDPRN, and country data
  • Static values: Results persist in the workbook, so it can be shared and reopened by anyone without the add-in or an API key
  • All Microsoft 365 platforms: Works in Excel for Windows, Excel for Mac, and Excel for the web
  • Key kept private: Your API key is held in Office storage, never in cells or files

Follow the install guide to get started; an AppSource listing is on its way.