The issues displayed by the Rich Filter Results gadget can be exported to Excel directly from the gadget. The Export issues to Excel... button is located on the footer of the gadget.
The exported file has the XLSX format and contains all the columns as displayed in the current view (Jira fields and smart columns). The smart column values will have the colors as configured in the smart filter.
In order to prevent the server overload, by default, Jira limits the maximum number of issues that can be exported in one operation to 1000. This limit can be modified by editing the configuration settings or your Jira instance. The properties used to compute the export limits are:
jira.search.views.max.limit: This is the property that limits the number of issues that can be exported and by default it is set to 1000. Only certain users can break this limit, see below.
jira.search.views.default.max: If the above limit is not set, then this limit will be used instead (if it exists). But, in this case, any user can decide to break this limit.
jira.search.views.max.unlimited.group: If the
jira.search.views.max.limitproperty is set, only the users in this group can decide to break the limit.
In case the export exceeds any defined limit, a pop-up warns the user. If the user has the rights to break the limit, he'll be able to check the Ignore row limit checkbox.
Be careful, exporting too many issues (which also have a lot of columns) can be resource intensive for Jira.