Are there alternative ways to export issues to Excel in Jira Cloud without using "CSV / Excel CSV"?

Question

Hi everyone,

I'm looking for alternative ways to export issues from Jira Cloud into an Excel-compatible format, without using the standard export options ("Excel CSV" or "CSV").

Context / Background:

* We usually use the export function from the issue navigator (list view)
* However, "CSV (current fields)" and "CSV (all fields)" exports are currently blocked in our environment
* According to Atlassian support, this is due to our organization's security policy after enabling Atlassian Guard
* This functionality worked before enabling Atlassian Guard, but has been blocked since then
* We are not able to change the security settings

What I'm trying to achieve:

* Export Jira issue data into a structured format that can be used in Excel
* Preferably including multiple fields (not just the summary)

Question:
Under these constraints, are there any alternative ways to retrieve issue data in an Excel-compatible format without using CSV export?

If you have handled similar restrictions, I would really appreciate your insights.

Thanks in advance!

Philipp Sendek _catworkx_ · Accepted Answer

Hi @nagata shumpei,

there's a little known trick that might help you here:

If the option to export as HTML is still available, you can export your work items as HTML. Then you change the file extension of this file from .html to .xls (note: not .xlsx).

When you open this file with Excel now, it might warn you, but if you confirm that you want to open the file, it opens it nicely formatted as a table in Excel.

However, assuming that there is a safetly configuration in place I assume that HTML export is also disabled. But maybe you're in luck. :-)

I hope that helps.

Greetings
Philipp

Arkadiusz Wroblewski · Accepted Answer

Hello @nagata shumpei

Actually Excel have an Addon for Jira which can pull out issues from System.

Aron Gombas _Midori_ · Accepted Answer

@nagata shumpei

Our Better Excel Exporter app exports work items and other Jira data to XSLX spreadsheets. It isn't a format that "can be used in Excel", but the native Excel fileformat!

We have been developing the app for 10+ years, it has almost 5K installation and great reviews. It supports the Issue Navigator and a whole lot of other Jira Cloud screens.

It should be working on a site that has Atlassian Guard activated. It supports all built-in system and custom fields, and a bunch of integrations (data from other apps).

Try it free

(Discl. this paid and supported app is developed by our team. Free for 10 users.)