NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

Summary

In the exported Excel sheet of a search filter, the custom fields in heading shows 'Custom field (<field name>)'

How to Replicate

1. Go to Search Filter
2. Filter Projects which contains Custom Fields
3. Export (CSV, All Fields) or (Export (CSV, Current Fields)
4. 'Custom field (<field name>)' will show on the Custom Field Header

Expected Result:

Value on the heading for Custom Fields in the shows the name same as UI

Actual Result:

Value on the heading for Custom Fields in the shows the 'Custom field (<field name>)'

Eg. Custom Field is "Reference"
In the UI shows "Reference"
In the Excel shows 'Custom field (Reference)'

Workaround

• As a workaroud you can use the Export HTML Report (current field/all fields). You can then edit the name of the file from <filename>.html to <filename>.xls and it should open up in your spreadsheet program. You may run into this bug: https://jira.atlassian.com/browse/JRA-61891