Better Excel Export for Jira is a powerful Excel exporter that allows you to report in native XLS/XLSX output spreadsheets and allows you to create spreadsheets template and scripts.
After mapping the Profields's project custom fields to issue custom fields (using the standard Profields feature), the Better Excel Exporter app transparently exports those to Excel:
- You can export the Profields-specific issue custom field types to which the Profields-specific project custom fields are mapped to. The supported project custom field types include Date, Duration, Group, List, Number, Priority, Project, Status, Text and User to Excel. (Cumulative and Script are not supported, as those cannot be mapped to issue custom fields.)
Issues with Profields custom fields
This export contains issues from multiple projects, with the Profields-managed data of their encompassing projects (column E-L). Note that the Profields values are exported with precise data types (numbers, dates, etc.).
Projects with Profields custom fields
Not only issues, but also projects can be exported to Excel (using this technique). If you have a large number of projects, it offers an easy way to search, share and transfer project information between stakeholders or IT systems.
Profields project report
You can also create powerful cross-project, program- and portfolio reports from Profields data. This example contains pivot charts to visualize the project status distribution among projects, the project costs, and the relationship between those (cost by status).