Exporting only specific fields which are needed

[Amandeep Kaur Virdi]

Background of work : We use JIRA for bug reporting and the count of tickets is very huge. On exporting the file,  the size of the file is 50 MB. It takes an hour to download and 40 minutes to open. Simultaneously we work on many such projects. 

My question:  To reduce time consumed is it possible to filter out only those fields/ data which is required and then export the file. This would reduce file size and also time consumed.

Also please suggest from your end any other method which could be implemented to resolve the above.

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Amandeep Kaur Virdi and welcome to the community!

You can search from advance issue search for all the issues you want.
Then adjust column visibility, and then click export as a csv (with current fields). 

Hope that helps!
Alex

[Kaj Sennelöv]

Recently had to do something similar, and the suggestion made by @Alex Koxaras _Relational_ worked really well!

It will be limited to 1000 tickets though per export.
You mentioned you had a huge amount of tickets, so if you would need to export more than 1000 issues, you can find the workaround proposed by Atlassian here: https://confluence.atlassian.com/jirakb/increase-issue-limit-for-excel-exports-in-jira-cloud-779160811.html 

Hope this helps too!

-Kaj

[Alex Koxaras _Relational_]

@Kaj Sennelöv you have a point for the 1000 issues limitation! Thank you for pointing out! :)

@Amandeep Kaur Virdi try also the workaround that Kaj provided.

[Ruturaj Patwardhan]

Thanks Alex for your answer. @Alex Koxaras _Relational_ 

I would like to add one point to Alex's  answer. 

That Tab "Column" will be appear only if we select "List View"  using

Change View button available on screen.

[Levente Szabo _Midori_]

Another option that you can try to export your Jira issues selectively from the Issue Navigator to Excel is Better Excel Exporter for Jira Cloud!

The 1000 issue limit can instantly be avoided by using an app like this.

Give it a try and also browse sample Excel exports to understand what can be achieved with Better Excel Exporter!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

[Dean Capp]

Or Atlassian could just build a less complex and more useable product . . . 

[Alok Nath IN]

Have similar issue my search returns lot of fields when running API how to filter or get required fields in the JSON output

[Alok Nath IN]

figured out a way we can mention field and get those only in response worked for me sample http://jira.company.com/rest/api/2/search?jql=filter=812356&fields=key,summary,description