--- title: "A New Addition to the Cleanse Family: Microsoft Excel" description: Validate UK addresses directly in Microsoft Excel. The new Address Cleanse add-in returns formatted addresses, UPRNs, and geocodes in your workbook. image: https://blog.ideal-postcodes.co.uk/hubfs/excel-cleanse-selection-screenshot.png --- [![logo-white](https://blog.ideal-postcodes.co.uk/hs-fs/hubfs/logo-white.png?width=220&height=37&name=logo-white.png "logo-white")](https://ideal-postcodes.co.uk) [![Ideal Postcodes Logo](https://blog.ideal-postcodes.co.uk/hs-fs/hubfs/logo-inverted.png?width=2154&height=361&name=logo-inverted.png "Ideal Postcodes Logo")](https://ideal-postcodes.co.uk) - [Blog](https://blog.ideal-postcodes.co.uk/) - [Pricing](https://ideal-postcodes.co.uk/pricing) - Products - [Address Finder](https://ideal-postcodes.co.uk/address-finder) - [Postcode Lookup](https://ideal-postcodes.co.uk/postcode-lookup) - [Address Cleansing](https://ideal-postcodes.co.uk/address-cleanse) - [Address Database](https://ideal-postcodes.co.uk/address-database) - [Geocoding](https://ideal-postcodes.co.uk/geocoding) - [UPRN](https://ideal-postcodes.co.uk/uprn) - [Support](https://ideal-postcodes.co.uk/support) - [Documentation](https://docs.ideal-postcodes.co.uk/) - [Dashboard](https://ideal-postcodes.co.uk/account) # A New Addition to the Cleanse Family: Microsoft Excel Validate and enrich UK addresses directly in your spreadsheet  ![hero-jobbies-7](https://f.hubspotusercontent00.net/hubfs/395201/hero-jobbies-7.svg) [Doaa Kurdi](https://blog.ideal-postcodes.co.uk/author/doaa-kurdi) Jun 8, 2026, 9:08:56 AM > Validate and enrich UK addresses directly in your spreadsheet  *![excel-cleanse-selection-screenshot](https://blog.ideal-postcodes.co.uk/hs-fs/hubfs/excel-cleanse-selection-screenshot.png?width=653&height=361&name=excel-cleanse-selection-screenshot.png)* Address data moves between systems, teams, and file formats, and the work of cleaning it up tends to happen wherever the person responsible feels most comfortable. That pattern has shaped how we have built our cleanse products over the years. The newest addition to that family is an Address Cleanse add-in for Microsoft Excel, which validates and enriches UK address data. ## Our Cleanse solutions Our [Cleanse API](https://docs.ideal-postcodes.co.uk/docs/api/address-cleanse) is the option teams reach for when they want to build address cleansing directly into their own systems. [Bulk Cleanse](https://ideal-postcodes.co.uk/contact-us) handles larger, one-off database jobs where it helps to have our team involved. [ClickCleanse](https://cleanse.ideal-postcodes.co.uk/) covers the in-between case, where someone has a CSV, a browser, and up to 1,100 addresses to clean in one sitting. The Excel add-in extends the same service into the workbook itself and has no limit to the number of rows you can cleanse. ## Why Excel deserved its own integration A lot of address work still happens in spreadsheets, particularly in operations, finance, and customer service teams. These are often the people closest to the data and the least likely to have a developer on hand to help with an API. Until now, cleansing a spreadsheet of addresses meant exporting the file to a different tool, running it through, and reimporting the results. The Excel add-in removes that round trip.   ### Features The add-in calls the same underlying Cleanse service as our other products, so the data quality and sources are consistent across the solutions. Once installed, a **Cleanse** button appears on the Home ribbon and opens a task pane on the right. From there, you can: - Select a column of addresses and run **Cleanse Selection**, which writes 31 columns of structured results immediately to the right of your input - Optionally select two columns, with the second used as a postcode hint to help disambiguate matches - Use **Write Headers** to drop labelled column headings above your data   ### Data returned Each cleansed row returns 31 columns of structured data, including: - **Formatted address fields**: address lines, town, postcode, and country, standardised against Royal Mail's Postcode Address File - **Confidence score** and overall **fit indicator** showing how reliable each match is - **Per-element match levels** for organisation, premise, street, locality, town, and postcode - **UPRN and UDPRN**, included at no extra cost - **Rooftop-accurate geocodes** (latitude, longitude, eastings, northings), also included at no extra cost - **Administrative data** such as district, ward, and county The [address cleanse guide](https://ideal-postcodes.co.uk/guides/address-cleanse) covers what each field means in more detail. Results are written as plain values rather than live formulas, so the workbook can be saved, shared, and reopened by anyone without the add-in or an API key. A teammate reviewing the file later does not need to install anything to read the results. ## Try it and let us know what you think The add-in works in Excel for the Web, Excel for Windows, and Excel for Mac. The [installation guide](https://docs.ideal-postcodes.co.uk/docs/integrations/excel) walks through the setup steps. New accounts include free test credits. We would also welcome your feedback. If something could work better for the way your team handles address data, please get in touch at [support@ideal-postcodes.co.uk](mailto:support@ideal-postcodes.co.uk).       [Address Cleansing](https://blog.ideal-postcodes.co.uk/tag/address-cleansing), [Blog](https://blog.ideal-postcodes.co.uk/tag/blog) ## Read On ### [What Is Dirty Data and What Can You Do About It? > Data decays by 20% per year. Correct, organise, and format your customer addresses with Address...](https://blog.ideal-postcodes.co.uk/blog/dirty-data-address-cleansing) ### [How to Add Address Finder to a Base44 App in Minutes > Give your Base44 forms reliable UK and international addresses](https://blog.ideal-postcodes.co.uk/how-to-add-address-finder-to-a-base44-app-in-minutes) ### [Eircode Address Validation > We’re pleased to announce that we have added Eircode data to our address validation solutions....](https://blog.ideal-postcodes.co.uk/eircode-address-validation) [![logo](https://blog.ideal-postcodes.co.uk/hs-fs/hubfs/logo.png?width=300&height=49&name=logo.png "logo")](https://www.ideal-postcodes.co.uk) International House, 24 Holborn Viaduct London, EC1A 2BN [Follow us on Facebook](https://www.facebook.com/idealpostcodes/) [Follow us on LinkedIn](https://www.linkedin.com/showcase/ideal-postcodes) [Follow us on Twitter](https://twitter.com/IdealPostcodes) [Follow us on Instagram](https://www.instagram.com/idealpostcodes/) ### Products - [Address Finder](https://ideal-postcodes.co.uk/address-finder) - [Postcode Lookup](https://ideal-postcodes.co.uk/postcode-lookup) - [Address Cleansing](https://ideal-postcodes.co.uk/address-cleanse) - [Address Database](https://ideal-postcodes.co.uk/address-database) - [Geocoding](https://ideal-postcodes.co.uk/geocoding) - [UPRN](https://ideal-postcodes.co.uk/uprn) ### Products - [Ideal Postcodes](https://ideal-postcodes.co.uk/) - [Contact](https://ideal-postcodes.co.uk/support) ### Products - [Documentation](https://docs.ideal-postcodes.co.uk/) - [Guides](https://ideal-postcodes.co.uk/guides) Copyright © Ideal Postcodes 2021. All Rights Reserved. | [Privacy Policy](https://ideal-postcodes.co.uk/privacy_policy) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Doaa Kurdi", "url" : "https://blog.ideal-postcodes.co.uk/author/doaa-kurdi" }, "dateModified" : "2026-06-08T08:09:05.148Z", "datePublished" : "2026-06-08T08:08:56.000Z", "headline" : "A New Addition to the Cleanse Family: Microsoft Excel", "image" : [ "https://blog.ideal-postcodes.co.uk/hubfs/excel-cleanse-selection-screenshot.png" ], "mainEntityOfPage" : { "@id" : "https://blog.ideal-postcodes.co.uk/address-cleanse-microsoft-excel", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.ideal-postcodes.co.uk/hubfs/logo-inverted.png" }, "name" : "IDDQD Limited" } } ```