Is it possible to export a list of all projects with their category?

[Gabriel Porras]

Is it possible to export a list of all projects with their category?

[Ronald Vallenduuk · Accepted solution]

The quickest way I know is using the Jira API:

Log in to Jira and open a new browser tab.

Go to https://[yourdomain].atlassian.net/rest/api/2/project

That gives you a json object with all your projects.

Then use a json to csv converter like https://json-csv.com/ and a few seconds later you have a file you can open in Excel.

There's a lot more you can do with the API; it's also an easy way to export users and groups.

[Vicki Lea Tsang]

Brilliant! Thanks!

[Rudhra Murthy]

Awesome! This worked great!

Ronald, If you could help us on how to get any data from Jira into json objects similar to this so that?

For example, you have given the URL "https://[yourdomain].atlassian.net/rest/api/2/project" to get the list of projects. 

What if we want to see list of Test steps?

Looking forward to hear from you.

Thanks in advance!

Rudhra murthy

[Arun_Thundyill_Saseendran]

This is a very well quick working solution.

[Lucien Cighir]

This has done it, and in general, the Jira API is a powerful tool, thanks for the solution!

[Blaise Rey-Mermet]

Nice - Note that you can also convert the JSON data locally with three lines of python code, by unsing the pandas library:

I use PyCharm and Anaconda ( www.jetbrains.com/pycharm/promo/anaconda/ ) , that comes preconfigured with pandas.

import anaconda_project
import pandas
pandas.read_json("input.json").to_excel("output.xlsx")

Thanks for the solution. 

[Dinesh]

This is a simple solution and it worked great, I have a quick comment, instead of UUID can we get the person who created the project or how can we query using the UUID to get the user name. 

[Cliff Audinet]

So, this worked as others have stated.  Curious that Jira Software does not let you export a project list with possibly some status info by default from within the app.  You cannot modify the column layout on the Projects list either.  Maybe a default project report at the org level would be nice.  

Thanks to Ronald Vallenduuk for blazing that trail to a reasonably useful solution!

Cliff

[Mahesh Gupta]

Ronald, this tip of you has worked but is there a way to pull the Project Lead as well along with these details?

[Shekharendu Mohanty]

How can i export list of Project lead names with help of API?

[fbabu]

How do I get the list of Groups instead project? I tried replacing Projects with groups and it didnt work.? Please help. Also, if you can help with the Boards as well, much appreciated.

[Eugene Simon]

Thank you Ronald.  Your solution worked a treat.

[Renjith Pillai · Accepted solution]

No direct way, you can do it if you are comfortable with jquery to run a short script in your browser console to extract it.

[Renjith Pillai]

Will try to get you one script if time permits.

[Renjith Pillai]

Try this in the javascript console:

AJS.$('.inall').each(function(i){

var category = AJS.$(this).find('h3').text();

AJS.$(this).find('div div table tbody tr').each(function(i) {

console.log(category + ',' +
	AJS.$(this).children('td:nth-child(1)').text().trim() + ',' +
	AJS.$(this).children('td:nth-child(2)').text().trim() + ',' +
	AJS.$(this).children('td:nth-child(3)').text().trim() );

});


});

Copy paste the output in the console (comma separated to an Excel)

[Rui Pereira]

Here is a low tech version of how I did it:

1. Click Projects>View all Projects
2. Select the whole table with the mouse, including the Title Row
3. Copy
4. Open Excel
5. New Blank Worksheet
6. Past (Match Destination Formating)
7. Delete Rows where Name=="Blank"
8. Save in format you need ;-)

Hope this helps

[Földes László]

The All Project page shows only 25 projects on a single page, and you have change page to the next 25 projects. Which makes this process very cumbersome.

[Nag]

On other hands, Instead of all projects in "Projects" tab

Goto Jira Admin section(cog icon) on right top corner --> choose "Projects"

It will list all available Jira projects in the current instance.

Hope this will help you guys...

[William]

Again this is limited to 25 projects at a time. At least it is in my version of Jira.

[Jira Admin]

I find it odd that I can just get a list into excel simply a list of all of my projects

[Jira Admin]

I mean without having to do one of the above mentioned suggestions

[Paul Greig]

Hi Furore,

Yes you can, the 'Search for Issues' screen allows you to create your custom filters and then export to multiple formats using the 'Views' option. The following guide outlines this process: https://confluence.atlassian.com/display/AOD/Exporting+Search+Results+to+Microsoft+Excel

Cheers,

Paul

[Gabriel Porras]

Thanks Paul, but We already export all Issues from Jira, with all Excel fields.

No one field has the Category.

Any other idea?

Thanks!

[Chris Atkinson]

That would only export a project's issues – The problem trying to be solved is how to export a list of projects.

[Mahesh Gupta]

@Paul Greig I'd like to use your assistance for exporting all the projects listed under my site along with the Project Leads listed.

Could you help me out with this? 

[AMÁLIA Briese]

Quero aprender a dominar a ferramenta ao meu perfil,para assim podermos fazer uma gestão de comunicadores instantâneos.

[AMÁLIA Briese]

E agora quero saber o que você acharam do meu painel anterior 👆📒☕