Use the sidebar filters or enter a JQL (Jira Query Language) query to target only backlog items. A common query is: project = "YourProjectName" AND sprint is EMPTY AND statusCategory != Done .
Search for your backlog issues using JQL directly within Excel.
If you need your spreadsheet to stay updated without manual downloads, Microsoft's official Jira Cloud for Excel add-in is the best choice. Open a new workbook in . Go to the Insert tab and select Get Add-ins . Search for "Jira Cloud for Excel" and click Add . Log in to your Jira account via the sidebar that appears. how to download jira backlog into excel
How to download the Backlog into Excel? - Atlassian Community
For teams that need professional, pre-formatted reports (like a Pivot Table or a specific branded template), built-in CSV exports might feel too messy. Use the sidebar filters or enter a JQL
Click the Export button (top right) and select Export Excel CSV (current fields) to download a file you can open directly in Excel. 2. The Jira Cloud for Excel Add-in (Best for Live Data)
Click . You can now hit Refresh anytime to pull the latest backlog changes. 3. Marketplace Apps (For Advanced Formatting) If you need your spreadsheet to stay updated
Turns your Jira view into a full-featured spreadsheet where you can copy/paste and filter issues before exporting. Atlassian Communityhttps://community.atlassian.com