Complete guide to exporting valid TG numbers in the United States: CSV/TXT listing specifications, encoding settings and downstream import best practices

In overseas customer acquisition and community operations, US valid TG number (that is, a Telegram account that has been opened and can be reached) is the basic resource for precision marketing. However, after many teams complete the screening, due to issues such as mismatched export formats, coding errors, and confusing field mappings, the data cannot be smoothly imported into CRM, mass sending tools, or automated scripts, resulting in wasted screening costs. This article will take the KK-DATA platform as an example to analyze in detail the export specifications of US TG valid numbers, covering the meaning of CSV/TXT column names, encoding and delimiter selection, as well as practical precautions for downstream import, helping you achieve a seamless transition from “screen number” to “use number”.

What is a valid US TG number? What data fields are included in the filter results?

The so-called valid TG number in the United States refers to an account whose country is the United States (country code +1) and has been registered (i.e. “opened”) on the Telegram platform. KK-DATA’s multi-platform number screening function supports Telegram number activation detection, activity detection, gender identification, etc., and outputs structured data. The screening results are usually presented in table form, allowing you not only to get a string of numbers, but also to grasp the quality and profile of each number.

Basic fields: mobile phone number, country and TGID

• Mobile phone number (phone): International format, such as +12025551234, convenient for dialing directly or adding contacts.
• Country code (country_code): Automatically recognized as US, easy to filter by country.
• tgid: Telegram user’s unique identifier, used for subsequent precise operations (such as group memberships and private messages), and is more stable than a mobile phone number.

Status field: activation detection and activity

• Activated (status_registered): Boolean value, true indicates that the number has been registered with Telegram; false indicates that it is not registered. Valid TG number in the United States means this field is true.
• Activity (status_active): judged based on the latest online time, such as “active within 7 days” and “active within 30 days”. The higher the activity, the greater the reach rate.
• Gender and age: Some numbers can be used to infer gender and age group (such as “male” and “30-40”) through the gender recognition model, which is used for crowd targeting. Please note that the age field is a model estimate with non-ID card level accuracy and can be used for rough analysis.

Detailed explanation of KK-DATA export format: Differences and optimal settings between CSV and TXT

After completing the screening task in the KK-DATA console, you can choose to export the results in CSV or TXT format. Both formats have their own advantages and disadvantages and are applicable to different scenarios.

CSV export: column names, encoding and delimiters

CSV (comma separated values) is a standard format for structured data. Each column has an English column name and is suitable for importing into Excel, WPS, CRM systems, etc.

• Recommended Settings:

  • Encoding: UTF-8 with BOM. BOM (Byte Order Mark) allows Excel/WPS to directly recognize UTF-8 to avoid Chinese garbled characters.
  • Delimiter: comma (,). If there are commas in the number field or remarks, the column names will be misaligned - KK-DATA has escaped the content by default, so there is generally no problem.
  • Include header row: After checked, the first row will contain the column name (such as phone,country_code,tgid,status_registered) to facilitate field correspondence.

• Common column names (subject to the actual exported version of the console):

  Column name	Chinese meaning	Example
  phone	Mobile phone number (international format)	+12025551234
  country_code	country code	US
  tgid	Telegram UID	123456789
  status_registered	Whether it is enabled (true/false)	true
  status_active	Activity description (such as 7d_active)	7d_active
  gender	Gender speculation (male/female/unknown)	male
  age	age range	30-40

TXT export: Applicable scenarios for exporting numbers line by line

The TXT file has one mobile phone number per line, no header line, and no extra fields. Suitable for scenarios where only the number list is concerned, such as:

• Batch import Telegram group sending Bot (only pure numbers are accepted).
• Import the SMS platform for verification.
• Used as a “whitelist” or “blacklist” list.

Export column name meaning comparison table (quick reference)

The following are the common export column names and descriptions of the KK-DATA console to help you quickly map fields when importing downstream tools. The actual fields are subject to the task details page of the console. Different detection types (such as activation only, or activation + active + gender) will output different columns.

English column name	Chinese definition	Data type/example
phone	Mobile phone number (including country code)	String, such as +8613800138000
country_code	Two-digit country code	String, such as US, CN
tgid	Telegram user ID	Number, such as 123456789
status_registered	Whether Telegram has been registered	Boolean, true / false
status_active	Recent active period	String, such as 7d_active, 30d_active, inactive
gender	Inferred gender	String, male / female / unknown
age	estimated age range	string, such as 18-24, 25-34, 35-44
wsid	WhatsApp ID (only available when filtering WhatsApp)	Number
uid	Platform UID (such as Line, Zalo)	String

Notes on downstream import: CRM, mass email and Telegram automatic operations

After obtaining the standardized exported US valid TG number, the next step is to import various operating tools. Different tools have different data format requirements. Common scenarios and solutions are listed below.

CRM import: field mapping and batch append

• Field Mapping: Map phone to the “Phone” field of CRM; map gender to the “Gender” or “Category” field; map status_active to the “Activity Label” (for example, “7-Day Active” can be set to “High Activity”).
• Uniform format: The mobile phone number in the CSV contains the number +, but some CRM systems require pure numbers or remove +. Please replace it in batches in advance. You can use Excel or script to process it first.
• Batch append: To avoid timeout caused by importing very large files at one time, it is recommended to import in batches (such as 5000 items per batch).

