Skip to content

Exporting users

Where to find it
Administration → Users
Who can use it
Administrators with user-management access

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

  1. Open Administration → Users.
  2. Optional: search, filter, or sort the list to keep only the accounts you want. The export mirrors exactly that view.
  3. In the toolbar, next to Bulk Import, click Export. An Export data side panel opens on the right.
  4. Turn the fields to export on or off (see the table below). The default set matches the import template.
  5. Click Export. The file users_<date>.xlsx downloads (for example users_2026-07-23.xlsx), with a single sheet named Users.
The 'Export data' panel. Each field is a toggle; the default fields match the import template.

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:

ColumnFieldContent
firstNameFirst Name
lastNameLast Name
emailEmailThe sign-in identifier and the matching key on re-import.
userSecurityGroupSecurity groupExported as the group’s name (its displayed label).
technicalTechnical accounttrue or false.
startDateTimeStart dateDate in YYYY-MM-DD format.
endDateTimeEnd dateDate 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):

ColumnFieldContent
enabledStatustrue (active) or false (inactive).
creationDateCreation dateDate in YYYY-MM-DD format.
lastConnexionDateTimeLast connectionDate in YYYY-MM-DD format.

The Excel round-trip

The exported file is directly compatible with the bulk user import:

  1. Export the list as above.
  2. Edit the file in Excel — fix names, change security groups, add new rows, and so on.
  3. Go back to the user list and click Bulk Import, then upload the edited file.
  4. At the Map Columns step, the technical headers (firstName, lastName, …) are recognized and mapped automatically — nothing to configure.
  5. 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