Data Cleaning Guides
Ten common jobs, each worked through on a fictional sample file. Every guide shows the real result from the free tool, what it left for a person to decide, and the verifier's check of the change log.
Clean an Apollo CSV Export
The same contact exported from two saved searches, so the row appears twice.
Read the guide →HubSpot Import Cleanup
The same email twice with different capitalization, which creates confusion about which row wins.
Read the guide →Remove Duplicate CRM Contacts Safely
Exact repeats from importing the same file twice.
Read the guide →Salesforce Lead Import Cleanup
Names typed in ALL CAPITALS on a badge scanner.
Read the guide →Clean an Email List Before Import
The same subscriber twice, once with capital letters.
Read the guide →Standardize Phone Numbers in a CSV
US numbers written with brackets, dots, dashes and spaces.
Read the guide →Fix Mixed Date Formats in a CSV
Month-first and day-first dates from different teams.
Read the guide →Merge Two Contact Lists Into One
The second list's header row sitting in the middle of the file.
Read the guide →Clean a CSV Without Losing Leading Zeros
ZIP codes that start with zero.
Read the guide →Clean a Candidate List for Your ATS
One full-name column when the ATS wants first and last name.
Read the guide →How These Guides Are Made
Each sample file is invented for the guide. The before and after tables and the report are generated by running that file through the same rule-based engine the browser tools use, and the verifier result is copied from a real run. If the tool changes, the guides are regenerated.
Where a job needs judgement that rules cannot supply, the guide says so and points to the human service levels.