How to export after tg filtering is completed? CSV/TXT field selection, naming convention and downstream usage

When you complete a Telegrams filtering (tg filtering) task and get a list of “activated/active/male” numbers, the real operation work has just begun. How to efficiently export this batch of data, correctly interpret the fields, and smoothly import it into CRM or mass messaging tools directly determines whether the investment in screening numbers can be converted into new users. This article will start with each field in the exported file and teach you step by step the entire process of data implementation after tg filtering.

For a complete tg filtering task, what fields are included in the export file?

After submitting the Telegrams filter task in the KK-DATA console, the exported CSV or TXT file will contain multiple fields. Each field has a clear business meaning, and understanding them can help you accurately filter out “reachable numbers.”

Core field analysis: mobile phone number, tgid, registration status and activity

Field name	Meaning	Business value
Mobile phone number	The number bound when the user registers for Telegram	Used for targeted contact on other platforms (such as WhatsApp)
tgid	The unique numeric ID in the Telegram system	It is an accurate identification for adding friends/private messages and does not change when the connection is changed
Registration status (activated/unactivated)	Whether the number is registered with Telegram	The registration will be passed, and the unactivated ones will be discarded directly
Activity (active/inactive)	Whether there is online behavior within the specified time window	Active users are the effective targets to avoid wasting time

Usage Suggestions: If you want to trigger a private message or join a group, give priority to using tgid instead of mobile phone number - the tgid will not change after the user changes his mobile phone number, but the mobile phone number may have expired. If it is exported and used on other platforms (such as WhatsApp promotion at the same time), just keep the mobile phone number list.

Optional field analysis: filtering logic for gender and age group

When you choose to detect Gender or Age, the export file will have additional fields for Gender (Male, Female, Unknown) and Age (such as age range or inferred approximation).

For example, if you plan to promote a game for “men around 30 years old”, you can select the “gender + age” test when screening numbers, and then filter the exported file for male numbers with an age field between 28-35. This fuzzy targeting is accurate enough to support bulk marketing, but don’t expect it to identify each individual’s true age.

How to select the appropriate tg filter export format and fields based on the needs of downstream tools?

CSV and TXT are the two most common export formats, and each has its own applicable scenarios. Choosing the wrong format may result in import failure or data corruption.

CSV format: suitable for data analysis and CRM import

CSV files separate fields with commas and are natively supported by tools such as Excel, Google Sheets, Notion, and HubSpot. When you need to perform secondary analysis on the filter results - such as grouping by country, sorting by activity, tagging - using CSV and retaining all fields is the best choice.

Operation Suggestions:

• Check all required fields (mobile phone number, tgid, gender, activity level, etc.) on the KK-DATA task details page
• After exporting, drag it directly into Excel and use pivot tables or filters to quickly view crowd distribution
• If you need to import CRM, you usually need to keep the field order consistent with the template; you can use the “Text Column” function of Python or Excel to adjust after exporting.

TXT format: suitable for batch import of group sending or group adding tools

Many group messaging software (such as TG bots, WhatsApp broadcast tools) only accept TXT files with one number per line. At this time, only the “mobile phone number” or “tgid” column should be retained to reduce the file size and import error rate.

Operation Suggestions:

• Select “TXT export” when exporting, and remove all non-essential columns in the field configuration
• If the exported TXT file contains multiple fields per line (such as 13800138000,true,active), please use the text editor’s “Find and Replace” function after exporting to replace the commas with newlines, or keep only the mobile phone number part
• For large tasks (100,000+ rows), the TXT format is significantly faster to read and write than CSV

Naming specifications and archiving suggestions after exporting tg filter files

When multiple people collaborate or multiple rounds of screening occur across projects, confusing file names are the most likely problem that leads to duplication of work. The following is a set of battle-tested file naming rules:

{项目简称}_{目标人群}_{平台缩写}_{筛号日期}.csv

Example: UK_ProjectA_TG_Male_20250320.csv

• Project abbreviation: easy to put into corresponding folders
• Target group: such as male/female/active
• Platform abbreviations: TG (Telegram), WA (WhatsApp), LI (Line)
• Screen number date: must be retained for backtracking and deduplication

In addition, KK-DATA provides a data deduplication warehouse function. The numbers you generate in different batches of screening numbers will be automatically compared to avoid repeated payment for the numbers that have been tested. It is recommended that after each export, the task ID in the file name be recorded in a local table to facilitate subsequent joint management of the duplicate warehouse.

Overseas operations: In what real scenarios is tg filtered export data used?

The ultimate goal of tg filtering is to convert the filtering results into actual growth. The following three typical scenarios can help you understand the entire data flow:

1. TG community precise recruitment: Screen out users who have opened Telegram and are highly active from the number pool in the target country/region, export the tgid list and import the automated group joining tool to invite targeted invitations to your community. Combined with the gender/age group field, the quality of the community can be further improved.
2. Cross-border e-commerce private domain traffic: For target users who have activated WhatsApp (can be cross-referenced with Telegrams screening results), export the CSV file and import it into the WhatsApp mass messaging tool to send product discounts or new product notifications. Use the activity field to block silent users and increase the reply rate.
3. Game promotion in Southeast Asia: In markets such as Vietnam and Thailand, first obtain gender + age data through Zalo or Telegrams filters, export the data in TXT format and then import it into official promotion channels to achieve low-cost regional distribution.

