Complete guide to exporting U.S. TG numbers to CSV/TXT: field selection, naming conventions and downstream usage suggestions

When acquiring customers in the US market, have you ever encountered this dilemma: you have a batch of US mobile phone numbers, but you don’t know which ones are registered Telegram users, which ones have been active recently, and which ones are male or female? If you can batch verify these numbers and export them as structured files (CSV/TXT), you can greatly improve the efficiency of subsequent mass sending, private messages or CRM import. This article will break down how to efficiently export the US TG activation number from field selection, file naming, export process to downstream use, and recommends using KK-DATA to complete this series of operations.

What is US TG number export? Why should you care about CSV/TXT format?

US TG number export refers to: using the number screening platform to conduct mixed detection on a batch of US mobile phone numbers (such as TG registration status, activity, gender, etc.), and download the list of qualified numbers together with additional fields as a local file. Common export formats are CSV (comma separated values) and TXT (plain text).

• CSV: Can contain multiple columns (mobile phone number, TGID, gender, active days, etc.), suitable for importing into Excel, CRM, Google Sheets or database for secondary analysis.
• TXT: usually only contains mobile phone numbers, one number per line; small in size, easy to be directly read by batch adding group/private message scripts.

Both formats are industry standards and supported by almost any downstream tool. For overseas teams that need to accurately target US users, exporting US TG numbers to CSV/TXT is a bridge between data screening and marketing execution.

When exporting US Telegram numbers, what key fields should be selected?

When creating a screening task in the KK-DATA console, you can check multiple detection types to get rich fields in the export results. The following lists common fields and their value to downstream businesses (specific fields are subject to actual display on the console):

Basic fields: mobile phone number, country code, TGID

• Mobile phone number (phone_number): The core identifier of each piece of data, used to add friends later or import group sending tools.
• Country code (country_code): Fixed to the US code “1”, which can be used for traceability or regional grouping.
• TGID(tg_id): Unique numeric ID assigned by Telegram. If you plan to add friends or call Bot commands through the API, the TGID is more stable than the mobile phone number (the mobile phone number may change or be coded), so it is recommended to export it together.

Advanced filtering fields: activity, gender (including age field), registration status

• Activity (active_flag / active_day_30, etc.): Detect whether the number is active within the specified time window. For example, “30 days active” reaches more users than “7 days active”, but the response rate may be lower. You can choose the window based on your own push frequency. Activity data determines the reach rate. Inactive numbers are likely to be ignored or even reported by users after sending private messages.
• Gender: Identified as male/female. In the gender detection results of KK-DATA, there is also an age field** (such as “age”), which can be used to screen people around 30 years old. Note: The age is based on public data and algorithm inference. It is not ID card-level accuracy, but it is effective enough as a reference for crowd portraits.
• Registered status (registered_flag): Make sure the number is indeed a Telegram activated user. If this field is not checked, non-registered numbers may be mixed in, which will waste subsequent private message fees.

How to standardize the naming of US TG number export files to avoid data confusion?

When multiple people collaborate or export in multiple batches, if the names are not unified, it will be very painful to find the historical files later. The following naming convention is recommended:

File naming rules: time + filter conditions + platform suffix

For example:

• US_TG_Active_30d_Male_20250401.csv
• US_TG_Registered_202503_Female.csv
• US_TG_All_Filtered_2025Q1.txt

Advantages of doing this:

• Sort by time: File names with dates can avoid overwriting historical data.
• Platform logo: TG (Telegram) is different from other platforms such as WhatsApp and Line.
• Filter conditions: Active, Male, etc., clearly distinguish the purposes.

Field column name specifications: unified English capitalization or camel case, avoid spaces

If your downstream is a Python script or Node.js program, it is recommended to use English column names without spaces, for example:

Recommended listing	Description
phone_number	Mobile phone number, with international code (such as +1xxxxxxxxxx)
country_code	Country code (1)
tg_id	Telegram ID
registered	registration status (true/false)
active_30d	Whether active within 30 days (true/false)
gender	Gender (male/female/unknown)
age_group	Age group (such as 18-24, 25-34)

Avoid using Chinese or column names with spaces (such as “Phone Number”), otherwise Excel can display normally, but some scripts will report errors due to spaces when reading. If manual processing is required and the CSV is encoded in UTF-8, it is recommended that English is also used inside the fields.

How can the exported US Telegraph number be used in downstream customer acquisition scenarios?

The following are three classic usages, which can further improve efficiency when combined with fields in CSV/TXT:

Scenario 1: Adding groups in batches

If you have a batch of TGIDs of US TG numbers on hand, you can add them to the channel or group you create through the Telegram API (such as Telethon). It should be noted that TG has restrictions on the frequency of adding groups. It is recommended to limit the number of accounts to dozens of accounts per day and the number of groups added to each account. First use the activity field in the CSV to exclude inactive numbers to avoid invalid additions.

Scenario 2: Directed private message

