Multi-Format Export Guide for Global Screening Results: CSV/TXT Field Details and Download Tips

Completing the number screening task is not the end of the work—exporting is where the data truly begins to generate value. Many teams spend a lot of time on number generation and detection but neglect understanding and properly utilizing the export format, resulting in data that cannot be used directly or requiring manual reprocessing, wasting precious time.

This article takes the KK-DATA platform as an example to break down the key knowledge points of multi-format export: What scenarios are CSV and TXT suitable for? What does each column field represent? How to perform cross-platform mixed exports? And how to efficiently convert the exported data into customer acquisition actions.

Whether you are a beginner just starting with screening tools or an operations manager needing to standardize processes, this guide will help you save unnecessary repetitive work.

---

Why Multi-Format Export Is a Key Step in the Screening Process

Many people intuitively think: exporting means “downloading the results.” But in practice, whether the export logic is reasonable directly determines whether this batch of data can smoothly enter the next usage stage.

Specifically, multi-format export can meet the following three common needs:

• CRM / Backend System Import: Requires structured fields and fixed column names for easy batch writing into the database.
• Friend-Adding / Bulk Messaging Tools: Only need a pure number list, without any other information, to avoid parsing errors in the tool.
• Secondary Data Analysis: Need to retain all detection fields (activity level, gender, etc.) for filtering, statistics, and tagging in Excel.

The two formats provided by KK-DATA—CSV and TXT—are designed precisely for these three scenarios. To put it simply: Use CSV for data management, use TXT for data usage.

---

CSV vs TXT — Applicable Scenarios for the Two Main Export Formats

Before downloading, clarify “what you want to do” to choose the correct format.

Comparison Dimension	CSV Format	TXT Format
File Structure	Table format: one number per row, one field per column	Plain text: one number per line
Open With	Excel, Google Sheets, database import tools	Notepad, command line, script reading
Applicable Scenarios	Data filtering, statistical analysis, CRM import	Batch add friends, import into bulk messaging tools, API calls
Field Richness	Can include all detection fields	Only numbers, no additional info
File Size	Larger (due to many fields)	Smaller (only numbers)

CSV Format: Suitable for Data Analysis and CRM Import

CSV (Comma-Separated Values) is the industry-standard table data exchange format. In CSV files exported by KK-DATA, each column corresponds to a detection field, such as number, activation status, active days, gender, etc.

Typical Usage Path:

1. Download CSV to local.
2. Open with Excel or Google Sheets.
3. Use filtering to retain only “valid and active” numbers.
4. Select the target number column, copy, and paste into the CRM system.

CSV is the first choice for teams that need fine-grained management of number quality. After exporting, you can perform secondary processing on the data, such as splitting into multiple sub-files by country, gender, or activity level, then use them for different marketing strategies.

TXT Format: Suitable for Batch Adding Friends or Importing into Friend-Adding Tools

If you only need the numbers themselves, TXT format is lighter. Each line contains a complete E.164 format number (including the + sign and country code), with no field headers or comma separators.

Typical Usage Path:

1. Download the TXT file.
2. Read each line with a script and send friend requests one by one.
3. Or paste directly into Telegram/WhatsApp’s batch add contacts interface.

For friend-adding tools or self-developed scripts, TXT files parse faster, have a lower error rate, and avoid unnecessary memory overhead from field parsing.

---

Detailed Field Explanation — What Data Are You Actually Getting?

After receiving the file, if you don’t understand what each column represents, it’s wasted effort. Below are the core field meanings in KK-DATA exports, explained by platform.

Telegram Export Field Description

Field Name	Meaning	Description
Number or phone	International standard format	E.164 format, includes + sign, e.g., +8613800138000
tg activated	Whether registered on Telegram	Values: Yes / No (or 1 / 0)
tg valid	Whether searchable/can receive messages	Valid only if activated and not banned/abnormal
tg active	Whether recently online	Determined by the specified active window (7/15/30 days)
Active days	Days since last online	Smaller value means more active
Gender	Gender from avatar recognition	Values: Male / Female / Unknown (blurry or no avatar)
tgid	Telegram user_id	Used for further API queries or messaging

