Complete Guide to CSV Number Range Import: Detailed Steps to Batch Generate Numbers with Custom Prefixes (KK-DATA Tutorial)

In overseas customer acquisition and community operations, batch obtaining phone numbers for specific number ranges is the first step in precision marketing. Whether you need to batch generate valid Telegram numbers for a specific country/region or prepare data sources for WhatsApp marketing, the CSV number range import feature allows you to start from scratch and customize a number pool on demand.

This article will fully explain: what CSV number range import is, standard format specifications for CSV files, the complete import process, and how to integrate with the number screening module to form a “Generate → Screen → Export” data pipeline.

What is CSV Number Range Import and Why is It Suitable for Batch Customer Acquisition?

CSV number range import means uploading a CSV file containing information such as number prefixes, country codes, and starting ranges, and the system quickly generates all numbers within the corresponding range based on regex rules. Compared to manual input or “random generation,” CSV number range import offers three major advantages:

• Flexible Customization: You can precisely control each prefix and number range, covering specific operators or regions.
• Batch Efficiency: Upload once, and the system automatically generates thousands or even hundreds of thousands of numbers in bulk, saving a lot of manual concatenation time.
• Seamless Screening Integration: After generation, the results can be sent with one click to the screening modules for Telegram, WhatsApp, iMessage, etc., without needing to export and re-import.

For teams that need to customize the generation of Cambodia +855 specific number ranges or Nigeria +234 specific operator number ranges, CSV import is the most direct and controllable generation method.

Preparation: CSV File Format Requirements and Specifications

Preparing the CSV file correctly is a prerequisite for successful import. If the format is wrong, the system will directly reject it or generate empty data.

CSV Column Names and Data Format Details

The KK-DATA system requires the CSV file to contain the following columns (column names are case-insensitive, but it is recommended to follow the naming strictly):

Column Name	Data Type	Description	Example
prefix	string/number	Number prefix, usually country code + operator number start	86138 (China Mobile 138 range)
country	string	Country code (numeric form)	86 (China), 1 (US), 44 (UK)
start_number	number	Starting value of the number range	1000 (if prefix=138, suffix starts from 1000)
end_number	number	Ending value of the number range	9999 (if prefix=138, suffix ends at 9999)

Example row:

prefix,country,start_number,end_number
86138,86,1000,9999

This row will generate all numbers starting with 138 with suffixes from 1000 to 9999, totaling 9000 numbers.

Encoding, Size Limits, and Duplicate Handling

• Encoding: The CSV file must be saved in UTF-8 encoding. On Windows, it is recommended to use Notepad or VS Code to save as UTF-8 to avoid garbled text causing import failure.
• Single file row limit: Refer to the prompt in the console (currently supports up to about 1 million generation tasks per batch, but CSV rows should not exceed tens of thousands, otherwise generation time may be too long due to too many prefixes).
• Avoid duplicate imports: Importing the same number ranges multiple times wastes resources and generates many duplicate numbers. It is recommended to deduplicate locally before uploading, or use the data deduplication warehouse feature in KK-DATA to automatically deduplicate before screening.

Step-by-Step Guide to Import CSV Custom Prefixes to Generate Numbers

The following steps are based on the KK-DATA console, and the entire process can be completed within 5 minutes.

Log in to the Console and Enter the Generation Module

1. Visit the Application Console, log in with your account/password or Telegram quick login.
2. In the left navigation bar, find the “Number Generation” module and click to enter.

Upload CSV File and Configure Generation Parameters

3. On the generation module page, click the “CSV Import” button (do not click “Random Generation”).
4. Select the CSV file you have prepared. The system will automatically parse and preview the column mapping. If the column names match, the mapping status will turn green.
5. Optional configuration: For some number ranges, you can set “Number of numbers generated per prefix.” For example, if the prefix column corresponds to multiple number ranges, you can set a maximum of 100 numbers per range to avoid excessive total numbers. By default, all numbers from start_number to end_number are generated.
6. Confirm that the “Estimated total generated” in the preview is reasonable. If not, check whether the start_number and end_number in the CSV row are incorrectly filled.

Submit the Task and View Results

