Export a list of all projects

[Manuela Gomes]

Hi! How can I export a List or Sheet with all the projects created and currently active in my Companies Jira ?

[Aron Gombas _Midori_]

You can easily do that with the Better Excel Exporter app. Follow this tutorial.

(Discl. it is a paid and supported app, developed by our team.)

[Chaimaa BRITEL]

Hello @Aron Gombas _Midori_is it possible to export all projects with all their insights and CMDBs in one single Excel sheets with Better Excel Exporter for Jira Server ?

[Aron Gombas _Midori_]

Not with one click.

But:

1. You could either develop a template that does it. You have the default "project-export.xlsx" template and its Groovy script as starting point. Plus, you can find the sample code for accessing Insights data in "insight-tool.groovy". These are great starting points.
2. Or:
   1. Export all projects to one spreadsheet.
   2. Then export the issues in one project with their Insight-managed fields to another spreadsheet. 
      1. Repeat it for all projects.
   3. Combine the previously exported spreadsheets into one using the Excel feature set.

1 is the elegant solution, which should be preferred if this is something that you want export time to time repeatedly. 2 is a manual approach, it doesn't require any scripting skills, but it is more work if you have to do this again and again.

[Chaimaa BRITEL]

Thanks a lot @Aron Gombas _Midori_ for this detailed answer!! I'll make sure to try both solutions and see which one fits better for our need :)

[Karthikeyan_Rajagopal]

Hi,

I just want to collect all the project names in a file(csv/excel)  is this possible in Jira. i am not seeing Add-ons  menu in my Jira app. without thrid party installations software is it gettable

[Dawid Joshua _TechTime_]

Hi @Manuela Gomes ,

The following should work:

1. Navigate to https://your_cloud_name.atlassian.net/rest/api/3/project/searc
2. Copy everything from "values" to the end of the JSON file into your clipboard
3. Use an online look like https://data.page/json/csv to convert the JSON from your clipboard into a CSV file. There should be a column "values__name" with all your project names and values__key with the key values.

[Monica Morris]

@Dawid Joshua _TechTime_ I used your solution and it worked - thank you!

The only thing I did differently was use https://domain.atlassian.net/rest/api/3/project/ instead of .../project/search because .../project returned the complete list of projects, whereas .../project/search returned only the first 50 projects by alphabetical order.

Everything else was spot-on though. Thank you again!!

[Monica Morris]

Adding a comment here to highlight that @Dawid Joshua _TechTime_ solution posted on this page works! No 3rd party app needed.

[Deleted user]

Hi @Manuela Gomes 
Welcome to the community!

I'm Yousef, nice to greet you, I'm Product Marketing at DEISER, a Marketplace provider.

We have a blog, where we talk about this topic, if you want, here I attach it https://blog.deiser.com/en/seven-ways-to-export-jira-issues.

I hope it will help you with your question.

If you need more information let me know and I will be happy to talk to you.

[Trudy Claspill]

Hello @Manuela Gomes 

Welcome to the community.

There is not a built-in report for getting the list of projects. You can use a third party app or you can use the Jira REST API to get that information.