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 

[Bill Sheboy · Accepted solution]

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