Summary

In Jira Cloud, exporting up to 10,000 work items using the asynchronous Export CSV feature from the Issue Navigator is supported. 

Keep in mind

Exporting up to 10,000 work items can take time, and it may be slower when dealing with many fields. Here are some best practice tips:

• Optimize your JQL query. Refine your JQL query to only include relevant work items. This helps keep the number of work items within the limit and avoids unnecessary data processing.

• Select specific fields. In the issue navigator, you can choose to export the current fields or filter specific fields. To speed up the export and make your CSV file easier to manage, only choose the fields you need.

• Avoid exporting all fields. Using the export options Export CSV (all fields) and Export Excel CSV (all fields) can significantly slow down the process and result in large files that are difficult to manage.

If you need to export more than the maximum number of work items, you can find two workarounds below.

Workaround 1 - Export work items by using Google Sheets or Microsoft Excel

From the Issue Navigator (Filters > View all work items), after filtering the work items you want to export, you can click on Apps and select the desired option.

All the detailed steps can be found in the following article:

• How to export more than 1000 issues using Google Sheets

Workaround 2 - Export work items by adjusting URL parameters

Use the pager/start URL parameter to work around this issue by adjusting the index value to export issues from 1001 onwards. You will need to merge the results manually.

It is crucial that you do NOT combine the export of work items through the UI with batch exports using this workaround. Mixing these methods can lead to duplicate or missing work items in the export results. You should conduct all exports using this workaround exclusively. Each batch export has a maximum limit of 1,000 work items.

1. Once you land on the issue navigator page, right-click on the page and select 'Inspect'. This will open the developer tools.

2. Input the desired JQL and run a search to populate the links including the correct JQL in the Export dropdown menu.

3. Click the Export dropdown menu. In the developer tools,

   1. Go to the 'Network' tab, select 'Fetch/XHR'

   2. Enter views in the filter.

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

   4. Copy the URL from the link field of the corresponding export option in the ‘Preview' tab. Here’s an example:

      https://<instance name>/sr/jira.issueviews:searchrequest-csv-current-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000
      or
      https://<instance-name>//sr/jira.issueviews:searchrequest-csv-current-fields/<filterId>/SearchRequest-<filterId>.csv

4. Export the first thousand work items by visiting this URL in your browser and saving the file when prompted.

   1. If you are prompted with the "XSRF Security Token Missing" screen then click the "Retry Operation" button

5. Now, to export the next thousand work items, append &pager/start=1000 to the end of the URL string to instruct JIRA to export from index 1001 and above. Example:

   https://<instance name>/sr/jira.issueviews:searchrequest-csv-current-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000

   Visit this URL in your browser and save the file when prompted. For the subsequent 1000 issues, adjust the index value accordingly, for example &pager/start=2000 (and so forth).

   1. If you are prompted with the "XSRF Security Token Missing" screen then click the "Retry Operation" button
6. Open the exported CSV files and manually consolidate them if necessary.