Drop in a contacts or customer CSV. You get a cleaned file with trimmed spaces, lower-case emails, standard phone numbers, Canadian postal codes in A1A 1A1 form, ISO dates, fixed name capitalisation, optional First/Last name split, two-letter province and state codes, and duplicates removed. Rows that need a human look are listed with the reason. Nothing is deleted without being listed.
Your file never leaves your computer; everything runs in this tab. Nothing is uploaded.
Review the flagged and removed rows before you use the file. This tool does not know your data; it applies the rules above.
2. Check the columns (auto-detected):
Download all five files for this browser: USD 19. cleaned.csv, flagged.csv, possible_duplicates.csv, removed_duplicates.csv and CHANGELOG.md. After payment you're sent back here and the downloads unlock. Your file still stays in your browser.
Prefer us to do it? USD 40 per file, and you pay after we've reviewed the result: [email protected].
Want to see it first? Before/after sample with fictional data.
The Trillium Company · 145 Columbia Street West, Unit 1803, Waterloo, Ontario N2L 0K7, Canada · [email protected] · +1 (548) 490-9330