Export issues to excel

[Mohini P]

While I am trying to export issues to excel it is not letting me export more than 1000 issues. Can someone help me with it? How can I exprt more than 1000 issues? I want a monthly export which is minumum 3000 issues a month

[Boris Georgiev [Appfire] · Accepted solution]

JIRA has a 1000 issue limitation for export. See this KB for a workaround

https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel

And have in mind that exporting too much issues at once may lead to OutOfMemory errors just because all the data is stored in a single String var on the server, so if you get such error increase the heap size.

[Bob Swift]

You might find JIRA Command Line Interface helpful to automate your monthly report. getIssueList will produce a csv that can be imported into Excel. If you use it with a pre-defined JIRA filter, then it will page the results so that you don't have the 1000 limit.

[Fabio Racobaldo _Herzum_]

Hi Mohini,

you can do that just adding a new jira property as specified at the follow link https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel

Hope this helps,

Fabio