We used to be able to export issues to Excel file format from the Jira Issue Navigator (search and filters). After our company upgraded our PCs to Windows 10 and Office 365 few months ago, we are no longer able to open the Excel files exported from Jira. We're running Jira Server 7.10.2.
The error message encountered is:
"Excel cannot open the file 'XXXXXXX.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
Is Jira exporting to Excel format which is office 97-2003?
JRASERVER-62196 - Filter result Excel(XLS) export is not usable anymore, need XLSX format support
JRASERVER-60667 - File format does not match extension
I have searched but could not find a suitable solution. I have tried to rename the file extension, open in safe mode, open and repair, all to no avail.
Has anyone else experienced the same problem? Is there a way to fix this problem?
It's an older story. The problem is that the "xlsx" file exported from Jira is actually an HTML file with a table, which older Excel versions were able to import. So it was never a native Excel file, but the file extension instruction Excel to import it. Then, Microsoft disallowed this trick for security reasons.
There are every sort of hacky workarounds, or there is the Better Excel Exporter app that produces real Excel files.
(Disclaimer: I am developer of this paid app.)
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events