It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to export JIRA issues to Excel?

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?

export.jpg

 

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

 

Thanks

6 answers

1 accepted

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:

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

Cheers.

Nic Brough Community Leader May 05, 2017

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.

Like # people like this

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.

Like JørgenP likes this

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

Like Ellen Burns likes this

Hi - I am having the same issue but am using Jira online, is there a way to enable the export function in this format?

Thanks

Nic Brough Community Leader Jul 17, 2019

If by "online" (as all Jira systems are "online" or not running at all), you mean "Cloud", no.  You can only export to CSV, which spreadsheets can all read.

Hey,

I need please someone to guide me how to convert Jira issues or selected issue fields to CSV. 

Thanks

Nic Brough Community Leader 10 hours ago

Search for the issues you wish to export from the search option, then use the "export to CSV" option on the tools menu.

7 votes

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!

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

Like Bobbie Price likes this

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

Like Sanjay Babu likes this

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...

Like # people like this
Deleted user Mar 20, 2019

I agree with the people above.

I am pretty new to Jira, have only been using it for about 5 months as a product owner. I already have the feeling that a lot of you think it should be part of the core functionalities have to be purchased separately as an add-on. It is very frustrating to not even being able to export to excel directly. And I have not seen anybody from Atlassian to reply on this thread.

Nic Brough Community Leader Mar 20, 2019

An export to Excel (well, XML that says "Hi, I'm a spreadsheet" anyway) used to be part of the core - it was removed in favour of the CSV export! 

A bad decision in my opinion, the CSV is (still) not ready to replace it. 

The Atlassian line seems to be that the CSV is good enough, and that you shouldn't really be exporting anyway, as your data is obsolete and dead as soon as you do (I do have more sympathy for that - most spreadsheets I run into are simply wrong)

Like full_name likes this

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

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

Nic Brough Community Leader May 03, 2018

Yes, even 7.10-EAP has it.

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!

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.

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 Community Leader Jun 20, 2018

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

How can we include calculated field values in the export?

Jack Community Leader Aug 30, 2018

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

I found that you could get those fields value by exporting using Better Excel (All Fields), but it's a pain to remove all the unnecessary fields to keep just the few you need. Hoping for a better solution available..

Like ivr likes this

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

Early Access: If you use Jenkins and Jira Software Cloud, you need to read this!

The Jira Software Cloud Team has been busy working on a simple, secure, and reliable way to integrate your build and deployment information from Jenkins with Jira Software Cloud. This means you don’t...

2,061 views 2 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you