nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Alex Koxaras -Relational-

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

All comments

Alex Koxaras -Relational-

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.

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

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.

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

Shelly Singh_c06r7t

i dont have the option in the list that indicates 'Current fields' how can i add that?

Levente - i also dont have this option you mentioned

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!

Kirsten Hess

I should have mentioned an existing FREEEEEEEE option within Jira

Lucy Dilts_rfe46i

Atlassian again cares more about making money off its marketplace. They are CONTINUTALLY removing basic functionality and monetizing it via 3rd party tools/plug-ins etc.

What they fail to realize, is that many organization that are highly regulated WILL NOT allow integration w/ these non-regulated vendors.

We are in the process of moving off of JIRA for this exact reason.

Vasquez, Nate

You can do this - you just have to save your search as a Filter first. Once saved, go to the Filters dropdown, select your new Filter and then use Export from this page. You'll see an option for Exporting CSV (Filter Fields).

Esa Helteenvuori

Thanks Nate! This works! One can also select from Columns drop down menu, which columns are showing and exported.

Kristin Minneci

THANK YOU Nate!!! We are using the new Cloud version and it seems like the easiest of things are either missing or so hard to find.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

atl-gruland