Telegram Bot or community operation tool import

• Use tgid first: Most advanced Telegram Bots (such as group messaging and welcome bots) support adding users or sending messages through tgid instead of mobile phone numbers. Because the mobile phone number may change or the user’s privacy settings prevent searching by mobile phone number. You can extract the tgid columns from the CSV and export a separate copy of tgid.txt.
• Date Analysis: If the exported file contains a timestamp column (such as task creation time), please pay attention to whether the import tool supports the yyyy-MM-dd format to avoid garbled characters.
• Activity filtering: Cooperate with the status_active column to only import “7-day active” users to increase the message open rate.

Troubleshooting common export problems: garbled characters, missing fields, delimiter conflicts

Even if you strictly follow the recommended settings, you may still encounter problems in practice. The following are several high-frequency faults and their solutions.

• Garbled characters appear when opening CSV in Excel: UTF-8 encoding is not selected. Solution: Open the CSV with Notepad and save it as “UTF-8 with BOM” format; or directly modify the encoding options when importing into Excel (data → import from text/CSV → select UTF-8).
• Mobile phone number with spaces or special symbols: Some country numbers may contain spaces when exported (such as +1 202 555 1234). Solution: Use Excel “Find and Replace” to remove spaces.
• CSV Column Misalignment: If a piece of data contains commas and is not properly enclosed in quotes, it will cause column misalignment. Verification method: Open the CSV with a plain text editor and check whether the number of commas in each line is consistent. If it is inconsistent, check the data and correct it manually.
• Field is missing: The possible reason is that the field is not checked in the screening task detection type. Please return to the console and check the task configuration to ensure that the “Export Fields” contain the required columns.
• Each line of the TXT file is not a pure number: If “Include header row” is selected to export TXT, the actual output is still in CSV format with column names. Please make sure to select “Plain Text” or “Untitled Row” when exporting.

How to verify the quality of exported data? Small batch testing methodology

Before putting all US valid TG numbers into official marketing, it is strongly recommended to conduct small batch verification first.

1. Sample extraction: Randomly select 50-100 numbers from the screen number results and export small files separately.
2. Import Target Tool: Import the CRM or Bot according to the above process, and check whether the fields are complete, whether the mobile phone number format is correct, and whether the activity tags are correctly parsed.
3. Compare Preview: Compare the “Task Result Preview” in the console with the exported file to ensure that the data is consistent. For example, if 1,000 activations are displayed in the preview, the number should be the same after exporting.
4. Send test: Use 2-3 numbers to send a test message (such as “Hello, this is a test”), confirm that it can be successfully delivered, and observe the feedback (delivered, read, blocked, etc.).

If the test passes, the full amount of data will be officially imported. This step can avoid batch failures caused by formatting or encoding issues and save a lot of troubleshooting time.

Summary: Unlock the value of valid US TG numbers in a standard format

From screening to exporting to downstream applications, data specification at each step directly affects the final marketing efficiency. This article introduces in detail the export format, column name meaning, encoding settings and common problem troubleshooting methods of US Valid TG Number to help overseas teams avoid rework due to data format errors. The KK-DATA platform provides flexible CSV/TXT export options, and with the data deduplication warehouse, it can efficiently complete the complete link from “generate number → screen number → export → deduplication → import”.

Only by mastering the standard export skills can the US TG valid number in your hand be truly transformed into reachable customer assets. Log in to the console now and experience a standardized export.

👉Log in to the console to start screening numbers 👉 Two-way contact customer service: https://t.me/kkdata_robot

FAQ

**Q: In the exported CSV file, which column is the mobile phone number? ** Answer: The column name is phone, and the format is usually an international format, such as +1xxxxxxxxxx; it is recommended to check whether the country code is included before importing to downstream tools.

**Q: What should I do if Chinese garbled characters appear when opening a CSV file using Excel? ** Answer: Please make sure that the “UTF‑8 with BOM” encoding is selected when exporting; if it is still garbled, you can first open the CSV with Notepad, save it as “UTF‑8 with BOM” format, and then open it with Excel.

**Q: Is each line of the exported TXT file a number? Is there additional information included? ** Answer: When exporting pure TXT, each line contains only one mobile phone number, without a title line or other fields. If you check “Include header row” and then select TXT, the content in CSV format will actually be output. It is recommended to select “Untitled row” when exporting to get a pure number list.

**Q: Are the gender and age fields in the filter results accurate? ** Answer: The gender and age fields are based on model speculation, with non-ID card level accuracy. They can be used for crowd portrait analysis, but are not recommended as the only basis for precise targeting. It is recommended to make a comprehensive judgment based on fields such as activity level.

**Q: Can I sort by date field directly after exporting? ** Answer: If the task result contains a timestamp column (such as created_at), the format is yyyy-MM-dd HH:mm:ss, and most tools can recognize and sort it directly. If you need to sort by active days, you can use the status_active column for group filtering.