How to Save or Export the Jira Backlogs in Excel ?

Question

As we all work daily in Jira in Agile projects, it is very very essential for management teams Product Owners and Scrum Masters to have the Jira Backlogs in Excel for reporting and filtering purposes.

The "Jira Backlog" page is not at all useful for us to save or export the Backlogs view into simple Excel file. This is a huge concern and a very basic functionality. This feature was available in Jira sometime back in earlier versions and now its not showing up. Why Atlassian Removed such a basic common "Menu" option in Backlogs page which is "Export Excel".

Kindly provide the feature to Save the Jira Backlogs in Excel to analyze and filter backlogs.

Levente Szabo _Midori_ · Answer

@sankar.vijaya We indeed noticed and received requests to make Excel export options available on different Jira screens for simply convenience reasons.

For your information, Better Excel Exporter options are available on screens like the Backlog and the active sprint board. If you happen to be on Server or Data Center, export options are there even on the Jira Service Management queue or Tempo Timesheet.

This article has the details on how to export the Jira backlog and board to Excel >>

This is the same in video format >>

Hope it helps. Please note that I'm part of the team developing and supporting Better Excel Exporter.

Nic Brough -Adaptavist- · Answer

Can you tell the difference between an issue that does appear in either the navigator or backlog or active sprint, and one that does not?

sankar.vijaya · Answer

Thanks Nic for your response.

Yep, I've tried this option using "Jira board - Issue Navigator" and adding JQL as well as using manual filter query. However, the Backlogs count and this Issue Navigator filters are not matching and giving all results from "Backlogs" view.

Hope, Atlassian bring this "Export Excel" menu option which was pretty much there earlier in Jira right after the "Print Card" menu.