Free WhatsApp Contact List Cleaner
Free tool to merge many Excel and CSV contact sheets into one clean WhatsApp broadcast list. Fixes 91 and 0 prefixes, splits cells with two numbers, removes duplicates and exports WATI, AiSensy or Interakt format.
Drop your Excel, CSV or contacts (.vcf) files here, or choose files
Add as many files as you like. Title rows, missing headers, several numbers in one cell and 91β¦ numbers are all handled.
π Your files are read on your own device. Nothing is uploaded to us.
Settings
With Ora: Import the clean list into Ora and send WhatsApp broadcasts from a separate marketing number. Oraβs AI answers every reply in seconds and follows up with people who did not respond.
Start freeHow to use the WhatsApp Contact List Cleaner
- 1Drop all your contact files at once: Excel, CSV or phone contacts (.vcf).
- 2Pick the format: WATI, or simple Name and Phone for other WhatsApp tools.
- 3Check the counts and the preview. See file by file what was added.
- 4Download the CSV or Excel file and import it into your WhatsApp tool.
What this tool does
- βReads many Excel, CSV and .vcf files and every sheet inside them
- βFinds the phone and name columns, even under title rows or with no header
- βFixes +91, 91, 0 and spaces, and splits "98490 12345 / 91234 56789"
- βRemoves duplicates within and across files
- βFills missing names from other files and numbers repeated names
- βExports WATI import format or a simple Name, Phone list
Questions people ask
What format does WATI need for contact import?+
WATIβs template has the columns Name, CountryCode, Phone, AllowCampaign, AllowSMS, Attribute 1 and Attribute 2, with the phone as 10 digits and the country code (91) in its own column. This tool makes exactly that file.
Will my contacts be uploaded anywhere?+
No. The files are read and cleaned inside your browser. Nothing is sent to us or anyone else.
What happens to numbers like 919849012345 or 09849012345?+
They are turned into the same 10-digit number with country code 91, so they are matched as duplicates and imported correctly.
Why number repeated names?+
Some WhatsApp tools treat two contacts with the same name as one. Turning the second "Ravi Kumar" into "Ravi Kumar 2" keeps both.
Can I send WhatsApp broadcasts to these contacts?+
Only to people who agreed to hear from you on WhatsApp. Messaging people who did not opt in gets numbers blocked and reported.
More free tools
Want this done for you, every month?
Prophecius checks every page of your site, connects your Google Search Console, tells you what to fix in plain words, and runs an AI assistant that answers your customers on your website and WhatsApp.