Last updated:

Download my organization's user list to CSV

Learn how to download your organization’s user list to CSV via the web app, making it easier to manage users and keep their details up to date.

Why download my organization's user list?

We understand that you may need to review your organization's user list from time to time. To simplify this process, you can easily review all users in your SafetyCulture organization by downloading the user list to a CSV file. This is ideal for managing users in bulk or importing the data into other systems for your records.

An example CSV export of an organization's user list on the web app.

Download user list to CSV

  1. Log in to the web app.

  2. Click your organization name on the lower-left corner of the page and select Users.

  3. Click More vertical icon on the upper-right of the page and select Download (cloud) iconDownload user list (CSV).

  4. In the pop-up window, select the CSV template you want to download your user list in.

    • New template: Includes custom user fields in the organization and is ideal for bulk managing users.

    • Legacy template: Includes basic user details, without custom user fields.

  5. If filters are applied to your user list, check "Apply current filters to downloaded list" if you want to keep the filters applied to your CSV. Download your organization's user list as CSV via the web app.

  6. Click Download.

Download user list to CSV for selected users

  1. Log in to the web app.

  2. Click your organization name on the lower-left corner of the page and select Users.

  3. Check the boxes of the users you want to include in the CSV export.

  4. Click Download iconDownload CSV at the bottom of the page. Download selected user details as a CSV file via the web app.

  5. In the pop-up window, select the CSV template you want to download your user list in.

    • New template: Includes custom user fields in the organization and is ideal for bulk managing users.

    • Legacy template: Includes basic user details, without custom user fields.

  6. If filters are applied to your user list, check "Apply current filters to downloaded list" if you want to keep the filters applied to your CSV.

  7. Click Download.

CSV and Excel column headers (New template)

Column header

Description

User ID

The unique ID of each user in your organization.

Email

The account email address of a user. Updating existing users' email addresses is currently unsupported.

First name

The first name of a user.

Last name

The last name of a user.

Status

The account status of a user. Must be either "active" or "deactivated". New users can only be set as active.

Password

The password of a user, which must be at least 8 characters, containing an uppercase letter, a number, and a special character. You can only set passwords for new users.

Language

The account language of a user. Refer to the "ISO-639 language codes" section in this article for language codes that are supported on the web app.

Time zone

The account timezone of a user in IANA timezone or Country/Region format. For example, "America/New_York".

Seat type

The seat type of a user. If left blank, the user will be assigned a guest seat by default.

This column only appears if your organization is on the Premium Plan or Enterprise Plan.

Permission set

The name of the permission set of a user. Users' permission sets can only be updated if you have "Platform management: Permissions" permission.

Groups

The names of the groups of a user.

Sites

The names of the sites or levels of a user.

Custom user fields

The custom user fields of a user.

CSV column headers (Legacy template)

Column header

Description

email

The account email address of a user.

firstname

The first name of a user.

lastname

The last name of a user.

status

The account status of a user. Either "active" or "deactivated".

lastSeen

The time of a user's last activity in SafetyCulture. The date is formatted as YYYY-MM-DD, followed by the time in Coordinated Universal Time (UTC) e.g. 2021-10-26T06:54:14.000Z.

seat_type

The seat type that a user occupies. This column only appears if your organization is on the Premium Plan or Enterprise Plan.

permission_set

The permission set of a user.

groups

The groups that a user is part of, separated by commas.

sites

The sites or levels that a user is a member of, separated by commas. If a user is added to a level as a member, the level's name appears rather than all sites under the level. This column only includes site membership information if you have "Site management" permission.

group_ids

The unique identifiers of the groups that a user is a member of, separated by commas.

site_ids

The unique identifiers of the sites or levels that a user is a member of, separated by commas.

createdAt

The date a user was added to or joined the organization via an invite link.

Frequently asked questions

This usually happens because of the regional settings in your spreadsheet program. To fix it, set the delimiter to a comma so the values are correctly separated into columns. You can follow the Microsoft Excel guide or the Google Sheets guide to adjust your settings.

Need more help?
In this article