KK-DATA avatar KK-DATA

How to export Telegram filtering results to CSV/TXT? Complete tutorial and downstream usage guide

telegram筛号 导出 kkdata CSV TXT

How to Export Telegram Screening Results to CSV/TXT? Complete Tutorial & Downstream Usage Guide

After completing a Telegram number screening task, you’re faced with a batch of verified valid numbers, active users, and even gender tags. However, the key step to truly unlocking the value of this data is to export the screening results in a structured format and integrate them into your CRM, bulk messaging tools, or data analysis systems. This article uses the KK-DATA platform as an example to detail the complete process of exporting Telegram screening results, the rationale for choosing between CSV and TXT formats, and practical advice for downstream usage, helping you manage lead acquisition data efficiently.

Why Export Telegram Screening Results?

Screening itself is just an intermediate step in data cleaning; the exported data is the foundation for building your customer assets. Without exporting, all detection results remain within the platform and cannot be called by business systems. Therefore, “exporting Telegram screening results” is the bridge connecting data acquisition with actual marketing.

From Screening to Customer Assets: Three Main Uses of Exported Data

  1. Bulk Import into WhatsApp/Telegram Bulk Messaging Tools
    ”Valid” or “Active” numbers from screening results can be directly imported into bulk messaging systems for precise targeting. For example, export a list containing only “active and male” users for a campaign targeting a male audience.

  2. Import into CRM Systems
    Upload the exported CSV file to your CRM, which will automatically match or create customer records based on phone numbers. You can also use fields like “gender” or “last online time” to tag contacts, making follow-ups and conversions more targeted.

  3. Backup and Audit
    Keep original export files from each screening task for reconciliation: for instance, check how many numbers were actually valid out of 10,000 tested, or verify data quality differences across batches during operational reviews.

Why Choose CSV or TXT Over Other Formats?

  • CSV (Comma-Separated Values): Offers the widest compatibility—almost all CRMs, data analysis tools, and Excel/Google Sheets can read it directly. CSV supports multiple columns, allowing you to carry information like number, status, gender, tgid, etc., making it easy to filter by condition later.
  • TXT (Plain Text): Has the smallest file size with no format dependencies, ideal for scenarios needing only a list of numbers (e.g., pasting directly into a bulk messaging tool). However, TXT cannot carry multiple attributes; if you need gender, activity level, etc., you must use CSV.
  • Other formats like JSON or Excel (.xlsx) are useful in specific cases, but CSV and TXT are the most universal formats in cross-border data operations, and they require no additional conversion after export.

How to Choose Between CSV and TXT Export Formats?

Which format you choose depends on your downstream tools and data processing needs. The comparison table below can help you decide quickly:

DimensionCSVTXT
Field CompletenessCan include multiple columns: number, status, gender, tgid, active days, etc.Only numbers (one per line)
CRM Import SuitabilitySupports field mapping, can auto-populate customer attributesCan only record numbers; manual info supplementation needed later
Bulk Messaging Tool SuitabilityRequires tool to support CSV parsing (some do)Almost all tools support plain text number lists
File SizeRelatively larger (includes header row and extra fields)Minimal, just numbers
Data Cleaning FlexibilityHigh—can filter, sort, group by columns in ExcelLow—requires extra processing to distinguish attributes

Recommended Scenarios:

  • Need gender/activity tags for segmented sending → Must use CSV. After export, filter the desired group in Excel, then import batches into your bulk messaging tool.
  • Only need to verify number validity and send to all → Use TXT directly; simple and straightforward.
  • Import into CRM to build customer profiles → Must use CSV to ensure complete fields.

How to Export CSV/TXT After Telegram Screening in KK-DATA?

The KK-DATA console provides a complete task management interface. Exporting takes only three steps. The following uses Telegram screening as an example; the process is the same for other platforms (WhatsApp, iMessage, etc.).

Step 1: Create and Submit a Screening Task

  1. Log in to the KK-DATA Console and go to the “Screening Task” module.
  2. Import numbers to screen: Upload a CSV/TXT file, or use the “Global Number Generation” feature to generate numbers by country or prefix. It’s recommended to unify number formats to international format (with a + sign) beforehand to avoid detection errors.
  3. Select detection types: Check options as needed, e.g., “Telegram Account Check,” “Telegram Validity Check,” “Telegram Activity Check (with 7/15/30 day window options),” “Gender Recognition,” “Export tgid,” etc.
  4. Click submit; the system will display an estimated cost based on your current balance. Confirm to start execution. If your balance is insufficient, you cannot submit—please top up first (USDT TRC20 supported).

Step 2: Choose Export Format After Task Completion

Once the task status changes to “Completed,” enter the task details page:

  • Click the “Export” button; a format selection window will pop up.
  • Choose CSV (all fields) or TXT (numbers only).
  • If you need to export tgid, CSV is the only option because tgid is an additional field that TXT cannot carry.

Export Format Tips

If your downstream tool requires a specific delimiter (e.g., tab), you can adjust the CSV delimiter in KK-DATA’s “Export Settings” before exporting. Supports switching between commas, semicolons, and tabs. See the User Documentation for details.

