In this page
Updating Excel template configuration variables
Creating new Excel templates
Comments, worklogs, history
Created vs. Resolved reports
Time in status reports
Jira Software agile reports
Jira Service Desk reports
Advanced Roadmaps reports
Zephyr test reports
Visual Basic powered reports
This gallery displays sample exports created using the "factory-default" templates shipped with the Better Excel Exporter for Jira. Our aim is to give you a quick understanding of what is possible out of the box. This is, obviously, just the beginning of the story, because the possibilities of report creation and customization are unlimited.
You can use the "factory-default" Excel templates in many ways:
- As they are! (We polished them further and further over the years so that they give a ready-made solution for most situations.)
- Configure their look and behaviour by updating their configuration variables (see next section).
- Customize their look and behaviour by editing the templates and the Groovy scripts.
- Make a copy of them for the starting point of a new template.
- Use their implementation as "cheatsheet" when developing custom templates.
Updating Excel template configuration variables
Many of the templates shipped with the Better Excel Exporter for Jira offer configurability via variables. These variables appear in the top part of the Groovy scripts, and are documented right in the code.
Some variables are required to work correctly (like setting up the Tempo authentication for Tempo exports), while others affect the export's look or behaviour. For instance, the Groovy script that connects to Tempo (tempo-tool.groovy) offers the following configuration variables:
tempoApiToken = 'e4f41d78-f8e1-407a-9fba-ccafd2c83d86' tempoDateFrom = '2000-01-01' tempoDateTo = '2099-12-31'
You can edit the configuration variables intuitively:
- Login to Jira as administrator.
- Go to Administration → Add-ons → Excel Templates.
- Click the template file you wanted to edit, for example tempo-tool.groovy. It opens in the built-in template editor.
- Edit the variables.
- Save your changes.
- Make a new export. It will reflect the changes in the configuration variables immediately.
Creating new Excel templates
For those who'd rather focus on their core business and use Midori's expertise to create custom Excel templates for them, Midori offers template development services.
Issue exports sharing customer-facing document archiving
The issue-navigator.xlsx template exports Jira issues to Excel spreadsheets from the Issue Navigator using the currently configured columns and ordering. It allows you to create custom Excel exports from ad-hoc JQL searches and saved filters with a single click.
Note that each cell is intelligently exported with the correct data type (text, number, date, link) and data format (number formats, date formats), there is no need for further "manual post-processing".
As for visuals, this one and all our Excel templates apply the "invisible design" paradigm, allowing readers to focus on the data. Nevertheless, you are welcome to customize its look to your own branding and needs.
Comments, worklogs, history sharing customer-facing document archiving
The default template set includes specialized versions of the issue-navigator.xlsx template to export the comments, worklogs, Tempo worklogs, change history (commonly known as issue metadata) along with the field values. These specialized templates support both the selected fields and all fields scenarios, and append the metadata in the right.
The metadata values are exported to separate "atomic" columns (comment author, date and text separately) and to multiple rows (when an issue has multiple comments) for a structured data layout.
Calculated fields scripted fields calculated fields
In addition to field values, you can easily export calculated values that are not present as issue fields, but are calculated dynamically during at the time the Excel export is being created. Better Excel Exporter ships with several built-in calculated fields that you can use without customizing any template or writing any script. Or, you can dive in and define your custom calculated fields with low efforts.
Learn more about the Calculated fields
See the Calculated fields page for the tutorial video and the configuration guide.
Created vs. Resolved reports reporting business intelligence
The created-vs-resolved-report.xlsx template exports the creation date and the resolution date (both transformed to year, month and day components using Excel functions) plus several issue fields to its last worksheet. Then it displays multiple pivot tables and pivot charts using various combinations of the Jira project key, issue type, status, assignee, etc. fields in the other worksheets.
You can easily clone and customize the Excel template to your needs, by adding, modifying, deleting field values or by adding, modifying, deleting pivot worksheets. The resulted reports are delivered ready-made (no need for further clicks), also working perfectly in automation for periodically updated reporting.
Worklog reports time tracking reporting business intelligence
The worklog-report.xlsx Excel template effectively aggregates the worklogs of the issues resulted from any arbitrary JQL search. It helps to understand the total time spent on the issues, projects, issue types, versions, components, etc. grouped and filtered by date ranges, users, etc.
Pro tip: making a copy of the original template and customizing that, you can create your ideal Jira worklog report and other time-based Excel report much easier.
Time in status reports SLA reporting business intelligence
The workflow-report.xlsx template calculates various time metrics from Jira data: Time in Status X (for each status), Time to First Response, Time to Resolution, etc. It also offers average and totals in the form of pivot tables and pivot charts. It enables you understand the lifecycle of your issues and the performance of your team/service.
In addition to customizing the pivot tables and charts, there are many ways to customize the underlying data itself. For instance, you can add your own time metrics by modifying the workflow-report.groovy script. Or, you can add your own SLA formulas like "if priority is Critical and Time to Resolution is less than 4 hours, then the SLA is met, otherwise breached". It's all up to you!
Jira Software agile reports scrum reporting kanban agile
Better Excel Exporter fully integrates with Jira Software, the Jira edition custom-tailored for software engineering teams. First, Jira Software specific custom fields (Sprint, Epic, Story Points and Development) are exported to Excel. Second, the Excel Export menus are seamlessly integrated to the Jira Software screens: to the Backlog view (to export one specific sprint or the backlog) and to the Scrum and Kanban boards (to export the issues in one column).
All in all, this allows you easily extending the built-in Jira Software reports with custom ones, even across projects, across sprints or calculated from arbitrary JQL queries.
Learn more about the Jira Software integration
See the Jira Software integration page for the tutorial video and the configuration guide.
Jira Service Desk reports ticketing sla reporting business intelligence
Jira Service Desk is Atlassian's fast-growing IT service management offering for IT operations, customer service and business teams. Better Excel Exporter integrates with Jira Service Desk and exports tickets, queues and other Service Desk related information like comments, SLA status, CSAT ratings, etc. to Excel reports.
Not only the Service Desk managed custom field types (like SLA or Request Type) are supported, our app also integrates its Export drop-down menu to the Queue view, the most important screen in Service Desk. That allows exporting the tickets from a queue to a custom Excel report with one click.
Learn more about the Jira Service Desk integration
See the Jira Service Desk integration page for the tutorial video and the configuration guide.
Advanced Roadmaps reports project management program management portfolio management roadmap
Advanced Roadmaps for Jira is Atlassian's Project Portfolio Management (PPM) solution, an agile roadmapping and project planning app for Jira Software. It helps project managers see the big picture by combining multiple projects and resources on a single timeline. (It was formerly called Portfolio for Jira.)
Better Excel Exporter exports the Advanced Roadmaps custom field values, including Target Start Date, Target End Date, Team, Parent Link and Original Story Points, to Excel. Using the power of JQL, you can create custom Excel reports from the complete portfolio, from multiple programs, from multiple plans, from multiple plan levels, or all these combined!
Learn more about the Advanced Roadmaps for Jira integration
See the Advanced Roadmaps for Jira integration page for the tutorial video and the configuration guide.
Zephyr test reports test management testing reporting
Better Excel Exporter is tightly integrated with Zephyr, the most popular test management app for Jira. Zephyr tests are "first-class citizens" in the Excel exports, meaning that similarly to Jira issues, you can export all test-related information to Excel. It includes test case details (fields, attachments, comments, etc.), test steps, test executions and detailed step results during an execution.
Of course, you can use all the Excel features, from functions and formulas to pivot tables and pivot charts, on Zephyr data. With those, you can implement literally any type of Zephyr test report.
Learn more about the Zephyr integration
See the Zephyr integration page for the tutorial video and the configuration guide.
Tempo reports time tracking reporting business intelligence
Tempo Timesheets is the most widely used time tracking app for Jira. Better Excel Exporter can export all the Tempo-managed custom fields (e.g. Account, Team and Iteration), the Tempo worklogs and the custom work attributes (e.g. Billable) to Excel. To make it convenient and intuitive, you can export not only from the Issue View and from the Issue Navigator, but also directly from the Tempo screens.
Overall, it is possible to build Tempo reports of any complexity with the help of Excel functions, formulas, pivot tables and pivot charts.
Learn more about the Tempo Timesheets integration
See the Tempo Timesheets integration page for the tutorial video and the configuration guide.
ScriptRunner reports scripted fields reporting calculated fields
ScriptRunner is the most powerful app to extend and customize Jira with every kind of custom logic, programmed in Groovy scripts. Among other extension points, you can implement custom fields with it, whose values are programmatically calculated or automatically loaded from external databases, APIs or other sources.
Better Excel Exporter allows exporting all those script fields to Excel spreadsheets, including both the ones powered by built-in and by custom Groovy scripts.
Learn more about the ScriptRunner integration
See the ScriptRunner integration page for the tutorial video and the configuration guide.
Insight reports reporting business intelligence asset management
Insight is the leading asset management app for Jira. It allows implementing CMDB, EAM, ITAM, SAM and HAM functionality on the Jira platform.
Better Excel Exporter exports all Insight custom fields with the desired granularity (object keys, names and attributes) to Excel. Having full access to Insight objects and their attributes in Jira, you can easily implement custom reporting and Business Intelligence on Insight data.
Learn more about the Insight integration
See the Insight integration page for the tutorial video and the configuration guide.
Visual Basic powered reports reporting
The Excel files exported from Jira do not need to be fully static. Certain use cases may require adding extra logic for dynamic post-processing, for interactions and for other purposes.
Better Excel Exporter for Jira fully supports Visual Basic (VBA), the native scripting language of Microsoft Excel, to meet those requirements. You can add the Visual Basic code to the Excel template, then all reports generated from that template will be able to execute it.
Learn more about the Visual Basic macros
See the Visual Basic macros page for the tutorial video and the configuration guide.
Other reports data integration data analysis archiving
Better Excel Exporter enables working not only with Jira issues but with any kind of data. Our motto: if the data is available from Jira core, from apps or from external data sources, then template customization, Excel features, Groovy scripts, Visual Basic macros can extract insights from those in any possible use case.
This section shows examples of exporting information which is not strictly related to Jira issues.
Learn more about the Custom Excel reports
See the Custom Excel reports page for the tutorial video and the configuration guide.