Tutorial · Contact List Cleaner

How to clean up a contact list with the Contact List Cleaner

How do I clean up a contact list?

Open the Contact List Cleaner and drop a CSV or Excel file. It removes duplicate rows, lowercases emails, flags badly written and role addresses such as info@, puts every phone in one format and splits full names. Check the results summary, then download CSV or Excel. Free, unlimited, no signup: the file never leaves your browser.

13.1 million+ verified businesses

Real screen recording of Contact List Cleaner, signed out, 11 November 2026, with captions added. Waits sped up. With a voiceover; the captions show every step, so it works muted.

In Contact List Cleaner

Step by step

  1. 1

    Drop your list

    Under Upload Your Contact List, drag in a CSV or Excel (.xlsx) file or tap Choose File. Your browser reads it on your device; nothing is uploaded.

  2. 2

    Pick the cleaning options

    Remove duplicate contacts and Split full names are on to start. Tick Remove rows with an invalid email or Remove role addresses to drop those rows instead of flagging them, and set the Phone format and the Default country for numbers with no + code.

  3. 3

    Read the results summary

    It cleans as soon as the file is in, and again whenever you change a setting. The summary shows the total contacts, valid formats, invalid emails, role addresses and duplicates removed.

  4. 4

    Check the preview

    Cleaned Contacts Preview shows the first rows, with new Email status and Phone status columns, and First name and Last name beside the full name.

  5. 5

    Download the clean file

    Click Download CSV or Download Excel. The Excel file keeps phone numbers as text, exactly as written. Format for CRM opens the CRM Import Formatter for the next step.

Clean a list free

What happens in the video

  1. 0:00

    “My contact list is full of DUPLICATES”

  2. 0:02

    Drop in your list

  3. 0:05

    Pick what to clean

  4. 0:06

    Duplicates removed, bad emails flagged

  5. 0:09

    Phones in one format, names split

  6. 0:12

    Download CSV or Excel

  7. 0:16

    Clean lists free: leadquasar.com/tools/contact-list-cleaner

Questions

Is my file uploaded?

No. The cleaner runs in your browser on your own device: nothing is sent to LeadQuasar or anyone else, and closing the tab discards the file. Free, unlimited, no signup.

How does it decide that two rows are duplicates?

By email first: two rows with the same address are one contact. If one has no email, it compares phone numbers, and only when the names do not disagree; with no phone either, name and city. The first row is kept and its empty cells are filled from the copies.

Does it check that a mailbox exists?

No. It checks that each address is written correctly and flags shared inboxes such as info@ and sales@. To test a single address against its mail server, use the free Email Verifier.

What happens to rows it cannot fix?

They stay in the file, marked in the Email status or Phone status column, so you can sort or filter on them. Tick the remove options before you download if you would rather drop them.

Contact List Cleaner

Try it on your own market

Free to search and count. 50 free unlocks a day with an account, no card needed.

Clean a list free