Chances are that you, as a Jira user or Jira admin, have already bumped into the need for a quick Jira Excel export. Sometimes it’s more than a quick export: a sophisticated and customized report is needed, featuring pivot reports and custom analytics. Currently this is not easy given the insufficient Excel export options available in Jira.
To make work easier and to meet the corporate requirement for professional Excel reports, Midori developed the Better Excel Exporter.
Why use Better Excel Exporter to export Jira issues?
- Just install and use - no configuration necessary
- Export multiple issues from the Issue Navigator screen (all fields or just the currently selected ones
- Integrates with all popular Jira apps and comes with prepared templates for Jira Service Desk reports, Tempo Timesheets, Zephyr Tests, Elements Connect and more).
- Custom exports using Groovy scripting
- Easy automation for creating and emailing periodic reports to your boss (or partners without Jira access)
Better Excel Exporter for Jira is really a swiss knife of exporting apps, that you can use on 3 levels.
Jira to Excel export level 1: Getting $#it done
If your Jira to Excel exporting needs are not too complex, you can use Better Excel instantly in an existing Jira environment. If you need regular exports from Jira, chances are that one of the built-in templates the app comes with will fit your use case.
You don’t have to worry about data types either: dates will remain dates, numbers will show up as numbers in Excel, so you can work with the right data type later if needed. In short, you can get real XLSX files from Jira right after installing the app. No questions, no configuration, no hassle.
A list of Jira issues with system and custom fields exported to Excel
Jira to Excel export level 2: Feeding the Excel beast
If you are lucky enough to have business leaders who eat Excel functions for breakfast, BI reports for lunch and pivot charts for dessert, you will need a more complex Excel report template, customized for your company.
You can easily create a simple template in Excel by using expressions in an Excel spreadsheet. Those expressions can be found as part of the documentation, and you can also see how to do it in a tutorial video on Youtube. You can also use some of the complex report templates that come with the app and create professional Excel reports from Jira or Jira Service Desk like this:
A complex pivot report in Excel, created with a built-in template for reports
Jira to Excel export level 3: Being the Excel beast
The real flexibility of Better Excel Exporter shines when it comes to running your own Groovy script. This provides many options for interpreting Jira data and painting with it on the great canvas of Excel.
For example, you can calculate SLAs across a list of exported Jira Service Desk tickets and indicate visibly if one is breached by using conditional formatting in Excel. We pay much attention to building integrations with other Jira apps, so you can even use the custom field values that are coming from Elements Connect, Tempo or Zephyr to incorporate those into your Excel report.
Zephyr test step results with all details exported to Excel
Automating Jira to Excel exporting
Automation is something that you can take advantage of regardless the level you are using Better Excel on. The free Better Excel Automation for Jira app pairs with Better Excel and used together with Automation for Jira, they provide you the automation framework that will take the repetitive workload off your shoulders.
You can set up automation rules to create your Excel exports or reports periodically and take action: save them to your file system, attach Excel spreadsheets to an issue or email your Excel report directly to your colleagues or partners.
Now you have an understanding why Better Excel Exporter is the most advanced tool to export Jira data into simple Excel exports or complex reports. As your reports most definitely will not produce themselves, there is only one thing left:
This blog post is also published in the GetConnected Blog.