Import Customers
Overview
The Import Customers feature allows you to bulk-create PPPoE customer accounts by uploading a CSV or Excel file. This is particularly useful when migrating to ISPBills from another billing or NAS management system, or when onboarding a large number of new customers at once.
Before You Begin
Ensure the following are set up in ISPBills before importing:
- All operators that will be assigned to imported customers.
- All packages that imported customers will be placed on.
- All billing profiles that will be assigned.
Imported customers will reference these by name or ID in the spreadsheet, so they must exist first.
Step 1: Download the Template File
- Navigate to Customers → Import Customers.
- Click Download Template to get the official CSV or Excel template file.
- Open the template in your spreadsheet application (Microsoft Excel, LibreOffice Calc, Google Sheets, etc.).
Always use the downloaded template rather than creating your own file. The column order and headings must match exactly for the import to succeed.
Step 2: Fill in Customer Data
The template contains the following columns. Fill in one row per customer:
| Column | Description | Required |
|---|---|---|
| Username | The PPPoE login username | Yes |
| Password | The PPPoE login password | Yes |
| Full Name | Customer's full name | Yes |
| Phone | Customer's mobile number | Recommended |
| Customer's email address | Optional | |
| Operator | The operator this customer belongs to | Yes |
| Package | The internet package name | Yes |
| Billing Profile | The billing profile to use | Yes |
| Zone | The zone to assign (if zones are configured) | Optional |
| Address | Customer's physical address | Optional |
Leave optional fields blank if the data is not available — do not delete the columns themselves.
Step 3: Upload the File
- Return to Customers → Import Customers.
- Click Choose File or Browse and select your completed spreadsheet.
- Click Upload or Import.
- The system processes the file. Depending on the number of rows, this may take a few moments.
Step 4: Review Import Results
After processing, the system displays an import results summary:
- Successfully Imported — The number of customer accounts created without errors.
- Errors — Rows that could not be imported, with a reason for each failure (e.g. duplicate username, missing required field, package not found).
Download the error report if provided and correct the affected rows. Re-upload only the corrected rows in a new file to avoid creating duplicates.
After Importing
- Newly imported customers are immediately visible in the Customers list.
- If you are migrating from another system and customers already have active PPPoE sessions, they will authenticate as soon as the RADIUS server receives the new accounts.
- Review each imported customer's profile to ensure all data imported correctly, particularly package assignment and billing profile.