Unable to Export in Excel - Missing: Excel ( All fields ) / Excel ( Current fields ) options in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Users aren't able to export in "Excel". The option below are missing from Jira's built-in Export button on the browse Issues section.
Excel ( All fields )
Excel ( Current fields )
Environment
Jira Server / Data Center
Diagnosis
In order to enable the Excel export option, you need to add the line below to this file JIRA_HOME/jira-config.properties.
ℹ️ This file is located in the Jira application home directoryIn new Jira installations, this file may not initially exist and if so, it needs to be created manually in that directory.
However, even though the property is set on this file, the excel export options are still missing from the Export button on the browse Issues section. (blank spaces were added on purpose in the end of the line below):
1
jira.export.excel.enabled = true _________________ (blank spaces) Important
Please use an xls viewer application to open the exported file, once it is not compatible with new versions of Excel.
More details can be seen on the bug: JRASERVER-61891 - Search results exported to Excel result in empty sheets due to Microsoft security update
Cause
This seems to be a very old BUG in JIRA_HOME/jira-config.properties file, as tracked in JRASERVER-25388 - jira-config.properties file does not ignore spaces in the end of lines and still persists on newer versions of Jira.
The root cause is because you added blank spaces in the end of the line where you have added the property. Due to this, The jira-config.properties file ignores the parameter if there are blank spaces in the end of the line.
This happens to any properties configured in the jira-config.properties file.
Solution
Simply remove any blank spaces in the end of the lines of each property set on JIRA_HOME/jira-config.properties
Restart Jira for the changes to take effect.
Was this helpful?