tg filter export files, common “pits” when importing downstream tools

Even if the fields and formats are selected correctly, some technical problems will still be encountered in actual operation. The following are high-frequency pitfalls and solutions:

Problem	Cause	Solution
Chinese characters are garbled after CSV is opened	Encoding mismatch (Excel defaults to GBK, but the file is UTF-8)	When importing, select “Data → From Text/CSV” and specify UTF-8 encoding; or use Notepad to save as UTF-8 with BOM
The TXT file is too large, causing the import to time out	A single file exceeds 50MB or has too many lines	Use a splitting tool (such as the split command) to split it into sub-files within 100,000 lines and import in batches
Field order mismatch leads to misaligned data	Exported fields are inconsistent with tool templates	Check the column order required by the tool before exporting; if it has been exported, use Excel to reorder the columns
The mobile phone number format is inconsistent (with +86 or without)	Different tools have different requirements for the mobile phone number format	Use regular expressions to remove ”+” and spaces, and keep pure numbers; some tools require a ”+” sign before the country code, process it as needed

It is recommended to test with 100 pieces of data before importing, and then import all the data if it is correct.

CSV export vs TXT export, how to choose the right format?

Table comparison helps you make quick decisions:

Compare dimensions	CSV export	TXT export
File size	Larger (with delimiters and header lines)	Smaller (usually just numbers)
Readability	With table header, easy to use Excel to view	No structure, suitable for program reading
Compatibility	Supports CRM, database, data analysis tools	Supports group sending tools, group joining scripts
Difficulty of secondary processing	Low, can be filtered and pivoted directly	Medium, code or regular processing is required
Recommended scenarios	Data analysis, CRM import, multi-field filtering	Batch mass sending, group joining, and docking automation tools

One sentence summary: **If you need to do crowd analysis or multi-platform cross-comparison in the future, choose CSV; if you just import the mass sending tool to start reaching, choose TXT. **

Why should you choose the tg filtering platform with item-by-item billing and multi-format export?

The core value of the tg filtering platform lies in its flexibility and cost control. Pay-per-item billing (no subscription plan) means you can top up for one event as long as it’s used up, and you don’t have to be tied to a monthly plan. Multi-format export (CSV/TXT) ensures that the data can be seamlessly adapted to your existing tool chain without the need for additional format conversion.

KK-DATA is a typical representative of this type of platform: it supports Telegrams screens (open, active, gender and age), cross-platform screens (WhatsApp, Line, Zalo, etc.), and provides CSV and TXT dual format downloads. Before each task submission, the console will display the estimated deduction amount, so you have an idea of ​​the cost.

FAQ

**Q: What is the difference between the tgid exported by tg filtering and the mobile phone number? Which one should be used? ** Answer: tgid is the unique identifier (numeric ID) in the Telegram system, and the mobile phone number is the number bound to the user when registering. If you want to add friends or send private messages in a targeted manner, it is recommended to use tgid first, because the mobile phone number may become invalid due to user changes; if it is used for precise contact on other platforms, just keep the mobile phone number.

**Q: What should I do if the exported CSV file is too large and cannot be opened with Excel? ** Answer: You can try the following methods: ① Select only necessary fields before exporting (such as only importing mobile phone number and tgid) to reduce the amount of data; ② Split the file into multiple sub-files with less than 100,000 lines; ③ Use a professional database or text editor (such as Sublime Text, VS Code) to process extremely large CSV files.

**Q: How accurate is the “gender” detection of tg filter results? ** Answer: Gender data is comprehensively inferred based on the user’s Telegram avatar, nickname, public information and other information. The accuracy is usually high, but it cannot reach 100%. It is recommended to use other tags (such as the type of group the user is in) together with other tags (such as the type of group the user is in) for crowd targeting instead of relying solely on the gender field.

**Q: I want to filter Telegram and WhatsApp numbers at the same time. Can I export them at once? ** Answer: The KK-DATA platform supports cross-platform filters (Telegram, WhatsApp, Line, Zalo, etc.), but the exported data is displayed separately by platform, and you need to download the CSV/TXT files separately. It is recommended to mark the platform suffix (such as *_TG.csv *_WA.csv) when naming to facilitate management.

**Q: The exported TXT file has only one number per line. What should I do if I need it to be in a “comma separated” format? ** Answer: You can use the “Find and Replace” function directly in a text editor (such as Notepad++): replace the newline character (\r\n or \n) with a comma (,) to quickly convert it into a comma-separated line. However, it is recommended to keep the TXT format with one number per line, because most mass sending tools are compatible with this format.

---

If you want to apply the tg filtering practical methods mentioned in this article directly to your customer acquisition project, you may wish to try the filter number and export functions of KK-DATA.

👉Log in to the console Start your first screening and export task If you have any questions, please feel free to contact customer service in both directions https://t.me/kkdata_robot For more function introduction and operation guide, please refer to Official Documentation