Supplementary Notes on Detection Logic:

• “tg activated” checks whether the phone number is registered on Telegram; it does not guarantee ability to add as a friend.
• “tg valid” filters out invalid states like deactivated or banned based on internal platform logic.
• “Active days” is an exact numeric value representing the interval in days from the detection time point to the user’s last online time.

WhatsApp Export Field Description

Field Name	Meaning	Description
Number	International standard format	Same as above
ws valid	Whether registered on WhatsApp	Values: Yes / No
wsid	WhatsApp internal identifier	Used for WhatsApp Business API calls

Practical Value of wsid:

If you later need to send template messages via the WhatsApp Business API, wsid is a required parameter. Retaining this field during export saves the step of an additional query later.

---

Mixed Export of Multi-Platform Screening Results and Field Adaptation

When a single screening task detects both Telegram and WhatsApp (or other platforms), how does the export file handle fields?

KK-DATA’s approach: One number per row, with detection fields from all platforms listed side by side.

Example:

Number	tg activated	tg active	ws valid	wsid
+8613800138000	Yes	30 days	Yes	abc123
+8613900139000	No	-	Yes	def456

• If a number was only detected for Telegram but the task also included WhatsApp screening settings, fields for the undetected platform will show ”-” or be empty.
• You can filter in Excel to keep only the parts you need. For example, keep only high-quality dual-platform users where “tg activated = Yes AND ws valid = Yes”.

This design avoids multiple records for the same number, facilitating subsequent data pivoting and analysis.

---

Data Volume and File Splitting Considerations Before Export

A single screening task can submit up to approximately 1 million numbers. The export file size depends on two factors:

• Number of entries: A CSV file with 1 million entries (all fields) is about 200–500 MB.
• Number of fields: More fields mean longer rows and larger files.

If you must operate in Excel, it is advisable to filter more precisely in the console before the export task (e.g., keep only “active + male” numbers) and then export a smaller dataset.

---

How to Correctly Use Exported Data — From Screening Results to Customer Acquisition Actions

After getting the data, how do you turn it into actual conversions? Follow these three steps:

1. Secondary Filtering: Use Excel filters in the CSV to keep only numbers that match your marketing targets. For example:

   • Telegram: tg valid + active days ≤ 7 days + gender male
   • WhatsApp: ws valid + all numbers

2. Deduplication Check: If you have historical data, first compare in KK-DATA’s deduplication repository to avoid duplicate detection wasting balance. Locally, you can also use a formula like =COUNTIF(A:A,A1)>1 to quickly check duplicates.

3. Compliant Usage: Privacy and platform policies must be respected.

---

Frequently Asked Questions

Q: After opening the exported CSV file with Excel, some fields appear as garbled characters. What should I do?

A: It is recommended to open the CSV file with UTF-8 encoding. If Excel defaults to ANSI parsing, go to “Data” → “From Text/CSV” and select UTF-8 encoding, or use Notepad++/VS Code to save the file as UTF-8 with BOM.

---

Q: If I detect both Telegram and WhatsApp in one task, will the fields be mixed in the exported file?

A: In KK-DATA’s export files, each number will simultaneously contain all platform-related fields (e.g., TG active, WA valid). If a platform was not detected for that number, the corresponding field will be marked as ”-” or empty, allowing you to filter by condition.

---

Q: Can I export only “active and male” Telegram numbers?

A: Yes. Before export, the system usually supports secondary filtering of the screening results. You can also download the raw data (CSV) locally, filter using Excel, and then save as a new file. If in doubt, refer to the documentation or contact support.

---

Q: Can I customize which fields to output after export?

A: Currently, KK-DATA supports selecting fields before export (e.g., export only number and tgid) to reduce redundancy. For specific operations, refer to the actual console interface or check the User Documentation.

---

Q: Do the exported numbers include the international country code?

A: Yes. All exported numbers are in complete E.164 format (including the + sign and country code), making them ready for bulk messaging, friend-adding, or API calls. If you need a different format, convert them locally after export.

---

Log in to the KK-DATA Console to experience the multi-format export feature, or consult the User Documentation for more field details. If you have questions, contact support at @kkdata_cc.