Drop a messy address spreadsheet into a folder and get a checked file ready for mail merge, plus a list of rejected rows with a reason for each.
Data Merge & Cleaning
Cross-sector
Scheduled worker
Productised
Local/private
2026
The problem
Suppliers send address lists in every casing and layout, with broken postcodes and empty lines. Before each mailout someone spent an afternoon tidying them by hand. Errors still reached print.
What it does
A background tool watches a folder. When a spreadsheet arrives, it checks UK postcodes, tidies capital letters and address lines, adds the country, and splits the rows into a clean file and a rejects file. It then moves the original to an archive folder so nothing is processed twice.
Outcomes
Mailout preparation drops from hours to seconds.
Every rejected row has a reason a non-technical person can fix.
Each run leaves an archived original and a log.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Address Datamerge Cleaner
1. Input
Click to load the sample supplier CSV
2. Progress
Load a file to start
Clean rows
0
Rejected
0
Time taken
0
sample_suppliers_clean.csv
Name
Address 1
Address 2
Town
Postcode
John Smith
12 High Street
Maidstone
ME14 1XX
Sarah O’Brien
Flat 3
47 Queen’s Road
London
SW1A 1AA
Brown & Co Ltd
Unit 5 The Old Mill
Riverside Park
Sevenoaks
TN13 1AB
Northgate Supplies Plc
PO Box 1234
Reading
RG1 8AA
Harriet Lowe
8 Church Walk
Ashford
TN23 1QQ
Arun Mehta
3 Mill Court
Kings Hill
West Malling
ME19 4AA
sample_suppliers_rejects.csv
Name
Postcode
Reason
(blank)
CT1 2EH
missing name
Mary-Jane Wilson
BAD POSTCODE
invalid postcode
Test Customer
W1A 1AA
missing address1
Peter Parker
NY10001
invalid postcode
Run history
Rows processed per day
File
Clean
Rejected
Status
spring_mailout.csv
482
23
done
trade_accounts.csv
251
9
done
show_leads_export.csv
0
0
bad encoding
How it works
A person, an email rule or another tool drops a spreadsheet into the input folder.
Match column headings whatever their capital letters, so supplier files do not need exact headings.
Trim each row, tidy its capital letters and check it against the UK postcode format.
Save valid rows to a clean file in the layout the print platform expects.
Send failures to a rejects file with a plain-English reason, and move the source file to a processed folder for audit.
Pipeline
flowchart LR
Input[Input folder] --> Match[Match columns]
Match --> Clean[Trim and title-case]
Clean --> Check{Valid postcode?}
Check -->|Yes| CleanCSV[Clean CSV]
Check -->|No| Rejects[Rejects CSV with reason]
CleanCSV --> Archive[Archive original]
Rejects --> Archive