Article summary
A practical guide to screening an authorized WhatsApp phone list: prepare a TXT file, choose the right task, read its Excel output, and keep registration separate from activity and messaging permission.
For a WhatsApp phone list, the useful first question is not “which tool returns the most columns?” It is “what decision does this task need to support?” Registration, recent activity, and other profile checks are different services. AppShai accepts TXT phone-number files and exports an Excel result with fields for the selected task. A result from one task should not be read as if it came from another.
Prepare the list before uploading
- Confirm the source and permitted use. Work only with contact data your organization is allowed to process. If you plan to message people, check the separate permission requirements under WhatsApp policy and applicable law.
- Use a TXT file. Put one phone number on each line and use a consistent international format that includes the country calling code. Keep the original source list in your own controlled system for reconciliation; CSV and Excel are not the upload format for this workflow.
- Review formatting. Check calling codes, missing digits, blank rows, spaces, and duplicates. Domestic trunk-prefix rules differ by country, so do not apply one country’s cleanup rule to every number.
- Start with a small test. Select a small, authorized subset whose source and expected use are known. Confirm the output columns and row matching before processing the full list.
Choose the task that matches the question
| Question | Screening direction | Do not infer |
|---|---|---|
| Does this number have a WhatsApp account? | WS registration check | Recent activity or permission to contact |
| Was there a recent activity signal? | WS activity check | That the recipient wants to receive a message |
| Is another data dimension needed? | Choose a service currently listed on the product page | That its fields are included in basic registration results |
Check the current options on the AppShai WhatsApp number-screening page and in the task interface. The basic WS registration output is about the number and its registration status. Activity screening is a separate task; its activity-time fields should not be attributed to a basic registration result.
Read the Excel result according to the task
Excel is the result format, not a promise that every task returns the same columns. Start with the selected service and the field labels in that export. Separate clear registration results from rows that need review because of missing input, format problems, or an empty value. Do not convert every exception into “not registered.”
- Keep the input TXT file and its output together so you can identify which task produced the result.
- Reconcile the input row count, deduplicated row count, and export row count. Investigate differences before importing results into another system.
- If recent activity is the question, run the activity task and retain that result separately instead of guessing activity from registration.
- Treat a screening result as a point-in-time result for the selected task, not as a permanent account state.
Common interpretation mistakes
Does “registered” mean “online now”?
No. Registration and activity over a period are separate questions. Online status is time-specific and depends on what is visible. If recent activity matters, use the corresponding service and read only the fields that task returns.
Can every registered number receive a marketing message?
No. The WhatsApp Business Messaging Policy says businesses may contact people only when they have the person’s phone number or username and opt-in permission for subsequent messages or calls. They must also honor requests to stop or opt out. Screening does not create that permission.
Why should malformed rows stay separate from negative results?
A wrong calling code, missing digit, duplicate, blank row, or formatting problem can make a record uncertain. That is a data-quality issue, not proof that the number has no account.
Handle contact data carefully
Before using a list, document its source, purpose, access controls, and retention period. Limit access to exported files and follow applicable deletion and opt-out requirements. WhatsApp’s policy sets separate opt-in and opt-out expectations for business messaging; see the WhatsApp Business Messaging Policy. A status check does not authorize a broader use of the list.
