The Cascade guide

How to export Jira
to Excel or CSV

Jira’s own export covers most needs. Keeping epics, stories and subtasks together in the sheet takes one more step.

By Ahmad Fiaz Jan · Jira Cloud · Documentation checked October 5, 2026

The short answer

To export Jira to Excel, search for the work (Filters > Search work items), select ••• above the results, choose Export, and pick Export Excel CSV (current fields) or Export Excel CSV (all fields). To skip the download, use the Open in Microsoft Excel icon above the results. Atlassian supports up to 10,000 work items per CSV export. To keep epics, stories and subtasks nested in the sheet, use a hierarchy-aware export such as Cascade’s indented CSV.

Export from the list view or a plan

In a space, open List, select ••• and choose Export to get the list’s work items as a file. See Atlassian’s CSV export steps.

On Jira Premium and Enterprise, a plan’s timeline exports through Share > Export > Export data (.csv). Only the data visible on the timeline is included, so set the plan’s filters first. See exporting plan data as CSV.

Boards and backlogs have no export button of their own. Open the board’s ••• > Board settings, where its filter query is shown, and run that query in search; or write a search that matches what you need, for example project = SHOP AND sprint in openSprints() for the active sprint. Then export the results.

The Jira Cloud for Excel add-in

Jira Cloud for Excel is Atlassian’s free, official add-in for Excel in Microsoft 365. Instead of downloading a file, it pulls work items into a sheet from a JQL query or one of your starred filters, and it can refresh them on a schedule, which suits reports you rebuild every week. See the Marketplace listing and Atlassian’s setup article.

The rows arrive flat, like a CSV export. Add the Parent field as a column to see which epic or story each row belongs to, but the add-in does not nest children under their parents. For a sheet that keeps the hierarchy, see the next section.

More than 10,000 work items, and garbled characters

Atlassian supports exporting up to 10,000 work items in one CSV export. For more, it recommends splitting the search into smaller JQL ranges, such as one date range at a time, exporting each, and combining the files. See exporting more than 10,000 work items.

Jira writes CSV files in UTF-8. Older versions of Excel can misread them, which shows up as garbled accented or non-Latin characters. Opening the file in a current version of Excel, or another spreadsheet that reads UTF-8, avoids it.

How to keep the hierarchy when you export Jira to Excel

Atlassian’s export documentation does not describe keeping parent and child work items nested. Each work item arrives as its own row, so a sheet of epics, stories and subtasks has to be put back into shape by hand: sorting by parent, then indenting each level.

A hierarchy-aware export does that work for you. It writes the rows in tree order, so each work item sits directly under its parent, and it marks how deep each one is. The result reads like the hierarchy itself, and it still sorts and filters like any spreadsheet. For how the levels fit together, see the Jira hierarchy guide, and for the two levels people most often need to export, the Jira epics and Jira subtasks guides.

Export Jira to Excel with Cascade, hierarchy included

Cascade is a Chrome extension that shows your Jira Cloud work as a tree inside your Jira tab, and exports what you see.

  1. Install Cascade from the Chrome Web Store and open your Jira Cloud site. No Jira administrator has to install anything, though your employer’s browser policies may restrict extensions.
  2. Choose the work. Open Cascade and pick Assigned to me, a set of epics, or a whole space. Filter and sort it the way you want the sheet to look.
  3. Export. Choose Download CSV, or Copy for Excel to paste straight into a sheet. Pick indented to keep each work item under its parent, or flat for one row per work item.
Cascade’s export buttons: Copy for Excel (flat) and Download CSV (flat), with the menu open on Download CSV (indented), labeled Cascade Pro, free in early access.
Cascade’s export menu, shown with sample data.

The export follows the filters and sorting in your view. Copy for Excel is capped at 5,000 rows, and an export that stops short says so in its file name. Flat export is planned to stay free; indented export is labeled Cascade Pro and is free for everyone during early access. To see the format first, download a sample indented CSV.

Try it on an epic you know

Export one epic with its stories and subtasks, then open the file next to Jira and compare.

Add to Chrome (Chrome Web Store, opens in a new tab)Cascade runs in Chrome on a computer.

Jira export FAQ

What is Jira Cloud for Excel?

A free Atlassian add-in for Excel in Microsoft 365. It pulls work items into a sheet from a JQL query or a starred filter and can refresh them on a schedule. The rows come in flat, without parents and children nested.

Can Jira export directly to Excel?

Jira Cloud downloads search results as CSV files, which open in Excel, and shows an Open in Microsoft Excel icon above the results so you can skip the download.

How many work items can I export from Jira at once?

Atlassian supports up to 10,000 work items in one CSV export. For more, split the search into smaller ranges with JQL, export each one, and combine the files.

How do I export a Jira board or backlog to Excel?

Boards and backlogs have no export button. Copy the board’s filter query from its settings, or write a matching search such as project = SHOP AND sprint in openSprints() for the active sprint. Run it in search or the list view, then select ••• > Export.

Does Jira’s export keep epics, stories and subtasks nested?

Atlassian’s export documentation does not describe keeping parent and child work items nested. A hierarchy-aware export, such as Cascade’s indented CSV, writes each work item under its parent.

Why are characters garbled when I open a Jira CSV in Excel?

Jira writes CSV files in UTF-8, and older versions of Excel can misread them. Open the file in a current version of Excel or another spreadsheet that reads UTF-8.

Is exporting with Cascade free?

Flat CSV and flat Copy for Excel are planned to stay free. Indented export, which keeps the hierarchy, is labeled Cascade Pro and is free for everyone during early access.

Ahmad Fiaz Jan
About the author

I’m Ahmad Fiaz Jan, and I build Cascade for Jira on my own. I write these guides from Atlassian’s own documentation and link every source. More about me at ahmadfiaz.me and on LinkedIn.