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; } } }

how to export list to excel?

ardian.krivca

I have a list , which contains many tickets. There are fields such as creation date, key, status, assignee, etc. Is there a way to export this whole list to excel? I would like to make a report out of it.

Instead of me manually filling this in excel, it would be great if I can export everything.

thank you

Accepted answers

Bill Sheboy

Hi @ardian.krivca

Yes, that is possible. From the advanced issue search, please select Export at the top-right of the view to see the available options.

Kind regards,
Bill

All comments

Bill Sheboy

Hi @ardian.krivca

Yes, that is possible. From the advanced issue search, please select Export at the top-right of the view to see the available options.

Kind regards,
Bill

ardian.krivca

thank you!!!! One last question, it seems its showing me all types of tickets, I only want the ones from my "list" screen. How do I search for just those tickets? Example say here is a sample ticket "VH-##". How do a complete a JQL query to search for all these types?

Bill Sheboy

JQL allows you to find issues meeting your criteria, so consider what you want, search for that, and then export the results.

For example, let's say you only wanted the epics from a specific project that were not completed. That could be:

project = myProjectName AND issuetype = Epic AND statusCategory != Done

If you clarify what you want to know, I can try to help you with the JQL.

You can answer lots of questions with JQL, and here is some documentation and free training to help you learn more:

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

ardian.krivca

Thank you sir, I appreciate your replies. I will take a look and see what I can do.

Lukas Plaisantin

Go to : Filters > View all issues > Export

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-cloud