Skip to content

Export users to CSV

Export gives you a one-click snapshot of who has access to your org and in what role. The columns match Bulk-import users from CSV, so the file round-trips: export, edit in a spreadsheet, re-upload. Passwords are never included — export is safe to open, but it still contains email addresses and display names, so handle it as personal data under your retention policy.

Prerequisites

  • Admin or Owner role. Operators and Viewers cannot export users.
  • At least one user in the org. Exporting an empty org produces a header-only CSV.

Procedure

Step 1 — Open the Users page

  1. Open Admin → Users from the left nav.

Users page with the Export CSV button visible in the page header

Step 2 — Run the export

  1. Click Export CSV in the page header.
  1. Your browser downloads novavms-users-{org_slug}-{YYYY-MM-DD}.csv. The file is UTF-8, comma-delimited, quoted where needed.

CSV columns

ColumnExampleNotes
email[email protected]Lowercased.
display_nameJane SmithWhat appears in the UI and audit log.
roleadminOne of owner, admin, operator, viewer.
statusactiveactive or disabled. Disabled users are still exported.
last_login2026-04-20T14:31:07ZISO-8601, UTC. Empty if the user has never logged in.
sitesHead office;Warehouse 2Semicolon-separated site names. Populated only for Viewers — other roles have implicit org-wide access (D78).

Verify

  • Open the file. The header row matches the table above.
  • Row count equals the user total shown at the bottom of the Users page.
  • The audit log (Admin → Audit Log) has a fresh user.exported entry attributed to you. Export is audited so you can prove who pulled the list when.

Common variations

  • Round-trip after editing: open the CSV in a spreadsheet, add or remove rows, save as UTF-8, and upload via Bulk-import users from CSV. Existing users are skipped with duplicate_email; new rows are created.
  • Export a filtered subset: no UI filter in v1 — export the whole file and filter in your spreadsheet tool. The underlying endpoint is GET /api/v1/users?format=csv if you want to script a filtered export.
  • Export is rejected with 403: your role is Operator or Viewer. User management is Admin or Owner only (D81).