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.
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.
Step by step
- 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
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
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
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
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.
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.
Put it to work
- Contact List CleanerDe-duplicate and tidy a CSV or Excel list in your browser.
- CRM Import FormatterTurn the clean list into a HubSpot, Salesforce or Pipedrive file.
- Email VerifierCheck a single email address, free.
More tutorials: How to find leads · How to unlock and save a lead list · How to use LeadQuasar AI · How to do keyword research · How to use QuasarScout · How to check an email before sending · How to find a company's email format · How to audit a prospect's website · How to look up a company · How to calculate your market size · How to write a cold email sequence · How to define your ICP with AI · How to write a cold call script · How to extract email addresses · How to prepare a CSV for a CRM import · How to convert CSV contacts to vCard · How to make an invoice · How to write a quote · How to score a lead from its website · How to use the CRM · How to send a quote and invoice it · How to invoice a won deal · How to automate follow-ups · How to write an email sequence · How to set up a lead alert · How to audit a site in the app · How to track your rankings · How to save and export a lead list · How to find leads with the AI · How to research keywords in the app · How to plan with QuasarScout · How to create an API key · How to connect Gmail · How to connect HubSpot · How to connect Pipedrive · How to connect Zapier · How to connect Make · How to connect n8n · How to connect Slack
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.