Online data cleaning tool that runs in your browser
Drop a CSV or start from a messy sample. Every duplicate, broken date and mangled character comes back as a line you approve or reject, and then you download the file. Nothing is uploaded: the engine is JavaScript running on your own machine.
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.
Every rule on this page is the real one
There is no canned result behind it. The list below is what the engine looks for, in the order it runs, on whatever file you give it.
Column type inference
Each column is read as email, date, currency, number, postcode, state, country, name, company or plain text, so the right rule runs on the right column.
Exact and fuzzy duplicates
A normalized identity key first, then edit distance and shared tokens across name, company and email. Matches become clusters, not deletions.
Date normalization
Mixed day-first, month-first, named-month and serial dates are read and rewritten as ISO 8601, so the column finally sorts.
Currency and numbers
Currency symbols, thousands separators, trailing minus signs and parenthesised negatives become plain numbers.
Encoding repair
Mojibake from a UTF-8 file read as Latin-1 is reversed, so Muñoz turns back into Muñoz and the smart quotes come back.
Leading zeros and casing
Postcodes and IDs that lost a zero in a spreadsheet get it back, shouted names are recased, and stray whitespace is trimmed.
What the browser demo does not do
These are limits of running on your own machine, not a lock put on a trial.
5MB, about 20,000 rows
The file is parsed in your browser's memory, so the ceiling is your machine rather than a plan boundary.
CSV and TSV, not XLSX
Save the sheet as CSV first. A spreadsheet workbook is a zip archive of XML and unpacking it in the page is not worth what it costs you in wait.
Nothing is kept between visits
Closing the tab ends it. That is the same property that means your file was never uploaded in the first place.
It does not write back to a CRM
You download the cleaned CSV and the change log. Connectors and scheduled cleans are part of the paid plans.
Where the limits go on a plan
Plan limits raise the file size to 25MB, 100MB and 500MB, and add saved recipes, scheduled cleans and connectors. The engine and the review step are the same ones you just used.
If the demo did what you needed
Keep the recipe, and run it on the next file
Saved cleaning recipes, bigger files and shared seats are part of the paid plans. Start with your email and we will send you a code.
No card required. Your file never leaves your computer.