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

Sarah Elmer August 23, 2012

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?

9 answers

1 accepted

0 votes
Answer accepted
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 23, 2012

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 August 23, 2012

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

9 votes
Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 18, 2019

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_ May 20, 2019

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 20, 2019

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 21, 2019

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

Jozsef Frigo _TSM_ May 21, 2019

Hi Lasse,

thank you very much for the quick fix and for the added details. 

The new version works really fine.

Best regards

Jozsef

Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 21, 2019

No problem.

Glad to help :)

Joe Sapinoso July 11, 2019

This is great Lasse! Any plans to make this available for the Cloud version as well?

Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 11, 2019

Hi Joe,

Making a Cloud version is not in the pipeline at the moment.

But thanks for asking this question. 

Regards

Lasse

Jeanne Scilley December 4, 2019

This add on is a HUGE time saver.  I wish I would have found it a few years ago.  Thanks @Lasse Langhorn!!!

Like # people like this
Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2019

Hi @Jeanne Scilley 

Thanks. The app is not that old. Made it in May this year but glad you like it.

Regards

Lasse

Helen C April 19, 2020

this has been a life saver as we rationalise users before moving to the cloud version ! Thanks so much for this app

Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2020

Hi @Helen C

Thanks for the feedback.

Have a nice day.

Regards

Lasse

FrancescoKa April 22, 2020

I used to export users from the database,  

this is really a great thing!

Regards!!

4 votes
MattS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 10, 2014

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

3 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 21, 2016

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

 

2 votes
Manohar Venkataraman December 16, 2013

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

0 votes
Boris Berenberg - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 23, 2016

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.

0 votes
Jay Van der Lyn April 21, 2016

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. 

0 votes
Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 26, 2015

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

0 votes
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 23, 2012

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

Suggest an answer

Log in or Sign up to answer