Export field values to excel?

Is there a way to export all of the field values along with the field names?

i.e., the field export tells me there is a field called issue type, but is there a way to list all of the issue types? (and same for all other fields)


2 answers

1 vote

No, there's no real way to do this because it's a bit complex (project contexts allow different lists in different places) and not really particularly useful for most people.

It might be better to explain why you're looking for this, we may have a decent way to get there.

OK thanks Nic. The main reason I want to do this is to help me rationalise the data. When we created our Jira instance we populated it via an csv import from our previous system, and it migrated all of the old field names and field values across. We don't need many of them, so to help tidy them up it would really help to have them listed out in one place, rather than have to trawl through manually. Any tips with how to do that more efficiently would be appreciated!

Hmm. That does need a bit of thought, I still think you'd end up trawling through a lot of the UI to work out usage.

I'd try a different approach, which is still a form of "trawl manually".

One trick I use - create a filter for "all issues". Then you can investigate each field, method determined by field type (note that this assumes a field has a "global" context - if it doesn't, then you'll need to change the filter to narrow it down).

For example, if the field is some form of select (single/multi/radio/checkbox), then go to your dashboard and add a "filter statistic" gadget, using the "all" filter and group by the field. That gives you an idea of usage of each option. For text fields, add a "is not empty" clause to the "all" filter to find out how many issues are actually using it.

Thanks Nic. I ended up creating a filter for all tickets and then exporting that to excel - using filter views in excel then shows me all of the field values. It won't list them all out neatly & automatically, but it will do! Thanks for you quick & helpful response.

JIRA Command Line Interface has a number of list actions for various constructs. They produce csv files that you can load into Excel. Go to the Documentation page, click on the Category column heading to sort by category, then scroll down to the Lists section to see what is available and see if that helps.

Thanks Bob - that looks useful, I will save the link and check it out.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,214 views 5 10
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you