Complete Guide to CSV Import for Number Filtering: Custom Number Segment Upload and Batch Detection Instructions

In overseas user acquisition and community management, batch-verifying the validity, activity, and platform of numbers is a high-frequency operation. Whether you have a list of potential leads collected from trade shows or user phone numbers exported from event registration forms, you need an efficient and accurate way to import these numbers into the system for filtering.

CSV Import for Number Filtering is the core feature that addresses this need. By uploading a CSV file in the correct format, you can submit your own list to the platform at once and complete multi-platform detection (Telegram active, WhatsApp valid, iMessage available, etc.), avoiding manual input errors and seamlessly integrating with the custom number segment generation function to form a complete pipeline from data acquisition to verification.

This article uses the KK-DATA platform as an example, providing a step-by-step executable guide from preparing the file to exporting results.

Why Do You Need CSV Import for Number Filtering?

For data-driven overseas teams, the value of a number depends on its authenticity and usability. If you directly use unverified lists for private message promotions or community invitations, you may waste delivery costs at best or get your account flagged or banned at worst.

Batch Verify Your Own Lists and Avoid Manual Input Errors

When you have a list of hundreds or thousands of customer/potential user numbers, manual input is not only time-consuming but also prone to errors (e.g., typing an extra digit, missing the country code). CSV import allows you to directly reuse existing data from spreadsheets (such as customer lists exported from CRM, registration numbers collected from offline events, or lists purchased from third-party platforms), fundamentally eliminating wrong numbers caused by manual entry.

Custom Number Segment Filtering for Precise User Acquisition

If you don’t have an existing list yet, you can first use the platform’s Global Number Generation module (supports random generation for 240+ countries/regions, number segment generation, or custom number segment CSV import), download the generated numbers as a CSV file, and then upload them for number filtering. This “generate → filter” workflow is especially suitable for large-scale targeted detection in specific markets (e.g., Southeast Asia, Middle East) to obtain a batch of high-activity target numbers.

Step 1: Prepare a CSV File That Meets Format Requirements

The most common reason for upload failure is that the file format does not comply with specifications. Prepare your CSV file according to the following checklist:

• File format: Must be .csv format, preferably using UTF-8 encoding (to prevent non-ASCII character corruption).
• Column structure: The file must contain only one column of data, with the column name set to phone. Any other columns (e.g., name, address) will not be recognized and may cause parsing failures.
• Number format: Each number must include the international country code (e.g., China +86, USA +1) and must not contain spaces, hyphens, parentheses, or other delimiters. Correct example: +8613800138000.
• File size: A single task supports up to approximately 1 million numbers. It is recommended to keep the file within a reasonable range (e.g., within 100,000 numbers) for faster upload and processing. The specific maximum limit can be found in the console prompt.

If you are not familiar with the operation, you can export CSV using Excel or Google Sheets: place the numbers in column A, enter phone as the header, then save as .csv (comma separated) format.

Step 2: Log In to the Console and Create a Number Filtering Task

Log in to the KK-DATA App Console and navigate to the “Number Filtering” module.

Two Ways to Upload a CSV File

1. Drag and drop: Drag the prepared .csv file directly into the upload area.
2. Click to select: Click the upload area to choose a file from your local device.

After uploading, the system will automatically parse the file and display the total number of numbers it contains. You can check the first few numbers (e.g., country code, number length) in the preview box on the right to ensure they are correct.

Preview and Confirm After Upload

After confirming the preview is correct, click “Next” or “Confirm Upload.” The system will temporarily store this batch of numbers in the pending detection list.

Step 3: Configure Number Filtering Rules and Detection Options

This step determines which platforms you want to detect these numbers on and whether to use duplicate data protection.

Select Platforms and Detection Types

On the number filtering configuration page, you can choose from the following detection types (subject to the functions available in the console):

• Telegram Detection: registered (registration check), valid, active (optional windows of 7/15/30 days, etc.), gender identification (avatar recognition), tgid export.
• WhatsApp Detection: valid number detection, wsid export.
• iMessage / RCS Detection: specific platform detection for Apple or Android users.

You can select multiple platforms simultaneously. For example, uploading 5,000 numbers and detecting both Telegram activity and WhatsApp validity; the system will complete the detection sequentially and merge the results for output.

Enable Data Deduplication Repository

If you frequently perform number filtering in multiple batches, it is recommended to enable the Data Deduplication Repository function. It marks numbers you have previously detected as “already checked.” When duplicate numbers appear in a new task, the system will skip those numbers and not deduct balance. Combining CSV import with this feature can significantly improve the utilization efficiency of duplicate lists and avoid waste.

Step 4: Submit the Task and Wait for Number Filtering to Complete

After confirming the detection plan and estimated fee, click “Submit Task.” The task will enter a queue for real-time processing.

• You can view the progress of each task (queuing, processing, completed) in the “Task List” section of the console.
• To receive timely notifications, you can bind a Telegram notification in your personal settings; the system will automatically send you a message when the task is complete.

Step 5: Export Filtering Results and Best Practices

Once the task is complete, go to the “Task Details” page to download the result file.

Export Format and Data Interpretation

Supports export as CSV or TXT format. The result file contains the following key columns:

• phone: Original number
• platform: Detection platform (e.g., tg, whatsapp)
• status: Status, valid numbers show valid or active, invalid numbers show invalid
• active/ gender (for Telegram detection): Activity level or gender recognition result

The exported data can be directly imported into your CRM, edited for marketing push lists, or used as the basis for secondary filtering.

Best Practice: Combine with the Global Number Generation Module

To maximize efficiency, we recommend following this workflow:

1. Use the Global Number Generation module to generate a batch of numbers based on the target country/number segment (e.g., Thailand +66 number segment).
2. Export the generated numbers as a CSV file.
3. Upload that CSV file to the number filtering module and select dual-platform detection (Telegram + WhatsApp).
4. Export the results to obtain a precise list verified for activity and validity.

This pipeline allows you to start from “zero numbers” and quickly acquire a batch of compliant, usable target user data.

Frequently Asked Questions

Q: What should I do if the CSV file shows a format error after uploading?

A: Check whether the file is UTF-8 encoded, whether the number column is correctly named phone, and whether all numbers include the country code (e.g., +86). If the file uses tabs or other delimiters, convert it to standard CSV (comma-separated) before uploading.

Q: How many numbers does CSV import support at most?

A: A single task supports up to approximately 1 million numbers. If the file is too large, we recommend splitting it into multiple uploads. The specific limit is subject to the console prompt.

Q: Can I detect multiple platforms (e.g., Telegram + WhatsApp) simultaneously after import?

A: Yes. After uploading the CSV, you can select multiple target platforms on the number filtering configuration page. The system will detect them sequentially, and the balance will be deducted according to each platform’s unit price.

Q: After detection, how can I distinguish valid numbers from invalid ones?

A: In the exported CSV file, valid numbers have the status “valid” or “active,” while invalid numbers have “invalid.” You can choose to export numbers with a specific status when filtering results.

Q: Which is recommended: using CSV import or first generating local number segments randomly and then filtering?

A: If you already have a list of numbers from your target market (e.g., obtained from trade shows or registered users), using CSV import for filtering is more efficient. If you need to start from scratch to acquire leads, you can first use the Global Number Generation module to generate specific number segments and export them as CSV, then import for filtering. The two methods can be flexibly combined.

---

Now, you can log in to the KK-DATA App Console and start your first CSV import number filtering task. For further guidance, please refer to the documentation or contact customer service via Telegram.