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 or invalid 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
Duplicate clusters
Merge or keep both
Want this on every file, and on bigger ones?
The free try is one file of your own. The Analyst plan cleans as many files as you need, up to 25MB and about 100,000 rows each, for $59 a month or $348 a year.
3. Take the result
The cleaned CSV contains only the changes you approved. The log lists every change, approved or not.
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 the limits of the free try. The Analyst plan lifts the size and the file count, and the rest is how the tool works for everyone.
5MB and 20,000 rows on the free try
That is the free try's size limit. The Analyst plan takes files up to 25MB and 100,000 rows, read in your browser's memory just the same.
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 and load them wherever they need to go. There are no connectors.
Where the limits go on a plan
The Analyst plan raises the file size to 25MB, about 100,000 rows, and removes the one-file limit. The engine and the review step are the same ones you just used.
If the demo did what you needed
Run it on the next file, and the one after
The free try is one file. The Analyst plan is every file you have, up to 25MB each, for $59 a month or $348 a year.
No card required. Your file never leaves your computer.