• Products
  • Documentation
  • Resources

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.

A diagram of an new admin.atlassian.com view that shows a new Directory tab instead of Users and Groups

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.

Export managed accounts

To export managed accounts:

  1. Go to admin.atlassian.com. Select your organization if you have more than one.

  2. Select the site's name and URL to open the Admin for that site, then select Managed accounts.
    This step is different if you have the improved user management experience. Select Directory > Managed accounts.

  3. Select Export accounts.

We’ll email you when the CSV file is ready to download.

Export user list

To export your user list:

  1. Go to admin.atlassian.com. Select your organization if you have more than one.

  2. Select the site's name and URL to open the Admin for that site, then select Users.
    This step is different if you have the improved user management experience. Select Directory > Users.

  3. Select Export users.
    This step is different if you have the improved user management experience. At the top of the screen, select > 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.

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

  8. We’ll email you when your CSV file is ready to download. Check your junk or spam folder if it’s taking awhile.

  9. Open the email and select Download CSV file. If you’re not logged in, you may need to log in before the download will begin.

Export users to CSV screen. Select all users or users from groups. Select all or only active users. Button to export users

Understanding the CSV spreadsheet

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.

 Example of data in the CSV with Group membership and Product access boxes ticked. Without 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.

Example of the data in the CSV with Pivot to column selected. Group membership is now Group name, 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

 

Additional Help