Article summary
Check an existing phone list for WhatsApp registration. Follow one practical run from spreadsheet preparation and TXT input to Excel results, without confusing checking with messaging.
Your contact sheet probably does not contain a perfectly uniform phone column. Some numbers have country codes, others use domestic formatting, and one customer may appear on several orders. To find which numbers are registered on WhatsApp, you do not have to add each contact manually or redesign your CRM first. Start by preparing that phone column.
This walkthrough uses an existing list you are entitled to process. The manual input is TXT and the completed result is Excel. Checking fills a registration-status gap; it does not register accounts for customers or send them messages.
Complete one bulk WhatsApp registration check
1. Copy the phone column and leave the source sheet intact
Save a working copy and select the numbers you need to check. Keep names, order references and notes in the source sheet for matching later. Treat phone values as text. If a spreadsheet has already lost digits through numeric conversion, changing the display format will not restore them.
2. Confirm country codes before deduplicating
A domestic number without its country context is ambiguous. Put uncertain records aside rather than guessing from length. WhatsApp describes international phone formatting in its help material[1]; follow the checker task’s specific input requirements as well. Avoid adding a country code twice or stripping domestic zeros indiscriminately.
Deduplicate after the number formats are consistent. One number can be checked once while its multiple order relationships remain in the original sheet. The returned status can then be matched to the relevant records.
3. Save a real TXT file
Copy the numbers into a plain-text file, one number per line. Leave out the column heading, customer names and comma-separated notes. Save UTF-8 TXT and reopen it to check for merged lines, quotation marks or unwanted text. Renaming an .xlsx file to .txt does not convert it.
4. Select a WhatsApp registration task
Sign in through the AppShai WhatsApp Number Checker, select the registration task available in the current dashboard and submit the TXT file. If registration is the only missing information, you do not need to add photo, demographic or full-format checks.
Use the separate WA/WS registration task comparison to choose Rapid, Stable or High-Precision checking. High-Precision currently returns the submitted phone and registration status, not additional business-number or mapped-phone fields. For a first attempt, use part of the list to confirm that the format and task are right before submitting the rest.
5. Match the Excel result by phone number, not row position
Find the phone and registration columns in the downloaded result. Match on the number instead of assuming that the export and source rows have identical order. Pasting together two independently sorted sheets is an easy way to attach one customer’s result to another customer.
You can add a checking date to your own worksheet. That is your record-keeping choice, not an additional field promised by the registration service.
6. Use the result for the original contact-list decision
A registered result fills the WhatsApp channel status. A negative result does not establish that a phone is disconnected or that the customer is invalid. For an absent result, distinguish an exception or formatting problem from an explicit negative response before assigning a value.
Add the status and checking date beside the existing customer record while retaining other contact channels. Subsequent communication still needs appropriate permission; WhatsApp’s business policy treats contact permission and opt-out separately from registration[2].
If something goes wrong: check the actual TXT format when a file is rejected; review country codes, duplicates and lost digits when matching fails; retain the input and task details for a disputed status so support can investigate. One unexplained row does not automatically call for rerunning the whole list.
References
- WhatsApp: International phone number format — official formatting background; task-specific input instructions still apply.
- WhatsApp Business Messaging Policy — business contact permission and opt-out requirements.
