Excel extracting data from JIRA


I want to extract all user list who are associated with all the projects in our live server.

Because we have almost 6k users are there in live server. So we want to know which user is having against in which project.Hope you are clear my requirement.



When you say "user associated with project", what do you mean?  Is there a specific level of access you are looking for?  Sometimes people mean the minimal "can read the project", sometimes it's a step up to "can create" or "can transition" or "can do <other actions>"

Once you've decided on that, you then need to read through permissions to work out who matches, which will usually descend into reading groups and roles out as well.

There's no simple way to do that sort of stuff in JIRA.

I quite like the answer at https://community.atlassian.com/t5/Answers-Developer-Questions/List-of-users-in-project-REST-API/qaq-p/536820 although there are more (and just as valid) options over at https://community.atlassian.com/t5/JIRA-questions/Export-Jira-User-List/qaq-p/137823

Hi Nic,

Thanks for your reply. What I'm looking for, I'm explaining below.

Actually we have almost 6000 users are there in our production server. Out of 6000 users many users are inactive. So we are planning to extract all users and shared to team, those are not using, will delete post verification. Also we wanted to which user is associated with which project. So in excel it should come like this.

User name    Project name

Sandy.a           Poj A

Vidya.g           Project B

                       Project C

                       Project C


Rash.y            Project D

Hari.h             Project E 


Like this we want . so that Will come to know which user belongs to which project. Based on that will take a call.

hope you are clear now my requirement.

The format of your output does not really tell me anything new of any use that can get me any closer to a method (although I've also given you methods in my answer)

Could you please read my answer again, and answer the question in it?  And read the links?

As an additional point though, you're doing the wrong thing.  It is a very bad idea to delete users, you should just make them inactive if they are no longer using the system.

Hi Nic,

Thanks for your reply. Please refer the attached screenshot. I would like to extract all the users from there. but If I will take it here and put it in an excel sheet, it will take a lot of time. because I have to go each page that means 6000 users are there. If I will copy from here and put it in excel sheet then I can edit , its possible but ploblem is it will take a lot of time. I'm looking is there any way where I can get all the information by spending less time. Like from DB server by fetching querries or something like that. please help me on it.

I can't help you until you answer the questions I have asked.

Please, stop repeating your requirements, I understand those.  I need you to read and respond to the questions I've asked.

We have a tutorial dedicated to this: http://www.midori-global.com/products/jira-better-excel-plugin/documentation/user-export

This is either solves your use case, or can solve that by customizing the Groovy script involved.



Log in or Sign up to comment
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

103 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