Exporting Search Results to Microsoft Excel

JIRA enables you to easily export your search results from the Issue Navigator to Microsoft Excel. This can be a useful way to format data and create your own customized reports, graphs and charts.

Exporting to Microsoft Excel

Before you begin:

  • Large exports (e.g. many hundreds of issues) are not recommended.
  • To change the number of issues that are exported, change the value of the tempMax parameter in the URL.

To export search results to Microsoft Excel:

  1. Choose Issues > Search for Issues.
  2. Refine your search, as described in Searching for Issues, then choose the Export menu.
  3. Choose one of the following from the dropdown menu:
    • 'Excel (All fields)'— this will create a spreadsheet column for every issue field (excluding comments).
      • Note: This will only show the custom fields that are available for all of the issues in the search results. For example, if a field is only available for one project and multiple projects are in the search results then that field will not appear in the Excel document. The same goes for fields that are only available for certain issue types.
    • 'Excel (Current fields)' — this will create a spreadsheet column for the issue fields that are currently displayed in your Issue Navigator.
  4. A file called <My company's JIRA> - <My project>.xls will be created. Edit this file using Microsoft Excel and/or save it as required.

Here is a sample exported file, viewed in Microsoft Excel:

 

Last modified on Sep 13, 2013

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.