Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,335
Community Members
 
Community Events
165
Community Groups

Exporting only specific fields which are needed

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.

2 answers

1 accepted

3 votes
Answer accepted
Alex Koxaras Community Leader Jul 22, 2021

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). 

search and export.pngexport.png

 

Hope that helps!
Alex

Recently had to do something similar, and the suggestion made by @Alex Koxaras 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 Community Leader Jul 22, 2021

@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.

Like Kaj Sennelöv likes this

Thanks Alex for your answer. @Alex Koxaras 

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

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

Change View ChangeICON.PNGbutton available on screen.

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!

multi-issue-excel-export-menu-cloud.png

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,426 views 37 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you