Verify a Cleaned File
Someone cleaned your data and sent back a file and a change log? Check that the log explains every row they removed and every cell they changed.
Add the three files
Drop each file on its box, or choose it. CSV or Excel for the data, CSV for the change log.
What a Pass Means
• Every row that is missing from the cleaned file has a logged reason, and the reason is true. A row logged as empty must be empty; a row logged as a duplicate must add nothing to the row that was kept.
• Every cell that differs is explained by the log, and every log entry matches something in the files.
• Rows in, minus logged removals, equals rows out.
• With an audit record: the files are byte-for-byte the ones named in it.
What it does not tell you
A pass proves the log is complete and truthful. It does not prove that each cleaning choice suits your data, and it does not check whether email addresses or phone numbers are live. Rows removed by a reviewer's decision are listed as such and are not rule-checked.
Where these files come from
The Data Workspace, the CSV Cleaner, the command-line tool and every paid cleanup deliver a change log in this format. Other tools can too: the format is described in the command-line tool's README.