Data cleaning software that proposes changes instead of making them
Data cleaning software finds and fixes the problems that make a file untrustworthy: duplicate records, mixed date formats, numbers stored as text, encoding damage and inconsistent spellings. Datauntangler does that in your browser and hands you a line by line list of what it wants to change.
Load a messy sample and watch it work
The same engine described below, running on your own machine. Nothing is uploaded and nothing is applied until you approve it.
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.
The two kinds of tool that already exist
On one side there are free desktop tools. OpenRefine is the best known: open source, capable, and something you install and then learn to drive with its own expression language. It runs on your machine, which is good for privacy and bad for sharing the work with a colleague.
On the other side there are enterprise data quality platforms. They are thorough and they are bought through procurement, with onboarding measured in weeks. Both are reasonable answers to a question most people are not asking. The common case is one person with one file that has to be right this afternoon.
What this software actually does to a file
Reads the file where it sits
Parsing and cleaning run in your browser. Nothing is uploaded, so there is no data processing agreement to sign before you can try it.
Infers what each column holds
Email, date, currency, postcode, state, country, name, company. The right rule then runs on the right column instead of on everything.
Proposes one change per cell
Each proposal shows the original value, the new value, every rule that fired, and how confident the engine is.
Groups duplicates into clusters
With the row it suggests keeping and the reason the rows matched.
Exports two files
The cleaned CSV, and the audit log of every change and every decision you made.
Why the review step is the product
Anyone can write a script that lowercases a column. The hard part is defending the result. When someone asks why the March number moved, the answer cannot be that the tool cleaned it.
Because every change is approved by a person and written to an audit log, you can hand over the file and the list of what changed in it. That is what makes the output usable in a report, a migration or a board pack. If your file starts life in a spreadsheet, Excel data cleaning covers what the built in commands do and where they stop, and data deduplication tools cover the matching that Remove Duplicates cannot reach.
What a spreadsheet clean leaves behind
Most files are cleaned with helper columns and a Find and Replace. It works, right up to the moment somebody asks what changed.
Excel data cleaningHelper columns outlive the file they were written for
A column of TRIM and PROPER formulas gets pasted into next month's export, where the columns have moved and the formulas now point at the wrong data.
Find and Replace does not ask first
It changes every match in the sheet at once, including the ones in the column you were not thinking about, and the undo history ends at the save.
The cleaned file is the only artefact
Nothing lists what was altered, so comparing it with what arrived means opening both files and reading them side by side.
What software should hand back
Two files, not one: the cleaned data, and the log of every change that was proposed, approved or rejected.
Questions about data cleaning software
Do I have to install anything?
What file types does the browser demo read?
Plans for when the file is bigger than the demo
Yearly billing is two months free. There is no free plan, and no card is needed to use the browser demo above.
Yearly billing is two months free.
Switch to yearly and two months are free.
Analyst
One ops person or analyst with files to clean.
$49$59/mo
Billed $590 a year Billed monthly
- 50,000 rows a month
- Files up to 25MB
- 1 seat
- Fuzzy matching and entity resolution
- Reviewable diff and audit log export
- 3 saved cleaning recipes
- Email support
Team
RecommendedA RevOps or marketing ops team sharing the work.
$166$199/mo
Billed $1,990 a year Billed monthly
- 250,000 rows a month
- Files up to 100MB
- 5 seats
- Everything in Analyst
- Unlimited saved recipes
- Scheduled recurring cleans
- CRM connectors (Salesforce, HubSpot)
- Priority email support
Business
A data team cleaning for several departments.
$499$599/mo
Billed $5,990 a year Billed monthly
- 1,500,000 rows a month
- Files up to 500MB
- 20 seats
- Everything in Team
- API access
- Roles and permissions
- Priority email support
Enterprise
A head of data who needs it defensible across the company.
Talk to sales
Custom terms, invoicing and PO
- Unlimited rows and custom file sizes
- Unlimited seats
- Everything in Business
- SSO (SAML / Okta)
- Custom data retention
- DPA on request
- Named support contact
- Invoicing and PO
- Named onboarding
A row is one data line in a file you process, not counting the header. The browser demo is free to use and is not a plan: it reads CSV and TSV files up to 5MB on your own machine.
Related pages
- Data Quality Tools: How to Compare Them Before You Buy
- Excel Data Cleaning Without Formulas or Macros
- Data Deduplication Tools That Match More Than Exact Values
- Data Hygiene for Contact Lists and CRM Records
- Fuzzy Matching Tool - Match Names, Companies and Emails
- Entity Resolution for Customer and Company Records
- Data Cleaning Services vs Doing It In House
- Address Standardization for Shipping and Billing Files
- CRM Data Cleansing Before a Migration or an Import
- Salesforce Deduplication on the Export, Before It Goes Back
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.