Export to Excel & CSV
From the List, select Export › Export to Excel or Export to CSV. To export only some items, select them first and use Export in the bulk menu.
The export includes the work items currently shown, with your filters applied, and the columns you’ve chosen.
Excel export
Section titled “Excel export”The Excel export opens an options dialog. The workbook is built in your browser, so no data is sent anywhere.
Work items sheet
- Real Excel types: dates are dates, numbers are numbers, and time is in hours, so you can sort and use formulas
- Work item keys link back to Jira
- Frozen header row and auto-filter
- Groups from the List become collapsible Excel outline groups with subtotal rows
- A totals row for numeric columns
- Status colors
- Option to include all fields that have a value, not just the visible columns
Extra sheets (optional)
| Sheet | Contents |
|---|---|
| Summary | Breakdowns by status, assignee and more, with data bars, plus time logged per person |
| Comments | Every comment, with author and date |
| Worklogs | Worklogs in a date range you choose |
| Change history | Field changes from each work item’s history |
| Time in status | How long each item spent in each status |
| Links | Work item links and their types |
CSV export
Section titled “CSV export”CSV exports the visible columns as plain text, ready to import into other tools.
Calendar export
Section titled “Calendar export”To export calendar dates instead, see Calendar › Export.