# Import Data

*Tools → Import Data* imports **users**, **managers**, **refill cards** or **card users** from a spreadsheet (Excel or CSV), for example when moving from another system.

[![import data](https://help.snono-systems.com/uploads/images/gallery/2026-11/scaled-1680-/import-data.png)](https://help.snono-systems.com/uploads/images/gallery/2026-11/import-data.png)

## How to import

1. Prepare the file. Only the **first sheet** is used.
2. Click **Upload File** and choose the file. A preview of the rows is shown.
3. Choose what to import in **Import**: Users, Managers, Refill Cards or Card Users. (Choose it after uploading, so the column options match.)
4. Above each column, choose which field it contains, or *ignore*.
5. Tick **Ignore Header (first row)** if the first row contains titles.
6. For users, tick **Update Existing Records** to update users that already exist instead of reporting an error.
7. Click **Import**. The console shows "Verifying Data Integrity...", then "Importing Data..." and the result.

The whole file is checked first. If any row has an error, all errors are listed (with row numbers) and nothing is imported. Fix the file and try again.

## Columns

<table id="bkmrk-importrequired-colum" style="width: 103.58%;"><thead><tr><th style="width: 11.2457%;">Import</th><th style="width: 23.2328%;">Required columns</th><th style="width: 65.4968%;">Optional columns</th></tr></thead><tbody><tr><td style="width: 11.2457%;">Users</td><td style="width: 23.2328%;">username, password, profile</td><td style="width: 65.4968%;">parent, expiration, firstname, lastname, phone, email, company, city, address, contract\_id, national\_id, static\_ip, traffic\_balance (MB)</td></tr><tr><td style="width: 11.2457%;">Managers</td><td style="width: 23.2328%;">username, password, acl\_group</td><td style="width: 65.4968%;">firstname, lastname, parent, balance, email, company, phone</td></tr><tr><td style="width: 11.2457%;">Refill Cards</td><td style="width: 23.2328%;">pin, serialnumber, expiration, value</td><td style="width: 65.4968%;">–</td></tr><tr><td style="width: 11.2457%;">Card Users</td><td style="width: 23.2328%;">username, password, profile, expiration</td><td style="width: 65.4968%;">value</td></tr></tbody></table>

## Rules

- **profile** must be the exact profile **name**; **parent** must be an existing manager **username**; **acl\_group** must be the exact permission group name.
- Usernames must be at least 2 characters and unique, both in the file and in the system.
- **expiration**: use the format `YYYY-MM-DD HH:MM:SS`. If empty, the user is created already expired.
- If parent is empty, the user or manager belongs to you. Imported users get your site.
- Manager **balance** is added as a deposit.
- Imported cards are owned by the admin. Refill cards without expiration are valid until 2040.

*Required permission: Tools - Import Data and Users - Create*