CSV Input and Output Sample for Bulk Verification
Download sample input and output CSVs for Phone Status Check and WhatsApp registration.
For bulk API file uploads, put the phone number or email in the first column. Keep CRM record IDs in a separate mapping file so you can join results back to the right records.
Prepare the input file
Use one identifier per row. For phone checks, use phone as the header, format numbers in E.164, and pass the required country separately when submitting the bulk API task. For email checks, use an email column in a separate file.
If you are starting with a CRM export, keep a separate mapping from normalized phone number to CRM record ID. One phone number can appear on multiple CRM records. Keep that mapping even if you submit each number only once.
Phone Status Check sample files
These five reserved US numbers and simulated results show the file layout. They are for inspecting the CSV and testing an import or join locally. A live Phone Status Check bulk job requires at least 2,000 rows.
Read the Phone Status Check export
Open all.csv in the result archive. The example uses English labels. Additional columns depend on which data the check returns.
| Column | How to use it |
|---|---|
phone | The number used to match a row back to your list. The export wraps phone values as spreadsheet text, for example ="+12025550101". When parsing the raw CSV, unwrap the value and keep the number as text. |
result_type | The product’s result category, such as active, normal, risky, or unknown. Use it to decide which rows need review. |
outcome | The processing outcome: valid, invalid, unknown_processed, or unknown_unprocessed. Use the product category alongside this column when deciding what to write back. |
classification | An example of an additional field. It can be blank or absent when the source does not supply it. |
Keep unknown results separate from confirmed outcomes. Review unknown_processed rows that came back inconclusive and consider retrying unknown_unprocessed rows. A missing result is also a reason to review the record before changing its CRM status.
For an end-to-end example, see the CRM cleanup workflow.
WhatsApp registration sample files
These four reserved US numbers and simulated results illustrate the English-language export. Use them to inspect the file layout or test a local import. A live bulk WhatsApp check requires at least 1,000 numbers.
Open all.csv in the result ZIP and filter result_type for registered, unregistered, or unknown. The archive can also include a TXT list for each category present in the result.
Check outcome for unknown rows. unknown_processed means the check ran but returned no definite answer. unknown_unprocessed means the row was not checked. Keep both out of your confirmed unregistered list.
Match results back to your source by the normalized phone number. See the 10,000-number walkthrough for the full upload and download process.