How to Import Subscribers from CSV
Bulk-import subscribers from a spreadsheet instead of adding them one by one. The CSV importer validates your data, detects duplicates, and creates subscriber accounts with PPPoE services in a single operation.
Prerequisites
- At least one plan created in Settings > Plans
- A CSV file with subscriber data (see template below)
Steps
1. Navigate to the import page
Go to Subscribers > Import from the sidebar. You will see the CSV import interface with a link to download the template.
2. Download the CSV template
Click Download Template to get a pre-formatted CSV file with the correct column headers. Open it in Excel, Google Sheets, or any spreadsheet editor.
The template includes these columns:
| Column | Required | Description |
|---|---|---|
first_name | Yes | Subscriber's first name |
last_name | Yes | Subscriber's last name |
phone | No | Philippine mobile number, when present (e.g., 09171234567 or +639171234567) |
email | No | Email address for notifications |
address | No | Installation or billing address |
plan_name | Yes | Must match an existing plan name exactly |
username | Yes | PPPoE username (must be unique) |
password | Yes | PPPoE password |
3. Fill in subscriber data
Populate the template with your subscriber records. Keep in mind:
- plan_name must match a plan that already exists in your account. Spelling and capitalization matter.
- username must be unique across your tenant. The importer will flag duplicates.
- phone must be a valid Philippine mobile number, either local
09...or international+639.../639...format. - Save the file as
.csv(comma-separated values), not.xlsx.
4. Upload the CSV file
Click Choose File or drag and drop your CSV onto the upload area. The importer reads the file and shows a preview of the parsed data.
5. Preview and validate
The preview table shows every row from your CSV. Each row is color-coded:
- Green -- Valid and ready to import
- Yellow -- Warning (e.g., missing optional field)
- Red -- Error that must be fixed (e.g., unknown plan name, duplicate username)
Review the validation summary at the top for a count of valid, warning, and error rows.
6. Resolve conflicts
If the importer detects conflicts, such as a username that already exists or a phone number tied to another subscriber, you have two options:
- Skip the conflicting row and import the rest
- Update the existing subscriber with the new CSV data
Select your preferred conflict resolution strategy and click Continue.
7. Import
Click Import Subscribers to begin the import. A progress bar shows the operation status. For large files (500+ rows), the import runs in the background and you will receive a notification when it completes.
Result
Imported subscribers appear in the Subscribers list with their PPPoE services already created. Each subscriber is assigned to the plan specified in the CSV, and their PPPoE credentials are written to the RADIUS database. They can connect immediately if the NAS is online.
CSV import assigns the plan's standard pricing. If an imported subscriber needs an individual price or discount, open that subscriber's service after import and update Billing terms there.