Jira's native export is a snapshot only, and the official Excel add-in covers Cloud only, leaving Server and Data Center users without a live option.
There are three ways to get Jira data into Excel: the built-in export button on any issue list or board, the official Jira Cloud for Excel add-in from Atlassian, and connector tools that keep the sheet updated on a schedule. The export is fine for a one-off pull. The pain starts when the same JQL query has to land in the same workbook every week, formatted the same way, without someone clicking Export each time. Here is every method, with the limits Atlassian's own docs skip.
Method 1: Native export via Filters and Advanced Issue Search
In Jira Cloud, open an issue list or board view and apply your filters or write a JQL query in Advanced Issue Search. Once the results look right, click the Export button and choose between two CSV options: Export Excel CSV (all fields) pulls every field configured in the project, while Export Excel CSV (current fields) pulls only the columns showing in your current view. The "all fields" option is usually more useful but produces wider files that need cleanup.
The catch: every export is a frozen snapshot taken at the moment you click the button. Tomorrow's status changes, new comments, or reassignments are not reflected unless you re-export. For boards with fast-moving issues this gets stale within hours. The export also produces a CSV rather than a true .xlsx, so number formatting and date columns sometimes need manual correction after opening in Excel.
Method 2: The official "Jira Cloud for Excel" add-in
Atlassian publishes a free add-in on Microsoft AppSource called Jira Cloud for Excel. Install it from the Excel Add-ins store, sign in with your Atlassian account, and write a JQL query in the task pane. The add-in pulls matching issues into the active worksheet and can refresh the data when you return to the workbook. It runs in desktop Excel on Windows and Mac, and in Excel on the web through Microsoft 365. The add-in is rated 3.5 stars from around 78 reviews on the Microsoft Marketplace.
The catch: the add-in requires a Jira Cloud subscription and does not support Jira Server or Jira Data Center installations. If your organization runs Jira on its own servers, this option simply does not apply. User reviews also note that scheduled refresh is inconsistent and often requires manual intervention rather than running hands-off.
Method 3: Third-party sync tools (Coupler, Unito)
Tools like Coupler.io and Unito can connect Jira to Excel or to Google Sheets and sync on a schedule. They handle both Cloud and some Server/Data Center configurations depending on the tool. These are broader integration platforms, so they carry a higher per-seat cost and more configuration steps than a dedicated add-in.
The catch: pricing adds up quickly for larger teams, and these tools are optimized for two-way syncing between project tools rather than specifically for analysts who need clean flat tables in Excel for pivot tables and reporting.
Method 4: Brooked for Excel (scheduled JQL pulls, any platform)
Brooked for Excel is an add-in that connects to Jira, runs a JQL query you define, and pulls the results into a clean flat table in the worksheet. It runs inside Excel's ribbon on Windows desktop, Mac, and Excel on the web, where ODBC-based methods cannot run. An AI analyst in the pane lets you ask questions like "which issues have been In Progress for more than a week" without writing any code.
Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the same connector is fully live, so the Jira plumbing itself is mature.
Setting up the Jira connection
Open Brooked in the Excel ribbon, choose Jira as the source, and authenticate with your Atlassian account. Enter a JQL query or pick a saved filter, choose which fields to pull, and import into the active worksheet. No API tokens to paste manually and no CSV in between.
Brooked AI, JiraMethod comparison
| Method | Cost | Works on | Refresh | Best for |
|---|---|---|---|---|
| Native CSV/Excel export | Free, any Jira plan | Any Excel | Manual re-export | One-off issue snapshots |
| Jira Cloud for Excel add-in | Free (Jira Cloud only) | Windows & Mac desktop Excel, Excel on web | Manual refresh in add-in | Cloud teams wanting live JQL queries |
| Third-party sync (Coupler, Unito) | Paid subscription | Any Excel | Scheduled | Teams needing cross-tool syncing |
| Brooked for Excel | Free during beta | Desktop, Mac & web Excel | Scheduled (rolling out in beta) | JQL pulls on any Jira plan, any Excel |
What engineering and project teams build with this
- Sprint velocity tracker: story points completed per sprint, refreshed each cycle without re-exporting
- Bug aging report: open defects grouped by priority and days since creation
- Release readiness dashboard: issues by status and fix version, updated as QA closes tickets
- Team capacity view: assignee workload from in-progress issues, filtered by component
- SLA tracking: time in status per issue type, calculated from Jira timestamps in Excel
Troubleshooting common issues
Related Articles
Frequently asked questions
Can I export Jira issues directly to Excel?
Yes. In Jira Cloud, run a board or issue search, then use the Export button to download a CSV or Excel file. You choose between 'Export Excel CSV (all fields)' to get every field in the project or 'Export Excel CSV (current fields)' to get only the columns showing in your current view. Both produce a file you can open in Excel immediately.
Does Jira have an official Excel add-in?
Atlassian publishes the Jira Cloud for Excel add-in on Microsoft AppSource. It lets you write a JQL query inside the Excel task pane and pull matching issues into a worksheet. The add-in is rated 3.5 stars from around 78 reviews. The important limit: it requires a Jira Cloud subscription and does not support Jira Server or Data Center.
Does the Jira Excel add-in support scheduled refresh?
The Atlassian add-in listing mentions report scheduling, but user reviews note that automatic scheduled refresh does not always work reliably without manual intervention. For hands-off updates, a dedicated connector or third-party tool is more dependable.
What is JQL and why does it matter for Excel exports?
JQL (Jira Query Language) is the search syntax Jira uses to filter issues, for example 'project = MYPROJ AND status != Done AND assignee = currentUser()'. Both the native export and the Excel add-in let you use JQL to narrow exactly which issues land in your spreadsheet. Getting the query right before you export saves cleanup time in Excel.
Does the Jira CSV export work on Windows, Mac, and Excel on the web?
The CSV file itself opens in any Excel version on any platform, so the native export works on Windows, Mac, and Excel on the web. The Jira Cloud for Excel add-in also runs in desktop Excel on Windows and Mac, and in Excel on the web via Microsoft 365. ODBC-based methods are Windows desktop only.
How do I get Jira data into Excel without a third-party tool?
Use the built-in Export button in Jira's issue list or board view. Filter your issues first with JQL or the board filters, then click Export. For recurring needs without a third-party tool, the Jira Cloud for Excel add-in is the official free option, though it requires manual refreshes.
Get live Jira issue data in Excel, updated on a schedule.
Brooked for Excel is in beta and free to try. Using Google Sheets instead? Read the Sheets version of this guide.
See Brooked for Excel →
