How to export Jira issues to Excel and CSV

[#1]

There often arises a need to export Jira issues for various purposes like reporting, analysis, or backup. This article explores the different methods to export Jira issues to Excel and CSV formats natively, and using Jira plugins. 

Exporting Jira Issues to Excel

Exporting issues to Excel is straightforward in Jira. Here’s how you can do it:

• 1. Navigate to Issue Search: Access the issue search feature in Jira to locate the issues you want to export.
• 2. Apply Filters: Use Jira’s robust filtering options to refine the issues list based on your requirements.
• 3. Export to Excel: Click on the 'Export' button and select the 'Excel' format. Jira will generate an Excel file with the issues data.
• 4. Excel Data Management: Once exported, you can use Excel’s functionalities to format and analyze the data, making it suitable for presentations or further analysis.

Exporting Jira Issues to CSV

For more flexibility, especially when integrating with other software, exporting to CSV is ideal. The initial steps are similar to exporting to Excel. After filtering your issues, select the 'CSV' format in the export options.

Using Planyway for Enhanced Export Capabilities

Planyway is a powerful add-on for Jira that broadens the horizons of project management with advanced roadmaps, workload management, calendar planning and time tracking. So, if you’re looking for a way to enhance project management capabilities, Planyway is perfect for that. And once you decide to export the data both crated in Jira and in Planyway, it can be easily done by clicking Export button on any of the chosen views.

[kamyshansky@ild.cz]

The most useful feature, imo :)

[Roshan Ambhore]

I am trying to export all the issues, but when I export, I am only getting 1000 records in excel reports. Is there any way to export all the issues in Excel?

[Douglas Fraser]

@Roshan Ambhore 

If you dont have any plugins then you can edit the Export Issues URL to return tickets in tranches of 1000 until you have all the tickets from your board.

• Navigate to board
• Select Board Setting (3 dots, top right).
• General setting
• Select "Edit Filter Querey" or "View Filter Querey" (depending on access rights)
• Export Issues
• For the first 1000 tickets run the report as normal.
• For issues >1000 Right click on your desired report e.g. "Export Excel CSV (Custom Fields)"
• Copy link address
• Paste link address into web brower
• Add the following text to the end of the url(no trailing or leading spaces):  &pager/start=1000
• This will start the download from issue 1000, returning issues numbers 1000-1999
• Repeat this process as many times as is required, incrementing the start number by 1000 each time. So for issues 2000-2999 you would add &pager/start=2000 to the end of the URL.

Bring all the tranches of data together into a single file for your full final view.

[Mary from Planyway]

@Roshan Ambhore 

Jira has a default limit of 1,000 records when exporting issues. However, you can work around this limitation in several ways to export all your issues:

1. Adjust the Export Limit in Jira Settings (Admin Access Required)

If you have Jira admin privileges, you can increase the export limit from 1,000 records to a higher number by modifying Jira's configuration.

• Navigate to Jira Administration > System.
• Under the Advanced Settings, search for the key jira.search.views.default.max.
• Increase the value (e.g., from 1,000 to a larger number like 10,000).
• This will increase the maximum number of issues that can be exported in a single report.

Note: Be cautious when increasing the export limit, as it might impact performance if you set the number too high.

2. Use Bulk Export with Pagination

If you don't have admin privileges or if the total number of issues is very large, you can use Jira’s advanced search with pagination:

• Use Jira's Issue Navigator with JQL to narrow down the issues. For example, search issues in batches of 1,000 (or fewer) by using JQL like project = "YourProject" AND issueKey >= XYZ-1000 AND issueKey <= XYZ-1999.
• Export each batch individually and combine them in Excel.

3. Use Jira Cloud REST API for Exports

If you're using Jira Cloud or if you want to automate the export, you can use the Jira REST API to retrieve all issues programmatically. This method is more flexible and can be combined with scripts to handle large datasets.

Example using the Jira API:

• Use the following endpoint to fetch issues:
  bash

  GET /rest/api/2/search?jql=project=YourProject&startAt=0&maxResults=1000
• Loop through the results by changing the startAt parameter to paginate through the data (i.e., 0, 1000, 2000, etc.).

Once you’ve fetched all the issues, you can export them to Excel.

[Varvara Kozlova]

Hello! How can I add the option to download in Excel if it's not listed among the export options?

[Mary from Planyway]

@Varvara Kozlova 
Please check it out. Hope it'll help https://confluence.atlassian.com/jirakb/unable-to-export-in-excel-missing-excel-all-fields-excel-current-fields-options-in-jira-server-data-center-1141973487.html#:~:text=In%20order%20to%20enable%20the,created%20manually%20in%20that%20directory.

[Stephen_Lugton]

Thanks for this guide @Mary from Planyway (and for updating your comments)

[Jason Mansfield]

Hi @Mary from Planyway 

Thanks for your comment below:

https://community.atlassian.com/t5/App-Central-articles/How-to-export-Jira-issues-to-Excel-and-CSV/bc-p/2813849#M9424

Regarding this part of your post:

"Adjust the Export Limit in Jira Settings "
For some reason, when I go to the advanced settings, I cannot find the key jira.search.views.default.max

There are other advanced settings, but not this one.

You wouldn't happen to know why that might be, would you?

[Mary from Planyway]

Hi @Jason Mansfield 

If you can't locate the jira.search.views.default.max setting in the advanced settings, it might be due to the specific Jira environment you're using or your permissions level. Here are a few possibilities:

1. Jira Cloud vs. Jira Server/Data Center: This setting is typically available in Jira Server or Data Center, but not in Jira Cloud. If you're on Jira Cloud, the export limit is controlled by Atlassian and can't be adjusted directly in settings.

2. Permissions: Only Jira Administrators with sufficient permissions can see and modify certain advanced settings. Double-check your permissions to ensure you have the necessary access.

3. Jira Version: The visibility of some settings may vary across different versions of Jira. If you're on an older version, it could be that this specific setting isn’t available.

If you're using Jira Cloud and need larger exports, you might consider using the Atlassian REST API or a third-party export app as a workaround.

Hope this helps!

[Jason Mansfield]

Hi @Mary 

Thanks for your response. Yes, we've got JIRA Cloud, so that explains why.

Thanks for your help and your suggestion of the Atlassian REST API.

[Andrew Dzvetera]

To export more than 1000 issues to excel you can navigate to filters->all issues -> apps-> then select open in excel