Export a list of all projects

Manuela Gomes
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 21, 2022

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

5 answers

2 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 22, 2022

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

jira-project-export (1).png

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

Chaimaa BRITEL February 28, 2023

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 1, 2023

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.

Like Sam Husson likes this
Chaimaa BRITEL March 2, 2023

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 September 12, 2023

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

Levente Szabo _Midori_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 11, 2024

@Karthikeyan_Rajagopal It's not available out of the box. If you don't see the Apps menu, talk to your admin and ask them to install an app that can help you with this, like Better Excel Exporter.

2 votes
Dawid Joshua _TechTime_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 21, 2022

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 September 13, 2023

@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!!

Like Nicki Adams likes this
Kritesh Patel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 11, 2024

hi, this worked great for pulling up the list of projects. One question, is there anyway to see a time stamp of last used or last time an issue was updated within the project in the results?

0 votes
Monica Morris September 13, 2023

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

0 votes
Deleted user November 25, 2022

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.

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 21, 2022

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.

Suggest an answer

Log in or Sign up to answer