Symptoms

In the issue navigator, when creating an Excel file using the "Views -> Excel (all fields)" menu, the Excel file is created successfully, but each issue has two rows.

The following is an example screenshot of the the two rows present for each issue:

As we can see, row 5 and 6 are both used for issue XXX-5. The same is true for other issues.

Diagnosis

There are two ways to check the root cause:

1. Check the JIRA Version, if it is JIRA 4.2, you can refer to this bug ticket: JRASERVER-22618 - Excel Export adds the issue key to the Project column & an extra blank row between records, which has been fixed in JIRA 4.2.2.
2. If you are running JIRA 5.X, run JIRA in a safe mode. This will disable all your user-plugins temporally. In the safe mode, generate an .xls file again and the problem should disappear.

Cause

The cause is unknown, as is often the case for third party plugins. Some of the plugins that might cause this problem are:

• JIRA Gantt-Chart third-party plugin.
• TestFLO for Test Management

Workaround

Disable/uninstall the plugin when performing Excel exports.