Data cleansing process in four steps
The whole job is four steps, and you make the decision in the third one. Nothing is written to your data before you approve it, and your original file is never modified.
Drop the file
A CSV or TSV export from your CRM, your billing system, an event platform or a spreadsheet. It is read by JavaScript in your browser, on your machine.
The delimiter is detected
Comma, semicolon or tab, decided by which one parses into a consistent number of columns.
Quoting is handled properly
Commas and line breaks inside quoted fields stay where they belong instead of splitting the row.
Headers become column names
Duplicate or blank header cells are given stable names so nothing collides silently.
Nothing is uploaded
There is no request to a server, so there is no data processing agreement to sign before you can try it.
It finds the problems
First it works out what each column holds, then it runs only the rules that apply to that kind of column. A date rule never fires on a company name.
Watch it run on a sample| Detected column | Rules that run on it |
|---|---|
| Whitespace, casing, invalid address flagging, duplicate identity key | |
| Date | Format detection across the column, then ISO 8601 rewriting |
| Currency | Symbol and separator removal, negative forms, decimal places |
| Postcode or ID | Leading zero restoration, whitespace, casing |
| State or country | Variant standardization, so Calif. and California agree |
| Name or company | Encoding repair, casing, legal suffix handling, fuzzy match keys |
Column detection is a proposal too. If it reads a column wrongly, rejecting its changes costs one click and nothing is applied.
You approve each change
Every proposal is one line: the original value, the proposed value, the rule that fired and how confident the engine is. Approve it, reject it, or take the lot in one click.
Row by row or in bulk
Work through a handful of columns by hand, or approve everything and reject the two you disagree with.
Duplicates are clusters
A matched group shows every row and which one it suggests keeping, with the reason they matched.
Nothing happens by default
An unreviewed proposal is not applied. The tool waits rather than guessing on your behalf.
Download the clean file and the audit log
Two files leave the browser. Neither of them overwrites what you started with.
File one
The cleaned CSV
Your original columns and rows, with only the changes you approved applied and the merges you accepted collapsed.
File two
The change log
One line per proposal: row, column, original value, proposed value, the rule and your decision. It is a CSV, so it opens anywhere.
Why the second file is the point
When someone asks why a number moved, a list of approved changes ends the conversation in a minute. Without it, the honest answer is that a tool cleaned the data, which is not an answer anyone accepts. This is what separates the process from removing duplicates in Excel and from a script nobody kept.
Do the whole process on this page
Load a messy sample or drop your own CSV.
1. Load a file
Your file is read on your own machine. Nothing is uploaded, so nothing can leak.
Or start from a messy sample
Status
Loading the sample file.
File: CRM contact export
Rows
--
Columns
--
Changes
--
Duplicate rows
--
Date formats
--
Blank emails
--
Load a file to see the diff
Drop a CSV or pick one of the messy samples. Every proposed change appears here as a line you approve or reject.
2. Review every change
Nothing approved yet.
Nothing is applied to your file until you approve it, and your original file is never modified.
Proposed changes
Original Proposed
Showing the first 400 changes. 0 more are in the audit log download.
Duplicate clusters
Merge or keep both
Want this on bigger files, on a schedule, with your team?
Saved recipes, scheduled cleans and shared seats are part of the paid plans. Start with your email and we will send you a code.
3. Take the result
The downloads work without an email. The cleaned CSV contains only the changes you approved.
Clean the file, and be able to show what you changed
Try the demo on your own CSV first. It runs in your browser, it costs nothing, and no card is required.
No card required. Your file never leaves your computer.