Choose the rule.
Remove exact duplicates, or match on a column like email. Combine keys for account and SKU exports.
YOUR DATA STAYS ON YOUR MACHINE
A small, offline toolkit for recurring customer and operations exports. Find duplicates, flag conflicts, and repeat your cleanup next week—with every row accounted for.
Python 3.9+ · terminal required · no subscription
| Record | Finding | Destination |
|---|---|---|
| 003 | Same email, new values | duplicates.csv |
| 004 | Missing email | review.csv |
Fictional sample data. The report is generated by the included tool.
Remove exact duplicates, or match on a column like email. Combine keys for account and SKU exports.
Keep conflicting values and missing-key records visible. Every whitespace change has a before and after.
Save the recipe. Apply the same rules to the next export without rebuilding your cleanup process.
ONE DOWNLOAD. A COMPLETE WORKFLOW.
The package includes the Python source, 11 regression tests, a step-by-step guide, fictional sample data, expected output and a reusable recipe.
No packages to install. No API keys. No uploaded customer data. Use it for your own commercial work and for client exports.
python3 cleanroom.py customers.csv \ --out reviewed-customers \ --key email --trim --casefold-keyRead the full guide before buying clean.csvThe first record for every distinct key.
duplicates.csvEvery duplicate and conflicting record, with its source row.
review.csvRows with missing keys, kept apart for your decision.
changes.csvA before-and-after log of every trimmed cell.
report.htmlA readable summary that accounts for every input row.
recipe.jsonThe same cleanup rules, ready for your next export.
Also includes spreadsheet-view copies and a machine-readable summary with the source fingerprint.
BEFORE YOU BUY
Requires Python 3.9+ and basic terminal familiarity. UTF-8 CSV files up to 50 MB, subject to available memory. Tested on macOS; Windows and Linux have not been independently tested.
This is a command-line toolkit. It does not support XLSX, fuzzy matching, email verification or automatic conflict resolution. The first matching record is retained; review conflicts before importing. Import identifiers as text in your spreadsheet to preserve leading zeros.
Source and tests included. Built with AI assistance. No ongoing updates or support subscription is included.
CSV CLEANROOM / VERSION 1.0
One-time commercial license. No redistribution of the toolkit.