Export issues to Excel - Jira Cloud

[Ricardo Oliveira]

Im trying to export issues to excel but I have more than 1000 issues and Jira let me export only the first 1000 rows. I tried add the work around &page/start =2000 but Jira still export the sames issues (repetitive).

Does anybody has a work around for it? I need to export 8000 issues to Excel to create dashboards.

[Jack Brickey · Accepted solution]

Hi @Ricardo Oliveira and welcome to the Community. For Jira Cloud you need to live w/ the 1000 and simply export 8 times and then merge them into one excel. :-(

[Ricardo Oliveira]

Thank you for answering @Jack Brickey! Yes, I can export 8 times but when I change the string &page/start in my link Jira keep exporting the same first 1000 rows. Its repeating the results for the 8 CSV files. Thank you

[Jack Brickey]

you have to edit your filter in the following manner (example)...

1. project = abc
2. project = abc and issuekey >= abc-1001
3. project = abc and issuekey >= abc-2001
4. etc
5. etc
6. etc

:-( :-(

[Smita]

On JIRA Cloud , how to specify the Page param in the Query URL

[Nar Kumar C. - Narva Software]

This is not true anymore. You can export to Excel and Google Sheets, no limits.

See answer here: https://community.atlassian.com/t5/Jira-Service-Desk-questions/Is-there-a-way-to-export-more-than-1000-issues-in-jira/qaq-p/662507

[Jack Brickey]

Correct! Atlassian has added a plugin for Excel that allows you to import data directly into excel and it works well.

[Levente Szabo _Midori_]

@Ricardo Oliveira and All,

Another option for Jira Cloud Excel exporting that has recently become available is Better Excel Exporter for Jira Cloud!

It offers more (see comparison) in a more reliable, professional way with more responsive and helpful technical support.

If Jira Excel reporting is more than a hobby for you and it's business-critical to generate data-rich, complex reports, you should explore what Better Excel Exporter can do for you and your team!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)