While Jira itself provides many options to create reports, many teams prefer traditional spreadsheet builders like Microsoft Excel and Google Sheets. So Atlassian has built Jira Excel integration. With some platform’s built-in features users can easily export Jira data to Excel for further use and analysis. However, the functionality is quite limited. That’s why, if you deal with a great amount of data and need more profound reporting options, you should consider using the Jira Excel plugin. For example,
Better Excel Exporter for Jira. This add-on makes it possible for the teams to use functions, formulas, charts, pivot tables, pivot charts, Visual Basic, and other data-crunching tools in Microsoft Excel to get more insights from their Jira data.
Unlike Jira's built-in Excel- and CSV export features, it creates real files in XLSX format, and they are compatible with Microsoft Office, Google Spreadsheets, Apple Numbers, and Open/Libre Office. This means you can save a lot of time as there is no need to do any work manually.
The app allows exporting issue lists, which may include metadata (comments, work logs, change history), created vs. resolved reports, work log reports (timesheets), workflow reports (time in status), Jira Software agile reports, Jira Service Desk reports (SLA), Zephyr test reports, Tempo reports, and Insight reports.