7. Click the “Submit Generation” button. Generation is free, and no balance is consumed.
8. Wait for a few seconds to several minutes (depending on the number of ranges), and view the generation status in the task list. When the status changes to “Complete,” you can see the generated number list.
9. At this point, you can “Export” the generated results or directly click the “Send to Screening” button to push this batch of numbers to the screening module with one click.

How to Quickly Screen Valid Numbers After Generation?

Generating numbers is only the first step in data preparation. To make the numbers truly usable, you need to check their validity.

1. In the generation result list, select the desired number batch and click “Send to Screening”.
2. In the screening module, choose the detection platform (Telegram, WhatsApp, iMessage, etc.), detection type (registered, valid, active, gender recognition, etc.).
3. After configuration, confirm the estimated charge amount (see real-time price in the console) and submit the screening task.
4. After completion, view the status in the screening results (e.g., “Telegram valid”, “Telegram active”). You can filter by conditions and export as CSV or TXT.

This completes the “CSV Import → Generate → Screen → Export” closed loop.

Practical Scenario: Full Process from CSV Import to Screening Export

Assume you need to prepare data for a Philippine market campaign, aiming to obtain Telegram active users across all number ranges.

Step 1: Prepare CSV

• Search and collect the main prefix ranges for the Philippines +63 (e.g., 63905, 63906, 63917, etc.).
• For each prefix, specify the suffix range: start_number=1000000, end_number=9999999.
• CSV content:

  prefix,country,start_number,end_number
  63905,63,1000000,9999999
  63906,63,1000000,9999999

Step 2: Import and Generate
Upload the CSV in the console’s generation module. An estimated 20 million numbers will be generated (adjust the range as needed). Generation is free; wait a few minutes.

Step 3: Send to Screening
Select all generated results and click “Send to Screening”. Choose platform “Telegram”, detection type “Active (within 30 days)”.

Step 4: Export Results
After screening, export the active results as CSV. This batch of numbers can then be used for Telegram group invitations or direct message promotions.

Common Errors and Pitfall Avoidance Guide

• Incorrect CSV column order: The system relies on column names, not column order, but it’s recommended to arrange as prefix, country, start_number, end_number to avoid confusion.
• Missing country code: Omitting the country column will cause the system to fail in matching international rules, leading to generation failure.
• start/end values reversed: If start_number > end_number, the generation result will be 0. Ensure start ≤ end.
• Direct screening after generation without deduplication: If you generate the same number range multiple times, the results will contain duplicate numbers. It is recommended to use the data deduplication warehouse before screening to save screening costs.
• Wrong file encoding: The CSV must be UTF-8 without BOM, otherwise some numbers may be garbled.

FAQ

Q: Is there a length limit for the prefix in the CSV file?

A: Yes, prefix length is subject to system limits. Please refer to the documentation for details. It is generally recommended to keep the prefix length between 2-6 digits; if too long, the generation result may be 0 (because the system cannot match the number structure).

Q: Can I import number ranges from multiple countries into the same CSV?

A: Yes. Each row in the CSV should specify the country code (e.g., 86, 1), and the system will automatically match the number range rules based on the country. It is recommended to separate by country to avoid confusion. Different countries’ number ranges do not affect each other.

Q: Is there a charge for generating numbers via CSV? How is the screening fee calculated?

A: Number generation is completely free. Screening fees are deducted from your balance based on the number of items checked. Different platforms (Telegram, WhatsApp, iMessage, etc.) and detection types (registered, valid, active) have different unit prices. See the real-time prices in the console or the official billing page.

Q: Why is the number count zero after import?

A: Common causes include: CSV column names do not match (e.g., spelling errors), start_number is greater than end_number, incorrect prefix format (e.g., contains non-numeric characters), or the number range was already generated by another task but not parsed correctly. Please check these points and ensure the CSV file encoding is UTF-8.

Q: Can I control the exact number of numbers generated per prefix (instead of the full range)?

A: Yes. Before submitting the generation task, the system supports configuring the “maximum number of numbers generated per prefix.” If you don’t need the full range, you can set this parameter to avoid generating too many numbers.

---

With this guide, you should now have a complete understanding of the CSV number range import process from file preparation to screening and export. For more advanced custom reuse or automation, please check the KK-DATA documentation or contact customer service via Telegram @kkdata_robot. Log in to the Application Console and start building your efficient customer acquisition data pipeline today.