Bulk Upload

Import multiple subscribers at once using a CSV file.

When to Use Bulk Upload

Use bulk upload when migrating from another billing system or when you have a spreadsheet of subscribers to onboard at once. It is significantly faster than adding subscribers individually.

CSV Format

The CSV file must have a header row with these exact column names:

name,phone,email,username,password,plan_name,site_name,start_date,notes

Downloading the Template

Go to Customers → Bulk Upload and click Download Template. This gives you a pre-formatted CSV with the correct headers and example rows.

Uploading the File

1. Prepare your CSV file with subscriber data.
2. Go to Customers → Bulk Upload.
3. Click Choose File and select your CSV.
4. Click Preview. Qserve validates the data and shows a preview table with any errors highlighted.
5. Fix any errors in your CSV, re-upload, and preview again.
6. When the preview shows no errors, click Import.

Validation Rules

Qserve validates each row before importing:

• Phone numbers must be in E.164 format (+254XXXXXXXXX) or local format (07XXXXXXXX).
• The plan_name must exactly match an existing plan name (case-insensitive).
• The site_name must exactly match an existing site name.
• PPPoE usernames must be unique — duplicates are flagged as errors.
• Email addresses must be valid format if provided.

After Import

Subscribers imported with a plan are activated immediately. Their PPPoE credentials are pushed to the MikroTik router. If you specified a future start_date, the account is created but not yet activated on the router — activation happens automatically on the start date.