Export users from a site
We’re currently rolling out changes that affect the content on this page. From your organization at admin.atlassian.com, if the Users list and Groups list are under the Directory tab, you have the improved user management experience. We’ll note changes for the improved experience in the content below.
From September 10, 2021 we made some improvements to the CSV spreadsheet format. A couple of column names have changed and there's now an option to pivot your group data.
If you need a list of your organization’s users—for auditing purposes, for example—you can export managed accounts, or export your user list in CSV format from the user management screen.
To export managed accounts
Go to your site's Admin at admin.atlassian.com. If you're an admin for multiple sites or an organization admin, click the site's name and URL to open the Admin for that site.
Note this change if you have the improved user management experience: From your organization at admin.atlassian.com, select Directory.
- Select Managed accounts > Export accounts.
To export your user list:
Go to your site's Admin at admin.atlassian.com. If you're an admin for multiple sites or an organization admin, click the site's name and URL to open the Admin for that site.
Note this change if you have the improved user management experience: From your organization at admin.atlassian.com, select Directory.
- From your organization, select Directory.
From Users, select Export users.
Note this change if you have the improved user management experience: From Users, select the 3 dot icon > Export users
- Select the users that you’d like to export:
All users in your site/organization – Include all users in your site/organization, across all groups.
Users from selected groups only – Only includes users in the groups you select.
- Select the user status that you’d like to include:
All users – Includes all active, suspended and deactivated users.
Only active users – Only includes current active users in your organization.
- Select if you’d like to include additional data in the download:
- Group membership – Includes groups a user belongs to. By default, multiple groups are formatted as a comma-separated list.
Pivot to column – Expands group data from a comma-separated list to a column list called Group name. Additionally, it includes a new column for Group id.
- Product access – Includes the product and product roles a user has access to.
- Group membership – Includes groups a user belongs to. By default, multiple groups are formatted as a comma-separated list.
- Select Export users.
The list of users can take up to 20 minutes to compile depending on the size of your user list, in most cases it will only take a few moments. We’ll start the download automatically for you when it’s ready.
If the download doesn’t automatically start once you see the confirmation notification, you can manually download the CSV file by selecting the Download report again link.
The first row of the CSV spreadsheet are column headings. Everything below this is your organization’s data.
This image is an example of the data in the CSV with both Additional data boxes ticked: Group membership and Product access. This example is without the option Pivot to column selected.
This image is an example of the data in the CSV with Pivot to column selected. You can see the column Group membership is now Group name and we’ve expanded the data to a column instead of a comma-separated list. There is also a new column with Group id.
The following table describes what each column is and how it might look in your CSV spreadsheet.
Column name | Description | Example |
---|---|---|
User ID | The unique identifier for a user. | 5e96d03ed7902d0c0ff7aadf |
User name | The user's name. | James Holden |
The user's email address. | ||
User status | The status of the user in this organization:
| Active |
Added to org | The date the user was added to the organization’s user list. Follows the date format yyyy-mm-dd. | 2020-11-15 |
Org role | Any organization role the user has:
| Org admin |
Last seen in <Product name> - <workspace name> | The date the user was last active in this product workspace. Follows the date format yyyy-mm-dd. | 2020-11-15 |
Role - <Product name> - <workspace name> | This shows the type of access a user has to your product workspace. The options are:
| User, Admin |
Group membership | Default format: This is a comma-separated list of groups that the user is a member of. | confluence-users-acme02, jira-software-users-acme02, site-admins |
Group name | Pivot to column format: This shows the group name that the user is a member of. | confluence-users-acme02 |
Group id | Pivot to column format: This shows the group id for the group that the user is a member of. | 30as780a-e8cc-4611-a4d0-432330b6b7a6 |