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

[Levente Szabo _Midori_ · Accepted solution]

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

[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: 

[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 🙏)

[Huwen Arnone _Deiser_]

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.

[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

[Anna Konieczna]

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

[Aron Gombas _Midori_]

We are developers of the Better Excel Exporter app.

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

[Anna Konieczna]

Hi, @Aron Gombas _Midori_ I receive an excel file 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?

[Anna Konieczna]

@Aron Gombas _Midori_ I've created ticket #15242. I hope that you can solve it for free, if no please delete it.

[Sam Bartolome]

Hi @Anna Konieczna ,

What do you want to export? 

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

[Anna Konieczna]

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

[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 ?

[Aron Gombas _Midori_]

@Anna Konieczna I'm Levente's team mate. He is on holiday today, but I'm 100% sure that he'd respond "yes" to your question. So please go ahead!

[Anna Konieczna]

@Zakaria.OuladAli could you please give me your e-mail address? Here I can't see any option to send you the attachment. 

[Levente Szabo _Midori_]

Hi @Zakaria.OuladAli 

You can also reach out to our technical support team via this support desk >>>

This is the best way to get technical help quickly.