For marketing teams with a large number of numbers, the filtered male/female numbers can be exported separately and pushed with different copywriting. For example, Bluetooth headsets are promoted to male users, and beauty products are promoted to female users. Use the age field (about 30 years old) to further segment and improve conversions.

Scenario 3: Data cleaning and deduplication

Numbers exported in different batches may be duplicated, which wastes subsequent testing/private message fees. KK-DATA’s built-in data deduplication warehouse can automatically remove historical detected numbers before submitting tasks. It is also recommended to use Excel or script to remove duplicates after exporting to ensure that the data sent to customer service or tools is pure.

Data Compliance Tips: When using screens and private messages, please comply with the privacy regulations of the target country (such as US CAN-SPAM, TCPA). TG users have a low tolerance for marketing private messages, so it is recommended to use mild CTA and provide an unsubscribe method.

What is the specific process of using KK-DATA to export the US TG activation number?

The following are typical operation steps (subject to KK-DATA application console):

1. Log in Console → Enter the “Screen Number” module.
2. Create a new task → Select the country as “United States”.
3. Platform selection → Check “Telegram”.
4. Test type → Check “tg activation” (register for test), “tg active” (can set 7-day/30-day window), “tg gender”, etc. If you only need to activate a number, you can only check the first one.
5. Number source: You can choose “Upload Number List” or use “Global Number Generation” (generate a US mobile phone number for free). Screen number tasks can be directly imported after generation.
6. Submit the task after completing the settings. The system will notify you via Telegram after the task is completed (you need to bind it in advance).
7. Task details page → Click the “Export” button and select the format CSV or TXT. UTF-8 is recommended for encoding. Download to local.

What are the common mistakes to avoid when exporting US TG numbers?

• Specific countries are not checked: The number filtering task may cover global numbers by default. If you only want the United States, be sure to select “United States” in the country filter and exclude other regions.
• Insufficient balance: The estimated fee will be displayed before the task is submitted, but the actual deduction will occur after completion. If the balance is insufficient, the task will be suspended. Make sure you recharge enough (see console real-time price for details).
• Excessive field selection leads to time consuming: The more fields to be detected, the longer the task processing time will be. It is recommended to check as needed to avoid checking more than a dozen test items at once.
• Confusing batches after exporting: Each task has a unique ID. It is recommended to add the task ID or date to the file name to avoid confusion with other batch numbers.

How to evaluate the data quality of exporting US TG numbers?

• Activity window selection: 7-day active numbers have the highest reach rate, but are small in number; 30-day active numbers cover most real users, but may include semi-abandoned accounts. For first-time users, it is recommended to test the 30-day window and observe the response rate before making adjustments.
• Gender recognition accuracy: KK-DATA’s gender field is based on public information and model inference. The accuracy is usually higher than 80%, but not 100%. For niche users or users with strict privacy settings, “unknown” may be returned. It is recommended to verify multiple batches and not rely entirely on one field.
• The role of the deduplication warehouse: Import historical numbers into the deduplication warehouse, and automatically skip the detected numbers when submitting new tasks later, which saves money and avoids duplication.

You can also export a small batch (for example, 100 numbers) for manual verification before deciding whether to use it on a large scale. The cost of small batch testing is extremely low (fees are charged per item), but it can help you evaluate data quality.

FAQ

**Q: After exporting the US TG number, can it be used in the batch group joining tool? ** Answer: Yes. The exported CSV/TXT file contains the complete mobile phone number (or TGID). Most tg group sending tools support direct import of number lists. Note that the field format must match the tool requirements (such as one number per row in pure number TXT, or CSV with TGID column).

**Q: Can the “age” in the exported field be accurate to the ID card level? ** Answer: No. The age field in the gender detection results of KK-DATA is based on public data and algorithm inference, and can be used to screen portraits of people around 30 years old. It is not official real-name information, so please use it as a reference.

**Q: How many pieces of data can the export file support at most? ** Answer: The upper limit of the number of rows exported at a time is approximately 1 million. The actual number is subject to the console prompts when submitting the task. If the limit is exceeded, it is recommended to export in batches and use the data deduplication warehouse to avoid duplication.

**Q: Why is the CSV I exported garbled when opened? ** Answer: It is recommended to use UTF-8 encoding for export. When Excel is opened, select “Data → From Text → Select UTF-8 Encoding” to display it normally. It is recommended to use a professional editor (such as VS Code) to preview.

**Q: Can I re-filter or add fields after exporting? ** Answer: Exported numbers can be resubmitted to the number screening task for additional testing (such as only adding activity), but fees will be deducted again. It is recommended to check all required fields at once when exporting for the first time to reduce repeated costs.

---

If you are also looking for an efficient way to obtain the US TG activation number and export CSV/TXT, you might as well try KK-DATA. It supports global 240+ country number generation, Telegram/WhatsApp and other multi-platform screening numbers, billing by item without package, and one-click export of structured files after the task is completed.

👉 Try it now: Log in to the console https://app.kkdata.cc/ Two-way customer service contact (recommended): https://t.me/kkdata_robot More functional documents: https://docs.kkdata.cc/ Official website: https://kkdata.cc/