Export users from a site

Still need help?

The Atlassian Community is here for you.

Ask the community

robotsnoindex
robotsnoindex


robotsnoindex

Viewing the right content?

From your organization at admin.atlassian.com, if the Users list and Groups list are under the Directory tab, view the improved user management content.

If you need a list of your site's users—for auditing purposes, for example—you can export your user list in CSV format from the user management screen.

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.
  2. From the Users page, select Export users.
  3. Select the users that you’d like to export:

    1. All users on the site – The file will include all users on your site, across all your groups.

    2. Users from selected groups only Select one or more groups and only users in these groups will be exported.

  4. Select the user status that you’d like to include:

    1. Only active users – The file will only include current active users on your site.

    2. All users – The file will include both active and inactive users.

  5. Select if you’d like to include additional data in the download:

    1. Group membership – The file will list the group(s) each user belongs to. To display multiple groups, a user will get a row in the CSV file for each group.

    2. Product access – The file will include a Yes or No value to indicate which products the user can access. As you'll see in the example file below, the CVS file will have a column for each of your site's products (in this order):

      1. Jira Service Management
      2. Jira Software
      3. Jira Work Management
      4. Confluence
  6. Select Download file.

The list of users can take a few moments to compile, but we’ll start the download automatically for you when it’s ready. If for some reason the download doesn’t start, you’re able to manually download it from this notification.


The first row of the CSV lists the column headings. Here's an example of the data in the CSV with all of the Additional Data boxes ticked:

group_name,username,full_name,email,active,created,Last active in Jira,Jira Software,Jira Work Management
group1,fgamble,Frank Gamble,fgamble@acme.com,Yes,21-Feb-18,16-Jul-18,Yes,Yes
group1,bgamble,Beth Gamble,bgamble@acme.com,Yes,21-Feb-18,19-Jul-18,Yes,Yes
group2,jmiles,James Miles,jmiles@acme.com,Yes,12-Jan-18,10-Aug-18,Yes,Yes
group3,fgamble,Frank Gamble,fgamble@acme.com,Yes,21-Feb-18,16-Jul-18,Yes,Yes
group3,bgamble,Beth Gamble,bgamble@acme.com,Yes,21-Feb-18,19-Jul-18,Yes,Yes
group3,jmiles,James Miles,jmiles@acme.com,Yes,12-Jan-18,10-Aug-18,Yes,Yes

robotsnoindex

Improved user management experience

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. Log in to admin.atlassian.com.
  2. From your organization, select Directory.
  3. Select Managed accounts > Export accounts.

To export your user list:

  1. Log in to admin.atlassian.com.
  2. From your organization, select Directory.
  3. From Users , select the 3 dot iconExport users.

4. Select the users that you’d like to export:

  • All users in the organization – Include all users in your 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:

  • Only active users – Only includes current active users in your organization.
  • All users – Includes all active, suspended and deactivated users.

6. Select if you’d like to include additional data in the download:

  • Group membership – Each group a user belongs to.
  • Product access – Each product and product role a user has access to.

6. 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 lists the column headings. Here's an example of the data in the CSV with both the Additional data boxes selected:

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

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

This is a list of groups that the user is a member of.

confluence-users-acme02, jira-software-users-acme02, site-admins

Last modified on Jul 28, 2021

Was this helpful?

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