Increase issue limit for Excel exports in Jira Cloud

Kay Kalu November 1, 2024

Trying to export more than 1000 issues to CSV but can't figure out the new instruction "

 

 New asynchronous experience:" I have followed the instructions below from this link

https://confluence.atlassian.com/jirakb/increase-issue-limit-for-excel-exports-in-jira-cloud-779160811.html

  • Go to the 'Network' tab, select 'Fetch/XHR'

  • Enter views in the filter.

  • Next, refresh the page and select the Export dropdown menu.

  • Copy the URL from the link field of the corresponding export option in the ‘Preview' tab - but stock here can figure what I am to do here.

Any help will be appreciated. Thanks

3 answers

2 accepted

1 vote
Answer accepted
Salih Tuç
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 1, 2024

Hi @Kay Kalu welcome to the Community!

You can just copy the link on Export button (it should end with tempMax=1000)

Screenshot 2024-11-01 at 15.48.42.png

 

and add &pager/start=1000 to the end of it.

However, I am usually using the Google Docs to export issues. On Issue filtering screen, click to "Apps" and select "Open in Google Sheets".

Screenshot 2024-11-01 at 16.56.10.png

And Voila, all of these issues are waiting for you in the same Excel sheet :)

 

Kay Kalu November 1, 2024

Hi @Salih Tuç I was able to do this up on till last week when Jira made Excel export asynchronous so me right clicking the link doesn't bring up clink to copy. 

Salih Tuç
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 4, 2024

Hi @Kay Kalu ,

If you are familiar with Python, I created following script for you, in order to export your JQL query to Excel file (xlsx format): GitHub Link 

Kay Kalu November 5, 2024

Thanks Salih, This will definitely help I will look into it. 

Like Jehan Bhathena likes this
0 votes
Answer accepted
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 4, 2024

@Kay Kalu You can just use the Better Excel Exporter app.

It will go way above 1000 issues without any configuration or manual work!

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

 

Kay Kalu November 4, 2024

Thanks Aron, I had already requested for the app from my admin, hopefully they get it for my team in the meantime I will continue seek other options.

Like Aron Gombas _Midori_ likes this
0 votes
Jehan Bhathena
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 1, 2024

Hi @Kay Kalu 

You can use the Jira Cloud for Excel plugin to achieve this.

It's free of cost and availabile out of the box.https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?tab=overview&hosting=cloud

Similar solution is available for Google Sheets but I haven't had the chance to try that out yet.

Kay Kalu November 1, 2024

The problem is i am not an admin in my organisation, so it is going to be a process to get the plugin. Thanks

Like Jehan Bhathena likes this
Jehan Bhathena
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 1, 2024

Hi @Kay Kalu 

It's available out of the box

Steps to use it here https://community.atlassian.com/t5/Jira-articles/The-add-in-you-ve-been-waiting-for-Jira-Cloud-for-Excel/ba-p/1210420

If not this, then when you search for an issue in the All Issues search you'll get the option to export to excel or Google.

 

Jehan Bhathena
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 1, 2024

IMG_20241101_192540.jpgAdding image for reference.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events