67Leads › Free tools › Lead list cleaner and deduper
Clean and de-duplicate a CSV lead list
Paste a CSV. Get it back with whitespace trimmed, emails lower-cased and syntax-checked, US phones in E.164, websites tidied and duplicate rows removed. Nothing you paste is stored. Free, no account.
What it changes
- Every cell: leading, trailing and repeated spaces removed; blank rows dropped.
- Email column: lower-cased,
mailto:and stray brackets removed, syntax checked. Syntax is not deliverability: check deliverability with SimpleVerifier, our sister verifier. - Phone column: US and Canadian numbers rewritten in E.164 (a plus, the 1 and ten digits); numbers that cannot be dialled are left as typed and counted.
- Website column: reduced to the bare domain (smith.com).
- Duplicates: a row repeats an earlier one when it has the same email, or failing that the same phone, website or company name.
- Cells that start with = + - @ are prefixed with ' in the download, so a spreadsheet cannot run them as formulas. Phone numbers keep their +.
Columns are found by header name (email, phone, website, company). Nothing you paste is stored or logged; the page is not cached.
Phone number formatterEmail permutatorPreview a 67Leads list
Questions
Paste the CSV above and press Clean. Rows that repeat an earlier row's email (or, without one, its phone, website or company name) are removed and counted.
No. The CSV is cleaned in memory for that one request and the response is marked not to be cached. Nothing is written to disk or a database.
It checks syntax only. A well-formed address can still bounce; use a verifier such as SimpleVerifier before you send.
The international phone format: a plus, the country code and the number with no spaces: +1 and the ten digits. Most CRMs and dialers import it cleanly.
More free tools
Local business counterNo-website business finderLead list previewCold email template generatorCold email ROI calculatorLead list cost calculatorEmail warm-up schedule plannerPhone number formatter (E.164)Google rating calculatorCAN-SPAM compliance checkerCompany website finderAll tools