Export more than 1000 issues to Excel

[Zaldy Parian]

Hi all,

I followed the instructions in: https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html

But I got a couple of questions:

In the instructions....

1. Go to: Administration > System > Advanced Settings
2. Find jira.search.views.default.max and jira.search.views.max.limit
3. Change the values as desired, and click update.

I can't seem to find jira.search.views.default.max and jira.search.views.max.limit items from Systems > Advanced Settings.

Also, when I tried the suggestion of updating the tempMax parameter in the copied URL; e.g. from 1000 to 2000, I got a Forbidden (403) error. 

Any help is appreciated.

Regards,

[Jack Brickey · Accepted solution]

Might I suggest forgetting this old method in favor of using the free excel extension - jira-cloud-for-excel-official

[Zaldy Parian]

Thanks, @Jack Brickey .

I got this add-in. But the problem is... in our organisation the installation of this needs IT Support ticket; i.e., it needs administrator user privileges to do this. That makes other users shy away from this.

Anyway, I guess I'll schedule the extract using the add-in and dump the extract file to a shared directory.

Thanks again.

[David Perez Martorell]

One app more to install? Why?

[Jack Brickey]

Hi @David Perez Martorell ,

you don't need to install another app into your Atlassian instance. RatherJira-cloud-for-excel-official is an extension that you add to either XL or Google sheets. Once you have that extension in place you can use it to run any query and pull as many issues as you wish.

[Prince Nyeche]

Alternatively, if you're keen on using the Atlassian API, you could download an export of all issues within the specified project or any project into a single CSV file (see this article I wrote which shows you how to do so via API).

[Aron Gombas _Midori_]

Another app that can export any number of issues without any configuration (within a 10 minute long time window) and offers a lot more functionality is our Better Excel Exporter.

It has been very popular on Server and Data Center and we just released it for Jira Cloud. If work regularly with spreadsheets, it is definitely worth a try.

(Disclaimer: It is a paid and supported app maintained by my team.)

[Michael Fellinger]

Hi Aron,

I have tried it with Jira 7.1 but its still limited to 1000 items

How can I solve it?

[Aron Gombas _Midori_]

@Michael Fellinger have you noticed that the question is for Jira Cloud? Your comment is not relevant here.

But for Better Excel Exporter for Jira Data Center, see this article.

[Taiwo Ojo]

For Cloud users, you can use the Single Project Migrator (SProj) from the marketplace, to extract more than 1000 Results into csv. Better still you can do it in a few clicks.
Pros:
You get all issues
You get subtasks
You get comments
and if needed you also get Attachments too

Con:
Only covers project scope

[Italo Qualisoni [e-Core]]

Hi,

This knowledge base if for JIRA Server only, looking your question tag you use JIRA Cloud and therefore your should check this Export Over 1000 Results to Excel from JIRA Cloud kb instead  

[Zaldy Parian]

Hi @Italo Qualisoni [e-Core] ,

Thanks for the suggestion for Cloud users. However, the option will take several downloads and manipulation of URL param. I was hoping I could download >1000 records in one go without using any 3rd party add-in (e.g., Exporter).

Regards,

[Italo Qualisoni [e-Core]]

You can see @Jack Brickey comment, where he suggest the use of an of an app that allow export to excel 

[Prince Nyeche]

Hi @Zaldy Parian 

You can also use API to get more than 1k Issues, although it would export it out with all fields in separate files of 1K each as that's the limit. however using the app would export everything at one go but i'm not certain if comment fields are exported with that.

[Zaldy Parian]

@Prince Nyeche  - thanks for the suggestion. I'll definitely keep this in my back pocket for future use.