Data Cleansing and International Address Standards

In the digital age, data is a critical asset for any business. Clean, accurate data is essential for effective communication, streamlined operations, and enhanced customer experiences. Data cleansing involves detecting and correcting (or removing) corrupt or inaccurate records from a database. It ensures that your data is consistent, accurate, and useful. Integrating address lookup software into your data management practices is also essential for maintaining accurate and up-to-date address data.


Data cleansing can help in various ways:

  • Improved Accuracy: Ensures all data entries are correct and complete.
  • Enhanced Efficiency: Streamlines operations by eliminating errors and inconsistencies.
  • Better Decision-Making: Provides a reliable basis for analysis and strategy.
  • Cost Savings: Reduces the costs associated with incorrect data, such as returned mail or undeliverable shipments.
  • Customer Satisfaction: Enhances customer experience by ensuring accurate delivery information and personalised communications.


Using address lookup software can significantly enhance the accuracy and reliability of your data. This is especially important for businesses that handle large volumes of customer information and need to ensure that all addresses are correct and formatted properly.


 What is UPU S42 and Why Should You Care?


Now that we understand the importance of data cleansing, let's delve into UPU S42 and its relevance in this context.


First, what does UPU stand for? The Universal Postal Union (UPU) is the second oldest international organisation in the world, founded in 1874. (For context, the oldest is the International Telecommunications Union, founded in 1865.) With 192 member countries, the UPU’s mission is to bring standardised and efficient postal systems to countries around the world. The organisation helps member countries develop and implement addressing standards and grow their mail, parcel delivery, and financial services. The UPU acts as a forum for international discussion and collaboration in the postal sector.


UPU S42 is the international addressing standard developed by the UPU’s Postal Operations Council and experts from its Addressing Group. It breaks down postal addresses into the generic component parts commonly used by all UPU member countries:

GIVEN NAME > SURNAME > STREET NUMBER > STREET NAME > STREET TYPE > FLOOR > TOWN > REGION > POSTCODE > COUNTRY


The second section of UPU S42 provides templates of how these components are arranged according to the standards of each country. With over 200 different addressing systems in the world, this database is vital as it provides a framework by which international shipments can be efficiently processed.


Implementing UPU S42 standards in data cleansing solutions ensures that addresses in customer databases are not only validated but also reformatted, where necessary, to the precise standards of their country.


A simple example is addresses in Germany, where the street number generally comes after the street name. If someone in the UK types in a German address, they may use their local form and place the street number first. After data cleansing, the address will be formatted in the standard format for Germany.


Locally formatted address:
Hienz Wolff
167A Königstraße
Berlin
14109


Standardised address for Germany:
Hienz Wolff
Königstraße 167A
Berlin
14109

 

Why is this important? 

 

Collecting data in your chosen format, likely the standard format of your country’s address system, might result in technically valid but improperly ordered data for the destination country, potentially causing delivery delays.


Data cleansing verifies the format of every address as an automatic step in data processing systems. This is particularly vital for logistics and fulfilment companies that do not capture address data directly from customers but receive orders via retailers. Validating address data and ensuring the correct format for the destination country streamlines shipments and reduces lost or delayed deliveries.

The Fetchify difference 

 

We process millions of data transactions weekly for thousands of clients, from small e-commerce start-ups to large household brands such as LG, Heinz and RBS. Our flagship products, Address Lookup and UK Postcode Lookup, reduce friction on checkouts, leading to increases in conversion rates, and help to reduce failed deliveries and customer frustration. 


Our address lookup software is designed to integrate seamlessly with your business systems, ensuring accurate and up-to-date address data. We are proud to offer fit-for-purpose plug-and-play integrations with most leading business software platforms. We enjoy global coverage in over 250 countries, with businesses from various industries benefitting from our address finder offering.


Accurate address data is essential for smooth business operations, and our address lookup software makes this achievable. Get in Touch and experience the Fetchify difference – like thousands of e-commerce businesses around the globe.

About Fetchify


Fetchify’s address lookup and data validation platforms cover more than 250 countries, and increases customer conversion with the fastest, most accurate customer data capture. Fetchify’s flagship products – Address Auto Complete and Postcode Lookup – reduce friction at the checkout, and also significantly increase the number of successful deliveries. Founded in 2008, Fetchify processes millions of data transactions every day for clients ranging from startups to established high-street names, and offers a full suite of data validation tools, including phone, email and bank, too.

