Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-35369

JIRA Exports files in old format / standards resulting in large file sizes

XMLWordPrintable

    • 6
    • 3
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? 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

      Please note third-party add-ons, such as "Better Excel Plugin" or "PDF Exporter & Word Exporter for Jira Issues" are not supported by Atlassian. Therefore, support and maintenance is purely responsibility of the add-on's vendor.

            [JRASERVER-35369] JIRA Exports files in old format / standards resulting in large file sizes

            Qiyong Zhang added a comment -

            Really disappoint!!

            Qiyong Zhang added a comment - Really disappoint!!

            AndreH added a comment -

            This should be an easy implenation, unless you are seeking a 10 year birthday cake.

            AndreH added a comment - This should be an easy implenation, unless you are seeking a 10 year birthday cake.

            Harry Knott added a comment -

            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?

            Harry Knott added a comment - 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?

              Unassigned Unassigned
              6d41c441cbe5 Jason Brison
              Votes:
              10 Vote for this issue
              Watchers:
              15 Start watching this issue

                Created:
                Updated: