US active ws number export specifications: CSV/TXT column naming, encoding and downstream import complete guide

After you complete the batch screening of US active ws numbers, how to import the results into CRM, broadcast tools or marketing platforms efficiently and error-free will directly determine the efficiency of subsequent customer acquisition. US Active WS Numbers (that is, valid and recently online WhatsApp accounts) are high-value data for overseas marketing. However, problems such as confusing column names, garbled encoding, and missing fields during export often cause the team to repeatedly rework. This article starts from the actual export process of the KK-DATA console and explains in detail the column name specifications, encoding settings, delimiter selection of CSV/TXT, as well as the best practices for importing data into downstream systems, helping you to use US WS Active Data in one step.

What is a US active ws number? Why do you need canonical export?

“Active” specifically refers to the number in the WhatsApp number screening scenario: the number has not only opened a WhatsApp account, but also has an online record within a designated active window (such as within 30 days). In contrast, “activated” only means that the account exists and may be offline for a long time. For marketing activities that require a high reach rate (such as flash sale notifications, customer return visits), the value of US Active WS Number is much higher than that of ordinary opened numbers.

The importance of canonical export is:

• Avoid data confusion: Different systems have different requirements for number formats and field names (such as phone vs Phone). Unifying column names during export can reduce manual mapping costs.
• Improve import success rate: Chinese garbled characters caused by encoding errors and field misalignment caused by delimiter conflicts are the main reasons for data import failure.
• Protect account security: Importing known active numbers in batches can greatly reduce the sending failure rate caused by invalid or offline numbers, and reduce the probability of risk control triggering.

How to export US active ws number from KK-DATA?

The KK-DATA console provides a complete screen number → export pipeline. The specific steps are as follows:

1. Create Screening Number Task: In the “WhatsApp Screening Number” module, select the filtering range “Number Source” (number uploaded by yourself or the US number segment generated by the global number generation module), and check Active for the detection type (fields such as activation and gender can be selected at the same time).
2. Submit task: Submit after confirming the estimated cost. After the task is completed, you will be notified via Telegram (requires binding in advance).
3. Enter the export page: Click “Export” on the task details page, select the format (CSV or TXT) and encoding.

Select export fields

When exporting, fields can be selected based on downstream requirements. Common exportable fields include (subject to the actual display on the console):

Field type	Example column name	Description
Number	phone	Full international format, e.g. +14151234567
Country Code	country_code	US or 1 for the United States
Active status	active	1 means active, 0 means inactive
Gender	gender	male / female (some numbers have data)
Age	age	Age value (available for some numbers)
Last online	last_seen	Unix timestamp or readable date (if detected)
Detection Type	detect_type	WhatsApp_active

Please note: Gender and age fields are not included in all numbers, and the accuracy is based on model estimates and cannot be used as ID card-level data.

Export file structure preview

Taking CSV as an example, the typical first column name is as follows:

phone,country_code,active,gender,age,last_seen
+14151234567,1,1,male,32,1735689600
+14159876543,1,1,female,28,1735776000

If you choose TXT format, there is one number per line by default (no column names), which is suitable for direct use in broadcast tools.

Encoding and delimiter settings for exported files

The trade-off between UTF-8 and BOM

• UTF-8 with BOM: There is a 3-byte BOM mark (EF BB BF) at the beginning of the file. Excel recognizes it as UTF-8. It is recommended for Windows users. Most editors under Mac/Linux will automatically ignore the BOM.
• UTF-8 without BOM: More versatile, but Excel may need to specify it manually when importing. This option can be toggled if the downstream system requires no BOM (such as some CRM upload components).

Delimiter selection tips

CSV is comma , delimited by default, but parsing errors occur when commas are accidentally included in the number or field data. In the KK-DATA export settings you can customize the delimiter:

• Comma (default): Standard CSV, Excel can open it directly.
• Tab: Suitable for rare cases where the number itself contains commas, or for importing into a Tab-delimited system.
• Semicolon: Excel locales for some European languages ​​use semicolons as delimiters by default.

Operation Suggestion: Use a small sample to export the test first, and confirm that the downstream system can parse it correctly before executing it in batches.

How to import the exported US active ws number into the downstream system?

Different systems have different import format requirements, which are explained by scenario:

Import CRM system (such as HubSpot, Salesforce)

1. Field Mapping: Create or select the “Phone” field in CRM and map the exported phone column directly. Keep the form simple by removing unnecessary label columns (such as last_seen).
2. Number Format: Make sure the CRM accepts international formats (starting with +1). Some CRMs require removing + or spaces. You can remove the international prefix in the KK-DATA settings before exporting, or use formula conversion after importing.
3. Encoding: If the CRM background displays Chinese garbled characters, please confirm that the export encoding is UTF-8 with BOM, and select UTF-8 encoding when importing into CRM.

