-
Suggestion
-
Resolution: Duplicate
-
0
-
4
-
NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.
Summary
When exporting JIRA issues to Excel, it exports files in XLS files. The same occurs for exports to Word, which generates files in DOC format. These files have multiple disadvantages when compared to the new file types introduced by Microsoft in 2007 (DOCX, XLSX and PPTX). That's because those new file formats are XML-based, which allows for much better compression, resulting in considerably smaller files.
Also, Excel's new file format (XLSX) adds an extra layer of security by blocking the usage of Macros, which requires the file to be saved as XLSM. XLS files allows for any Macro to be included and is being blocked by multiple System Administrators, especially in companies with higher standards for security.
Example
Exporting around 4900 issues to Excel from JIRA currently generates a file with an approximate size of 7.5 MB. If we convert that file to XLSX once it has been opened in Excel 2007 or later, the file size drops to less than 10% of the original file's size.
Workaround
The Better Excel Plugin, developed by Midori, adds additional features for exporting issues to Excel in JIRA, including the ability to export directly to XLSX.
Please note third-party add-ons, such as "Better Excel Plugin", are not supported by Atlassian. Therefore, support and maintenance is purely responsibility of the add-on's vendor.
- duplicates
-
- Gathering Interest
- is related to
-
- Closed
-
- Gathering Interest
- relates to
-
- Closed
[JRACLOUD-35369] JIRA Exports files in old format / standards resulting in large file sizes
Basic modern file export format seems like something that should be addressed. Jira Align has the same issue.
The file size isn't the biggest issue here - .xls is the format for Excel 97-2003.
Suggesting a 3rd party plugin because your default export format is 10 years out of date is not the way to go, surely?
After some analysis, we've found that this ticket is a duplicate of the request JRACLOUD-62196 – Filter result Excel(XLS) export is not usable anymore, need XLSX format support which has more votes.
We encourage you to watch and vote on the above instead. All internal ticket references on this ticket have been transferred. If you do not think this issue should have been closed, please add a comment here saying why and we can reopen it.