nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

export all projects to excel file

Anna Konieczna

Hi,

How can I export all projects (without the list of issues) to the Excel file? I've installed Better Excel Exporter add-ons, but seems that it doesn't work.

Regards,

Anna

Accepted answers

Levente Szabo _Midori_

@Anna Konieczna

This hands-on tutorial blog is a good guide on how to export Jira projects to Excel using Better Excel Exporter.

Please read and follow the instructions there and if for some reason you still have difficulties, please reach out by opening a support ticket.

All comments

Sam Bartolome

Hi @Anna Konieczna ,

What do you want to export?

the names of the projects? All projects (configuration) except issues?

Garrett McCreery

Hi Anna!

Not sure you can do this with (JQL and excel or without a plugin), but there are APIs that you can use. Since you are doing a GET, you can use a browser and simply put the appropriate URL in as described in this answer: https://community.atlassian.com/t5/Jira-questions/Jira-REST-API-to-get-projects/qaq-p/728218

Something like this should work for you (if you using Jira cloud), replacing your instance name in the url below and updating the maxResults if greater than 200.

https://{your instance name}.atlassian.net/rest/api/3/project/search?jql=&maxResults=200

Aron Gombas _Midori_

We are developers of the Better Excel Exporter app.

What does it mean "it doesn't work"? Can you please elaborate?

Levente Szabo _Midori_

@Anna Konieczna

This hands-on tutorial blog is a good guide on how to export Jira projects to Excel using Better Excel Exporter.

Please read and follow the instructions there and if for some reason you still have difficulties, please reach out by opening a support ticket.

Huwen Arnone [Deiser/Devoteam]

Hi @Anna Konieczna, maybe in this post you might find a solution. Even though this guide focuses on exporting issues, not necessarily on projects, you should check it anyway.

Anna Konieczna

Hi, @Levente Szabo _Midori_ can I open a support ticket for free whether it is paid?

I've read the instruction and it's clear for me, but when I'm exporting I receive this excel:

Anna Konieczna

Hi, @Aron Gombas _Midori_ I receive an excel file like below:

Anna Konieczna

Thank you for your response. Unfortunatelly I don't use Jira Cloud.

Anna Konieczna

Hi @Sam Bartolome I want to have a view like below:

Aron Gombas _Midori_

Please open a ticket in our support desk.

Anna Konieczna

@Aron Gombas _Midori_ can I open a support ticket for free whether it is paid?

Levente Szabo _Midori_

I saw your issue has been resolved and Better Excel Exporter's project export feature is working for you! (Also thanks for the great review 🙏)

Zakaria.OuladAli

Hi @Anna Konieczna

I was wondering whether the problem was fixed for you. I have the same issue, could you please share the solution with me?

Thank you!

Anna Konieczna

Hi, @Levente Szabo _Midori_ could I share our correspondence with @Zakaria.OuladAli ?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server