Import WhatsApp broadcast tools (such as WATool, business API integration)

Most broadcast tools require a pure list of numbers, one per line. At this time, the TXT format (UTF-8 with BOM) ​​is recommended, and no listing is required. If you need to add gender for hierarchical reach, you can choose CSV and only retain the two columns phone and gender:

phone,gender
+14151234567,male
+14159876543,female

Then create broadcast groupings in batches by gender.

Common mistakes and avoidance methods in exporting US active ws numbers

Error symptoms	Possible causes	Solutions
Chinese characters are displayed as garbled characters	UTF-8 with BOM is not used, or the Excel default encoding does not match	Select BOM when re-exporting; or use a text editor to save as UTF-8 BOM
Field misalignment (such as a number in the gender column)	Delimiter conflict (the number contains commas) or the number of fields does not match the column name	Use tab separation instead; check the number of exported fields and the actual number of columns
The number is missing or in the wrong format	The original data itself is incomplete, or export without international prefix is selected	Reset the export to the complete international format; pre-clean non-numeric characters in the source data
Prompt “duplicate number” after import	The same number appears in multiple export batches	See the deduplication warehouse below

The difference between US ws active data and ordinary numbers

Type	Meaning	Applicable scenarios	Cost (billed by item)
Active number	WhatsApp account exists and has recent online records	High-conversion marketing, instant reach, promotions	Slightly higher than activation detection (see console real-time price for details)
Open number	Only confirm the existence of WhatsApp account (not guaranteed to be online in the near future)	Broad coverage, as seed data, secondary screening	Lower

Selection suggestion: If the budget is limited and the reach rate requirements are medium, you can first use the “activation” plan to cover all the numbers, and then conduct a secondary activity detection on the unresponsive numbers; if you directly pursue a high open rate, it is more efficient to directly screen US active ws numbers.

Best practices after exporting US active ws numbers

1. Batch messages: Do not send thousands of active numbers at once. It is recommended to send messages in batches of 50-100 messages with an interval of 10-15 minutes. High-frequency sending can easily trigger WhatsApp risk control.
2. Add remark field: Add the source_task_id field when exporting (custom columns can be added through export settings) to facilitate the task of tracing the number source and evaluating the cost effectiveness of different screening strategies.
3. Purge expired numbers regularly: WhatsApp activity status is dynamic - a number that was active last week may be deprecated this week. It is recommended to re-screen the historical active data every month or quarter to keep the list fresh.
4. Use task notification: Bind Telegram to the KK-DATA console, and a reminder will be automatically pushed when the task is completed. The results can be downloaded in time to avoid backlog.

FAQ

Q: Does the exported US active ws number include the country code?

A: By default, complete international formats (such as +1xxxx) are included. You can select “Remove International Prefix” in the export settings to get a purely numeric format. It is recommended to retain the international prefix so that downstream systems can automatically identify the country.

Question: What should I do if garbled characters appear when opening a CSV file in Excel?

Answer: First confirm that “UTF-8 with BOM” encoding is selected when exporting. If a file without BOM has been exported, you can fix it with the following method: open the CSV with Notepad, click “Save As”, select “UTF-8” in the encoding drop-down box, and then overwrite the original file; or in Excel, specify the encoding as UTF-8 through “Data → Import from Text/CSV” (supported by Excel 2016 and above).

Question: How many active US WS numbers can be exported at one time?

Answer: A maximum of about 1 million numbers can be submitted for a single number screening task, but the size of the exported file is limited by the browser download. If the export exceeds 100,000 items, it is recommended to use the server-side export function of KK-DATA (see Usage Documentation for details). After the task is completed, a download link will be generated, and breakpoint resumption is supported.

Q: Can the exported number be used for secondary marketing?

A: Yes, but you must comply with WhatsApp Business Policy and local privacy regulations (such as California CCPA). It is recommended to only reach users who have agreed to receive messages, control the frequency of sending, and avoid sending similar content frequently in a short period of time. Compliant use is the basis for long-term operations.

Question: How to avoid repeated detection of the same number after exporting?

Answer: Before submitting a new screening task, use the “Data Deduplication Warehouse” in the console to upload the historical export file (both CSV/TXT are acceptable). The system will automatically compare and filter the detected numbers to ensure that you will not be charged multiple times for the same number. The deduplication warehouse also supports cross-task comparison, allowing accurate deduplication even if the numbers come from different batches.

---

Master the standardized export process, efficiently obtain US active ws number, and immediately experience the screening and export functions of KK-DATA:

👉 Log in to the console to start screening numbers Two-way contact customer service: https://t.me/kkdata_robot Detailed usage documentation: https://docs.kkdata.cc/ Official website homepage: https://kkdata.cc/