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

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?

8 answers

1 accepted

0 vote

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

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

2 votes

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

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

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

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

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 vote
Boris Berenberg Community Champion Apr 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 vote

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

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

84 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you