nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Any way to export a list of users out of JIRA?

Sarah Elmer

I have to send reports weekly of all current users in JIRA. Currently having to highlight and scroll down, copy and then paste into Excel to get a list. With over 300 users, this can be tricky and time consuming. Is there a way that this list can be exported to Excel where it then can be manipulated?

Accepted answers

Jobin Kuruvilla [Adaptavist]

Can't do this in onDemand. In the downloaded version, you could have done this from database.

https://confluence.atlassian.com/display/JIRA/How+to+Export+Users+to+CSV+from+JIRA

All comments

Jobin Kuruvilla [Adaptavist]

Can't do this in onDemand. In the downloaded version, you could have done this from database.

https://confluence.atlassian.com/display/JIRA/How+to+Export+Users+to+CSV+from+JIRA

Sarah Elmer

Jobin - thank you for the quick reply. Had a feeling that was the answer, but wanted to make sure.

Norman Abramovitz

You can use the REST API to retrieve a list of users. You your favorite scripting language that has a web client interface.

http://docs.atlassian.com/jira/REST/latest/#id120663

http://docs.atlassian.com/jira/REST/latest/#id120322

Manohar Venkataraman_trh1us

It's bizarre that you can't export a user list from the Administration interface. I have added a request for this, please vote for it: https://jira.atlassian.com/browse/JRA-23783

MattS

Ugly hack: find inactive users in JIRA by processing the HTML from the UserBrowser page.

Browse to the JIRA Users page, select All from Users per Page, add

?max=10000 to the URL and save the HTML only to the local file

user.html then parse it

Bob Swift

JIRA Command Line Interface (CLI) has the getUserList action that produces a CSV file.

Jay Van der Lyn

Quick way. Left click on the UI table, go to web inspector, click the table element, then edit HTML, then copy and paste the table HTML code into excel. It will reformat it into columns/rows of a valid table. Then you can export however you want.

Boris Berenberg - Atlas Authority

If you are on server edition then the Active User Filter add-on (https://marketplace.atlassian.com/plugins/cr.tin.ActiveUserFilter.active-user-filter/server/overview) allows you to export users to CSV.

Aron Gombas _Midori_

Better Excel Plugin does produce a customizable Excel file from the JIRA user accounts!

Tutorial: http://www.midori-global.com/products/jira-better-excel-plugin/documentation/user-export

(Please note that this is only applicable to JIRA Server at the moment, but we are already working on the JIRA Cloud version.)

Lasse Langhorn_eakpsc

You can use the Jira User Export app for Jira Server. It is free to download and use: https://marketplace.atlassian.com/apps/1220535/jira-user-export?hosting=server&tab=overview

Regards

Lasse Langhorn

Jozsef Frigo _TSM_

Thanks, it works fine

Just a small question: Is there a way to give access to our restricted-jira-administrators to this app? Now they get an infinite redirect loop to the login page and back if they click on the add-on in the admin area.

Lasse Langhorn_eakpsc

Hi Jozsef and thanks,

I will take a look at it for the next release.

The next release will contain user login info in the export.

Regards

Lasse

Lasse Langhorn_eakpsc

Hi Jozsef,

I have created a new release with a fix for the redirect and added user login details to the search and export.

Regards

Lasse

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud