Exporting users
From the user list, the Export button downloads your accounts to an Excel file (.xlsx). The file is built for the round-trip: you export it, edit it in Excel, then re-upload it as-is through the bulk import — its columns are mapped automatically, with no manual work.
The export runs entirely in your browser and reflects what’s currently filtered on screen: the active search, filters, and sort are preserved. So you export the filtered set, not necessarily every account.
Exporting the list
- Open Administration → Users.
- Optional: search, filter, or sort the list to keep only the accounts you want. The export mirrors exactly that view.
- In the toolbar, next to Bulk Import, click Export. An Export data side panel opens on the right.
- Turn the fields to export on or off (see the table below). The default set matches the import template.
- Click Export. The file
users_<date>.xlsxdownloads (for exampleusers_2026-07-23.xlsx), with a single sheet named Users.
The exported columns
The file’s header row uses the template’s technical keys (firstName, lastName, …) — this is intentional: those keys are what the bulk import recognizes and maps automatically. The following fields are on by default:
| Column | Field | Content |
|---|---|---|
firstName | First Name | — |
lastName | Last Name | — |
email | The sign-in identifier and the matching key on re-import. | |
userSecurityGroup | Security group | Exported as the group’s name (its displayed label). |
technical | Technical account | true or false. |
startDateTime | Start date | Date in YYYY-MM-DD format. |
endDateTime | End date | Date in YYYY-MM-DD format. |
Three optional fields are off by default — you can add them, but the import ignores them (they’re only for viewing the data in Excel):
| Column | Field | Content |
|---|---|---|
enabled | Status | true (active) or false (inactive). |
creationDate | Creation date | Date in YYYY-MM-DD format. |
lastConnexionDateTime | Last connection | Date in YYYY-MM-DD format. |
The Excel round-trip
The exported file is directly compatible with the bulk user import:
- Export the list as above.
- Edit the file in Excel — fix names, change security groups, add new rows, and so on.
- Go back to the user list and click Bulk Import, then upload the edited file.
- At the Map Columns step, the technical headers (
firstName,lastName, …) are recognized and mapped automatically — nothing to configure. - Choose the import mode (Add / Update by default) and run the import.
On re-import:
- Existing users are matched by email and updated with the file’s values.
- Existing users’ passwords are never changed.
- Columns the import doesn’t know (
enabled,creationDate,lastConnexionDateTime) are simply ignored. - New rows create new accounts, with an automatically generated password.
See also
- Users — add, edit, activate, and deactivate accounts.
- Bulk import users — re-upload the exported file.
- Security groups — what each user can see and do.