What carries over and what stays behind

Export your subscribers from your old tool, import the file or the router, and review what will come across before anything is saved. A file import carries each subscriber’s login, contacts, package, router and expiry. Balances, invoices and payment history do not come across, so keep your old records for those.

Where to export from

Mikhmon

Download your users from Mikhmon’s Users page as a CSV. Unsold vouchers go in under Vouchers, Import codes, one package per file. Users with their own login go in as a subscriber file with the connection type set to Hotspot. Then remove the old hotspot users from the router, because MikroTik accepts a local user before asking Centipid.

ISPman

Export your subscribers as an .xlsx file and upload it as it is. Centipid opens the subscriber tab, not the summary tab, and you can pick another tab if it chose wrong.

SmartPay

If SmartPay can export your subscriber list as a CSV or Excel file, upload it and check each column is matched to the right field. If it can’t, copy the list into the template.

Splynx

Export the All Customers table as a CSV with the table’s export button and upload it. Its Login column maps to Username on its own, so leave the name column as Full name.

MikroTik router

Link the router, choose PPPoE secrets or hotspot users and run the import. Usernames, passwords and profiles come across, plus hotspot expiry dates parsed from user comments. PPPoE import disables the router secrets and disconnects active sessions; hotspot import can also disable imported users on the router.

Spreadsheet

Download the CSV template from the Import & export page, fill in one row per subscriber and upload it, then set the name column to Username. A CSV, XLS or XLSX file from any other tool works the same way.

Trial

14 days

Every feature on your own routers, no card. Leave within 14 days and you pay nothing; stay and you pay 3% of hotspot revenue or $0.25 per active PPPoE subscriber a month, trial days included, with a $5 minimum (KES 500 in Kenya).

Start 14-day trial

How the import works

Files
CSV, XLS or XLSX, up to 10 MB and 50,000 rows.
Template columns
name (the username), first_name, last_name, email, phone, account_number, type, package, nas, expiry, password and comment. Only the username is required.
Mapping
Each column is matched from its header and shown before anything is written. A column headed Name maps to full name, so change it to Username if it holds the login.
Duplicates
Matched by username, then account number. Skip leaves existing subscribers alone, Update fills their blank fields, and Overwrite replaces their values with the file’s, except the password.
Packages
A package named in the file that Centipid does not have can be created during the import. Without permission to create packages, those rows are rejected.
Expiry
A date such as 2027-01-31 23:59 or 31/01/2027. A date with no time runs to the end of that day.

Common questions

PPPoE secret import updates any subscriber with the same username and has no Skip option. Hotspot router import skips existing subscribers, and file import lets you choose Skip, Update or Overwrite.

Move your subscribers over. Try it for fourteen days.

Start the trial and import a file or your MikroTik router.