How to export jira issue while retaining all fields?

Question

I was only able to export ticket numbers when attempting to extract data from JIRA for the past few months. However, I need detailed information for each ticket, including categories such as severity, request type, time to first response, and more, but I couldn't achieve this. How can I export tickets from JIRA with all relevant categories (issue details) if there isn't a direct export option available?

Jehan Bhathena · Answer

Hi @IT Support

Adding to Robert's answer, you can try to use the Jira Cloud for Excel/Google Sheets option too.

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

https://support.atlassian.com/jira-work-management/docs/use-jira-cloud-for-sheets/

You can export more than 1k issues while customising the fields information you need.

Robert DaSilva_a432as · Answer

Hi @IT Support , welcome to Atlassian Community!

You should be able to export all issue data as part of the Issue Search functionality in Jira Cloud.

* First, you will need to navigate to the Issue Search view, which can be found by clicking "Filters" and then "View all issues".
* Once here, create a JQL filter that finds the Jira issues you're interested in exporting. I would recommend keeping this list short, as Jira cannot export more than 1000 issues at a time.
* Once you have a JQL filter you're happy with, in the top right, click the "Export Issues" dropdown, and then select one of the options that contain "All fields". This will export the issues in your chosen format with all relevant issue data included.

Here's another Community question that may have more details:

https://community.atlassian.com/t5/Jira-questions/How-to-export-Jira-issues-to-CSV/qaq-p/175115

Hope that helps!

Robert