Photo of fields and countryside with Fetchify traditional, postal and ceremonial counties
By Fiona Paton October 27, 2025
Counties are one of those quiet curiosities of UK addressing - the kind of data field that often sparks more debate than you’d expect. Should they be included? Which kind? And do we even need them anymore? As with so many things in data, the answer is: it depends. Three Counties, One Country In the UK, the word “county” doesn’t describe one single thing. It describes at least three - each with its own history, purpose, and quirk: Postal counties were once the backbone of the Royal Mail’s sorting system. They helped machines (and people) get mail to the right place efficiently. But in 1996, Royal Mail officially dropped them, and by 2010, county data was removed from the official address dataset entirely. For the postal system, counties simply no longer exist. Traditional (or historic) counties trace their origins back centuries — the counties of record, land, and local identity. They don’t match today’s administrative borders, but they persist in cultural memory and local pride. To some, these are the real counties of England. Ceremonial counties , meanwhile, are what most modern maps and local authorities recognise today. They loosely align with lieutenancy areas — the basis for everything from local government to BBC weather maps. And just to add another layer, the UK also has metropolitan and non-metropolitan counties used for administration, because nothing in British geography would be complete without a little complexity. So… Do We Still Need Them? For Royal Mail, the answer is simple: no. County names are ignored by modern sorting systems, and they don’t affect delivery. But in the real world of databases, integrations, and overlapping address systems, the answer is less clear-cut. Counties still appear because: Some legacy systems require a county field for validation. Some organisations and couriers still use them for regional routing. And sometimes, humans just like them — they help people orient themselves, especially in places with duplicate town names. It’s a reminder that addresses aren’t just for machines. They’re for people, too — and people often bring context, emotion, and memory into their sense of “place.” The Bigger Picture: One World, Many Formats  Counties are just one example of how geography, history, and technology collide in addressing. Every country — sometimes every region — does it differently. Some use regions, provinces, or prefectures. Some rely on hierarchies of towns and municipalities. Others have no subdivisions at all. For global platforms and data validation providers, that diversity creates a fascinating challenge: how do you standardise something that isn’t standard anywhere? It’s the quiet work of address intelligence — understanding not just where something is, but how people describe it. Why This Matters The goal of address accuracy isn’t to erase local identity or force uniformity; it’s to understand and support variation intelligently. Whether you’re sending a parcel, mapping customer data, or building systems that work across borders, knowing how and why these differences exist is part of getting the data right. So next time you’re faced with that little “County” field — think of it not as a relic, but as a reminder. Behind every address is a history, a structure, and a story. And understanding that story is where true data quality begins.
A man with glasses in his office is looking at his laptop with excitement.
By Fiona Paton October 27, 2025
Fetchify is delighted to announce that we have enhanced our product portfolio with the launch of our data cleansing services designed to help companies remain compliant with the General Data Protection Regulation (GDPR), maintain accurate customer addresses, and limit financial and reputational losses resulting from lost parcels. Royal Mail’s Postcode Address File (PAF) sees over 1,000,000 changes to address data each year. Against the backdrop of GDPR regulations, which stipulate that customer data must be kept up to date, there is increasing pressure on organisations to maintain an accurate picture of their customer database at all times. Businesses failing to comply face fines of up to £17.5 million or four per cent of global annual turnover. Furthermore, with UK businesses losing an estimated £1.6 billion each year due to lost or undelivered parcels, and 50 per cent of customers abandoning a brand after one poor delivery experience, the stakes are increasingly high when it comes to maintaining accurate address details. Data Cleansing tackles this by checking the addresses companies have on file against the PAF, ensuring that every matched address is complete. Not only does the report help businesses maintain accurate records continually, but it also fills in missing details, such as street information and postcodes, and standardises entries to Royal Mail’s specific formatting. Fetchify’s latest service is expected to help retailers stay on top of their GDPR obligations, minimise failed deliveries, cut returns costs, and improve the customer experience. John Griffiths, Account Manager at Fetchify, comments: “Duplicate records cause confusion, missing data undermines marketing efforts, and incorrect formats lead to delivery and communication errors. Perhaps more compelling is the fact that businesses are legally required to maintain accurate details, so it’s imperative that they get it right. Data Cleansing will address all of these issues whilst streamlining the operational efficiency of companies that use it.”
Tracey is sitting in an office environment
By Fiona Paton September 8, 2025
A spotlight on Tracey Moir, Senior Business Development Manager at Fetchify
Showroom display of a range of prams for sale at Winstanleys Pramworld
By Fiona Paton September 1, 2025
“We’ve stayed with Fetchify for over 12 years because their UK Postcode Lookup service has consistently delivered on reliability. The ease of integration, straightforward testing, and the support of a dedicated account manager have all contributed to a seamless experience that continues to meet our needs.” – David Winstanley, Director at Winstanleys Pramworld
Show More