Step 3: Download File and Verify Data

  • Click download to get a .csv or .txt file.
  • Check encoding: UTF-8 encoding is recommended to avoid garbled Chinese characters when opening in Excel. If garbled, you can re-save the file as UTF-8 using Notepad before importing into Excel, or use Excel’s Data > From Text/CSV import and specify the encoding.
  • Deduplication suggestion: If the same batch of numbers has been used in multiple screening tasks, it is recommended to first merge and deduplicate via the “Data Deduplication Warehouse” before exporting, to avoid wasting balance and CRM space.

Example file name: telegram_screening_20250320.csv

How to Import Exported Data into CRM or Bulk Messaging Tools?

After obtaining the CSV or TXT file, the next step is to make it actually work. Below are import guides for two common scenarios.

Importing CSV into CRM (using a common system as example)

  1. Log in to your CRM, find the “Import Contacts” or “Import Customers” function.
  2. Upload the CSV file; the system usually parses field names (e.g., “number”, “gender”). You need to map CSV columns to CRM fields:
    • Phone number field → map to “Phone Number” field (note: numbers must include international country codes, e.g., +86138xxxx, otherwise the CRM might recognize them as domestic numbers)
    • Gender → map to “Gender” or “Tag” field
    • Active days → map to “Notes” or a custom field
  3. Set deduplication rules: It’s recommended to use the phone number as the unique identifier to avoid duplicate imports.
  4. Confirm the import; after completion, you can view and filter this batch of customers in your CRM.

Suggestion: Before exporting from KK-DATA, in the console’s “Number Format” settings, check “Include + sign international format” to ensure correct CRM recognition.

Using TXT Directly for Bulk Messaging Tools

  • Most WhatsApp/Telegram bulk messaging tools support importing a TXT file with “one number per line.”
  • Directly upload the file; the tool will automatically read the list of numbers.
  • ⚠️ Note: If you need to send differentiated messages by gender/activity (e.g., only to active females), you should export CSV, filter the desired rows in Excel, then copy the filtered numbers column into a new TXT file for batch import. TXT alone cannot distinguish attributes.

Common Encoding & Format Errors

If you see garbled text (like “鐢ㄦ埛”) in Excel after exporting CSV, it’s because Excel defaults to GBK encoding for UTF-8 files. Solution: Use Excel’s Data > From Text/CSV import and select UTF-8 encoding. Alternatively, when exporting, choose “CSV UTF-8 (BOM)” format in KK-DATA so Excel can recognize it automatically.

What to Pay Attention to When Exporting Screening Results?

  • Balance & Pricing: Exporting the file itself does not incur additional fees, but screening tasks are charged per number. Ensure the task status is “Completed” and the fee has been deducted before exporting, to avoid billing anomalies.
  • Field Completeness: Before exporting CSV, make sure to check the desired fields (e.g., gender, tgid, active days) in “Export Settings.” If you miss a field, you can simply re-export without being charged again.
  • Data Deduplication: If the same number has been tested in multiple tasks, the export will contain duplicate rows. It’s recommended to first merge and deduplicate via the “Data Deduplication Warehouse” before exporting, to avoid duplicate customers in your CRM.
  • Privacy Compliance: Exported phone numbers are personal data. Please store them securely and comply with data protection regulations of the target country/region (e.g., GDPR, CCPA). Do not use them for illegal marketing or resale.

Frequently Asked Questions

Q: Why are some fields missing when exporting CSV?
A: Before exporting, go to the “Export Settings” page and check the fields you need (e.g., gender, tgid, active days). By default, only “number” and “status” columns are exported; you must manually enable additional fields.

Q: What if the CSV shows garbled text when opened in Excel?
A: Excel defaults to GBK encoding for UTF-8 files, causing garbled output. It is recommended to use Data > From Text/CSV import and select UTF-8 encoding. Alternatively, when exporting from KK-DATA, select the “CSV UTF-8 (BOM)” format, which Excel can recognize directly.

Q: The numbers in the exported TXT file have inconsistent formats (some with +, some without)?
A: Before submitting the screening task, you can choose “Include + sign international format” or “No prefix” in the number format settings. It’s recommended to unify to the format with a + sign to ensure compatibility with most CRMs and bulk messaging tools. If you’ve already exported an inconsistent file, you can use a text editor’s search-and-replace function to add the + sign consistently.

Q: Can I export the same batch of data multiple times after screening is complete?
A: Yes. Completed tasks can be exported again at any time from the history task list, with no limit on the number of exports and no additional charge. You can export the same results in different formats at different times (first CSV, then TXT).

Q: How do I export only numbers that meet certain criteria (e.g., only male users with active days ≤ 7)?
A: First, enable “Telegram Activity Check” and “Gender Recognition” in the screening task. After the task completes, export as CSV. Then open the CSV in Excel and use the filter function: set “Gender” to “Male” and “Active Days” ≤ 7, then copy the filtered “Number” column. If you need a TXT file, paste the filtered numbers column into a .txt file.


We hope this tutorial helps you successfully export Telegram screening results and use your data efficiently. Try exporting your first batch of screening results now:

👉 Log in to Console to Start Screening
Contact support: https://t.me/kkdata_robot

If you encounter any other issues during export or downstream import, feel free to contact KK-DATA support (Official Channel or Customer Service Telegram). We’ll provide technical assistance.