About Services Tools Blog Contact us

Address List Cleaner

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

Run history

Rows processed per day
FileCleanRejectedStatus
spring_mailout.csv48223done
trade_accounts.csv2519done
show_leads_export.csv00bad encoding

How it works

  1. A person, an email rule or another tool drops a spreadsheet into the input folder.
  2. Match column headings whatever their capital letters, so supplier files do not need exact headings.
  3. Trim each row, tidy its capital letters and check it against the UK postcode format.
  4. Save valid rows to a clean file in the layout the print platform expects.
  5. 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