Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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 although there are more (and just as valid) options over at

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:

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



Log in or Sign up to comment