nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to export JIRA issues to Excel?

tgefen

I read the manuals (of 6.4 and 7.3) and I'm supposed to find an option to export to Excel format. BUT I can't find it on my JIRA Software server 7.3 instance.
What goes wrong? Where is it? Should I use CSV only?

If it's gone: are there any recommended add-on?

Thanks

Accepted answers

Philipp Suchan

See here for the official Jira Cloud to Excel export: https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official

All comments

Thorsten Letschert _Decadis AG_

Hi there,

this feature will soon be deprecated, but can still be reenabled by now using the following instructions (found here):

JIRA Server 7.2 instances
We removed the Excel export option in JIRA 7.2, as we've introduced a more robust, flexible exporter in the CSV export. We hope you find this more beneficial. We do plan on removing this functionality entirely, however in the meantime it can be unlocked with the following steps:

Stop JIRA.
Locate the jira-config.properties file in the $JIRA_HOME directory. If the file does not exist, please proceed to create it.
Open the file and add the below on a separate line:
jira.export.excel.enabled=true
Save this file.
Restart JIRA.

Cheers.

Nic Brough -Adaptavist-

Thorsten, you should be aware that "we've introduced a more robust, flexible exporter in the CSV export" is incorrect.

The CSV exporter is not robust or flexible, and the clear consensus from users is that it is not a viable replacement for the Excel export yet. Until it meets the minimal functions that the Excel export does, I'd expect Atlassian to keep getting support calls to re-enable the working export.

Aron Gombas _Midori_

As for add-on recommendations, the Better Excel Plugin is not simply a replacement for the built-in and deprecated Excel export feature, but it comes with a ton of improvements!

Thorsten Letschert _Decadis AG_

Hey Nic, just to make this clear: I've only quoted and I'm completely on your side regarding my own personal opinion regarding this issue.

Cheers.

Raivita Kramzaka

Yes, and you have to spend a lot for it.

Martin Dusch

Till which Jira Version Excel Export can be re-enabled? We are currently using 7.5. Is it still possible there?

banos solomou

And it causes cluster outages because it chews up 50% heap.

Raivita Kramzaka

We have Jira version 7.6.1 - still are able to use the excel export function.

Nic Brough -Adaptavist-

Yes, even 7.10-EAP has it.

Dnyaneshwar Ramesh Borase

Hello Team,

We have plan to upgrade JIRA with a latest version doing upgrade analysis for JIRA upgrade.

Now, we are using above workaround for JIRA v7.3.6 Export JIRA issues to Excel as mentioned by Thorsten Letschert.

But, if we are upgrading JIRA from v7.3.6 to v7.9.2 then please let us know still excel export functionality are working perfectly?

If not, please let us know the workaround for this export functionality for the latest JIRA version.

Thanks!

Chandan Gupta

Hi Guys.. My apologies for instead of answering the question I am making a new ask : export to CSV is not reliable.

I am facing 2 issues :

1. When I click on export to CSV ( Current Columns) it is not exporting all the columns selected and visible in filter tab.

2. When I click on export to HTML (Current Columns) it is not exporting all the columns selected and visible in filter tab and less columns which got exported via CSV..

Any Ideas?

Jack Brickey

What fields specifically are not exported? Some fields that show in the results are calculated and won’t export.

Dnyaneshwar Ramesh Borase

Yes, It is possible till 7.10.2 & working fine with the following steps:

Stop JIRA.
Locate the jira-config.properties file in the $JIRA_HOME directory. If the file does not exist, please proceed to create it.
Open the file and add the below on a separate line:
jira.export.excel.enabled=true
Save this file.
Restart JIRA.

Annika_9n6mf0

And the CSV export does not include the URL for quick linking back to the issue

Hsu Kim Oon

How can we include calculated field values in the export?

Jack Brickey

You cannot export but you could recalculate within excel from the values that are exported.

Pavel Chernikov

There should not be a need to purchase any addons for functionality that came, and should come, with the product. Is this Atlassian's way of milking customers for more money? I'm sure they get a cut of every addon that's sold...

Michael J. Schneider

Why can't I connect my export back to JIRA via SQL connection so all I have to do is refresh the spreadsheet, rather than have to continually do exports. All my pivots and charts then have to be recreated every time.

Inetum-Realdolmen Admin

This workaround works with Jira core V8.1.0 but not with Jira core v8.2.2.

Ryan Winne

Is there a limit to the number of items that are exported? Seems like it might be limited to 1000.

Jack Brickey

correct. there are a lot of posts on this and here is an article that might be useful - export-over-1000-results-to-excel-from-jira-cloud

Philipp Suchan

See here for the official Jira Cloud to Excel export: https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official

JP De La Rosa_1qaman

I am getting an error... any idea why?

Philipp Suchan

Hi @JP De La Rosa - are you getting the error when attempting to install the addon? If so you must have an Office 365 subscription, as well as be on either:

version 1904 or later for Windows

version 16.24 or later for Mac

Ian McGrady_fbte9q

Hi - newish to Jira here - did you find a work path to solve this problem? I'm in that same boat.

Martin Böhme

Jira Cloud has now an Excel Export Button (Excel Online or Download) by default

Dalan Andersen

Martin,

I used the Excel Export Button. However, the "Reporter" field and the "Creator" field is a long unrecognizable text string. I would like it to show the Name or email of the person who sent the ticket.

Martin Böhme

Hi Dalan,

That's probably because Atlassian Cloud recently changed from usernames to user IDs.

But nevertheless, when I download the XLSX file, Excel asks me to enable "Jira Cloud" Plugin with receives the data live from Jira and inserts it in Excel. This way, the full names are shown correctly:

2020-04-27 10_57_58.png

felix.weber

Hi guys,

Excel Export Button (Excel Online or Download) by default => but where to find it ? checked for Jira Software and Jira Service Desk projects

or do I need to install an app ?

Harsha Nath Jha

Thank you Philipp

Quastan

Hi there,

I couldn't see any functions on exporting filtered result into excel:

Martin Böhme

Hi @Quastan

Thanks for providing that screenshot. It shows that you are on the Jira Service Management Customer Portal of your Jira Cloud site. From there, no export options are currently available.

Please go to your Jira's 'backend' on http://razerweb.atlassian.net/, perform a search operation and look for the export options there.

Best,

Martin

Quastan

Hi Martin,

Thank you for your reply. I am afraid I didn't know how I am going to go to 'backend' on http://razerweb.atlassian.net/. Could you assist me on this.

Thank you

Martin Böhme

@Quastan Just click on the link. If you land on the portal again, it means you are only a customer with no Jira license and that means you can't do any exports.

Rina Nir

Hi Excel exporters,

Sometimes, the main reason to export to excel is that you will have a static copy of how Jira is today.

If this is what you need, you may check out this new App Jira Snapshots for Confluence (Cloud and DC)

Things this App does better then an excel export:

If you regularly export the same filter, then Jira Snapshots allows you to take a new Snapshot with one click, and compare to your previous Snapshot. So you see how Jira changed over time. Its the only way to easily compare Jira data in two points in time.
You can export multi-level data: like epics, Their stories; and their subtasks
Formatting of fields closer to how they are presented originally in Jira (this is a particular issue in Cloud)

Disclosure: I am the CEO of RadBee, the makers of this App

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software

export