How to download the Backlog into Excel?

[VIctoria_reed2]

Greetings: I have a large volume of items in my backlog. I would like to download my backlog items (all columns and fields) into Excel. Is this something that I can do in Jira? If so, can you provide the process steps to download backlog items into Excel?

Thank you.

[Florian Bonniec · Accepted solution]

Hi @VIctoria_reed2 

To make sure you export the backlog of your board, go to the board admin and copy the JQL your filter is based on. Then do an advance search like 

(Board query you copied) and sprint is empty

Then you will be able to export in CSV. I think Excel export has been removed in 7.x

Not sure if the application property is still available as described by Thorsten Letschert _Decadis AG_  in 

https://community.atlassian.com/t5/Jira-Software-questions/How-to-export-JIRA-issues-to-Excel/qaq-p/584002

Regards 

[Levente Szabo _Midori_]

@VIctoria_reed2 

If your desired export output is native Excel, you can export your Jira backlog to a professional Excel file (instead of CSV) right from the backlog view with Better Excel Exporter. Watch this quick tutorial video on how to do that.

[Fabian Lim]

Hi @VIctoria_reed2

Welcome to the community!

You can run a query to search for items that are not in a sprint.  Example: 

project = X and Sprint is empty

 This will give you the issues in your backlog (You may need to also specify a board).  Then you can export to excel.  

Cheers