Why better than the built-in CSV and Excel (HTML) exports?
|Better Excel Exporter||Jira's built-in CSV export||Jira's built-in Excel export|
|Output file format||XLSX (native Excel format)||CSV||HTML (HTML document imported by Excel)|
|Data types||(text, numbers, dates, etc.)||(everything is text → version "1.1" treated as number)||(everything is text → version "1.1" treated as number)|
|Visual formatting||(fonts, colors, sizes, etc.)||(could be hacked)|
|Issue metadata||(comments, worklogs, transitions, change history, etc.)|
|Non-tabular content||(page header and footer, cell comments, etc.)|
|Visual Basic (VBA)|
|Templates||(templates are regular Excel files)|
|Data exchange||(with Google Drive / Docs / Spreadsheets, Open Office, Libre Office, Apple Numbers)||(to some extent)||(to some extent)|
Integrated with the Jira apps you already use
How does it help me work better?
"The biggest benefit of Better Excel Exporter for us is versatility. It can work with prepared templates but at the same time, it's designed to handle large amounts of data and use custom Groovy scripts during data generation."
– Frantisek Spacek, Atlassian ConsultantRead the story →
"Intercompany invoicing within an enterprise group of companies is never the simplest area of accounting.
Better Excel Exporter helped our accounting department process invoices faster, with less errors and less oversight."
– Claudio Menetti, IT ConsultantRead the story →
How BlueSun (a Procter & Gamble spin-off company) created custom reports from Jira Service Management data
"Better Excel Exporter helped us to create every type of custom reports from our service data.
Among others, it enables us to understand how monthly workload is distributed among our agents or to find the top 10 recurring problems."
– Juan Jose Castro, IT Infrastructure ManagerRead the story →
"Our goal was replacing the previously used multi-step process which was complicated, time-consuming and relied on multiple tools.
With Better Excel Exporter we were able to create our Excel reports exactly the way we wanted."
– Tobias, Jira technical expertRead the story →
"The dashboard is a powerful feature in Jira, but we needed something that captures the state of a project in Excel at any given moment without the hassle.
Information sharing vastly improved through progress reports generated by Better Excel Exporter."
– Jana Tkacsuk, Project ManagerRead the story →
"Our users can create their own unique reports in Excel from different Jira screens.
We use the Earned Value Management (EVM) method, so it's especially valuable when managers need to report on EVM."
– Celeste B. Plaisance, Atlassian Collaboration AdministratorRead the story →
"Better Excel Exporter saves us hours creating Jira sprint and project reports, and helps our team discover upcoming roadblocks.
Productivity gaps are then discussed and addressed with the developer team, so it's a real support for process and product improvement."
– Jorge Pino, Technical Project ManagerRead the story →
with the Better Excel Exporter app?
We'd love to know!