Export users from a site

Still need help?

The Atlassian Community is here for you.

Ask the community

robotsnoindex
robotsnoindex

robotsnoindex

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

  1. 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.

  2. Select Managed accounts > Export accounts.

To export your user list:

  1. 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.

  2. From your organization, select Directory.
  3. 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

  4. 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.

  5. 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.

  6. 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.
      1. 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.
  7. 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

Email

The user's email address.

jholden@acme.com

User status

The status of the user in this organization:

  • Active

  • Suspended

  • Deactivated

Learn more about inviting users

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:

  • None

  • Org admin

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:

  • None

  • Guest

  • User

  • Admin

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

Last modified on Oct 12, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.