Skip to content
zelnum.com
WhatsApp Tools

How to Filter WhatsApp Numbers from a List

Upload a CSV or TXT file to the Bulk WhatsApp Number Checker to find which numbers are registered on WhatsApp. Prepare one file per country and download the results when the job finishes. The check sends no messages.

How to Check WhatsApp Numbers in Bulk from a CSV

CSV phone list cleaning checklist

  1. Prepare your list. Use numbers you have permission to check. Keep your original spreadsheet and record IDs. In the upload file, put one number per row in a column named phone, with the international calling code. If you start in Excel, format the column as Text and save it as CSV UTF-8. Split mixed-country lists and remove duplicates after standardizing the numbers.
  2. Upload the file. Sign in to ZelNum. Choose WhatsApp Number Checker and the matching country or region. Upload the CSV or TXT file. Each batch requires at least 1,000 numbers. The upload limit is 50 MB and 1,000,000 numbers per order.
  3. Submit and track the job. Check the cost estimate and the accepted row count. Malformed numbers, country mismatches, and duplicate numbers can reduce the count. Wait for the job to finish before downloading the result ZIP.
  4. Read the results. Open all.csv and filter the result_type column. Keep registered, unregistered, and unknown separate. Match the results back to your source list by normalized phone number.

Download the WhatsApp input and example output CSVs to inspect the layout before you run a job.

Example: Check 10,000 Phone Numbers for WhatsApp Registration

Suppose your CRM export contains 10,000 unique US phone numbers. Save the phone column as a CSV and select United States for the job. If all 10,000 numbers are billable, the check uses $0.5 in prepaid credits. Top-up amounts show what it costs to add credit to your balance.

When the job finishes, download the ZIP. Filter for registered in all.csv to get the list of confirmed registrations. Use your consent records to decide whom you can contact. Use unregistered to update WhatsApp availability in your CRM and keep the original contact record for other checks.

For unknown results, read the outcome column. unknown_processed means the lookup ran without a definite answer. unknown_unprocessed means the lookup did not run. Review the first group and consider retrying the second.

What to do with the filtered list

Registration is one signal. For SMS or phone calls, run a separate phone status or line type check when you need it. Join the results back to the original record IDs and apply your channel rules before importing or contacting anyone.

For a larger list or an unfamiliar source, try one country’s minimum batch first. Check that the file parsed correctly and that you can match the results back to your spreadsheet before running the rest.

FAQ

Can I filter WhatsApp numbers in Excel?

Prepare the phone column in Excel, save it as CSV UTF-8, and upload the file to ZelNum for the registration check. Import all.csv back into Excel to filter the results.

Can I check numbers from multiple countries?

Split the list into one file per country. Select the matching country for each job and combine the results in your spreadsheet afterward.

Can I run the same check by API?

Yes. Use the WhatsApp Number Check API to submit a file and download the finished result from your application.

Open the Bulk WhatsApp Number Checker

About the author
Ethan Chen Director of Telecom Data & Verification

Ethan works on phone-number normalization, E.164 formatting, country-code rules, carrier metadata, and line-type detection. His editorial work turns verification signals into practical workflows for CRM cleaning, SMS preparation, lead review, and bulk data operations.

View full author profile →