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

JIRA 7.2.x Excel export gone?

Michael Kolb Sep 11, 2016

With my old JIRA Version there was an option to export an issue list to an excel file. I've updated to JIRA 7.2.x - the option is not available anymore (only export to Word is left). Unfortunately CSV is not an option, as Excel is unable to correctly import fields that contain the text-delimiter.

How to re-enable Excel export?

11 answers

1 accepted

22 votes
Answer accepted
Marc.Teufel@hama.de Oct 17, 2016

You can activate Excel in your jira-config.properties with following line:

jira.export.excel.enabled=true

(This works vor JIRA Core 7.2.2 and 7.2.3)

Alternatively you can set your Region to US and configure the list separator to comma. Then Excel export/import in Excel will work again.

Alternative 2: Save the csv file and add "sep=," as the first line in the file. When opening the file in excel the comma will be used as a delimiter

Hi Marc,

many thanks for this workaround. I tried it with JIRA 7.2.2 in JIRA SW including a restart unfortunately without any success. Are there any other known pitfalls/things to consider (deletion of caches, etc.), which might help to get this running again.

Cheers
Kai

PS: Another restart helped the export-functionality do re-appear. Thanks for this hint!

Normann P. Nielsen Nov 09, 2016

Works fine in JIRA Software v7.2.3

Borut Hadžialić Dec 04, 2016

Works in JIRA 7.2.2 SW for me.

Leonardo Bertolo Dec 29, 2016

Hi,
would you kindly tell me the path of the properties file?

Inside my JIRA installation there is no jira-config.properties file. I'm using JIRA Software version 7.2.6.

I found $JIRA_HOME/atlassian-jira/WEB-INF/classes/jira-features.properties which had the option jira.export.csv.enabled=true, so I placed inside that file the option you suggested, but while watching catalina.out during startup I found this:

jira.export.excel.enabled : false

 

Thanks in advance for your help!

 

Best regards,

Nic Brough [Adaptavist] Community Leader Dec 29, 2016

It is mentioned in the docs, but well buried.  If you don't have a jira-config.properties file, just create one (simple plain text).  You don't need to put anything else in it, it is just "add the lines you need".

Leonardo Bertolo Dec 29, 2016

@Nic Brough [Adaptavist] thanks! I got it.... I was looking in my JIRA Instalation directory.

I've created the file in my JIRA Home Directory and I got it working properly.

 

I confirm, it's working in JIRA Software 7.2.6

 

Adam Downer Jan 19, 2017

is changing the 'jira.export.excel.enabled' property supported? i.e. if the functionality is being removed then will strange behaviour start to occur if we switch it back on?

Nic Brough [Adaptavist] Community Leader Jan 19, 2017

No, it's not officially supported, because they've turned it off by default.

Turning it on will do no harm though - worst case is that enables a broken version of the exports, but that won't do anything worse than not work well and produce rubbish downloads.  If they remove the code, then the property will simply be ignored.

Deepali Bagul Feb 20, 2017

Hi @Nic Brough [Adaptavist]

Inside my JIRA home directory  $JIRA_HOME/atlassian-jira/WEB-INF/classes/ their was no jira-config.properties file. As per the docs i created jira-config.properties file and added the line jira.export.excel.enabled=true and restart the JIRA server. but this doesn't work for me on our JIRA 7.2.3

Thanks in advance for your help!

Nic Brough [Adaptavist] Community Leader Feb 25, 2017

You're looking in the wrong place.  Nowhere does anyone mention that directory, and it doesn't exist anyway, I've no idea what you're trying to do with that.

Scott McDonald Mar 06, 2017

I'm noticing in the CSV export, if an issue has more than one component, label, etc, it creates a new column rather than prior to 7.2 and using the Excel export, it would concatenate the values in one column.  Is there a setting where I can turn off the "create column for each value"?

 

 

Jeremy Coukoulis Apr 13, 2017 • edited

Thank you Marc.Teufel! I was scrambling when I noticed this option was missing after our recent upgrade, I knew my users would be coming after me with pitchforks!

BTW, this fix works on JIRA core/software version 7.3.2 as well.

Steve Cagle Jun 16, 2017

Thanks so much.  Works great.  Jira Server 7.3.5.

Bhartesh Jul 03, 2017

Guys, i am facing issue in Jira software 7.3.5

As mentioned in the comments i have created a file "jira-config.properties " in location "$JIRA_HOME/atlassian-jira/WEB-INF/classes/" then added the line "jira.export.excel.enabled=true" in the fiile and restarted the server but still its not working.

 

In the jira screen in Export section i am not finding any option called excel.

 

Please can anyone help me on this.

 

Thank you in advance.

 

Like Balakrishna Karanam likes this
Nic Brough [Adaptavist] Community Leader Jul 03, 2017

Excel export is done from the issue navigator.  Search for some issues, then look for the links

Bhartesh Jul 03, 2017

@nic brough , I am tring to expoet from issue navigator only.

I have issue filter which i am trying to export but i am getting to export it in csv, printable, xml, RSS and word.

But i am not finding the export in excel format, which we had in the previous version jira.

 

Thank you in anticipation

 

 

Nic Brough [Adaptavist] Community Leader Jul 03, 2017

Sorry, I didn't notice the directory you've used.

Could you try re-reading the comments above instead of randomly guessing where the file goes?

Bhartesh Jul 03, 2017

@Nic,

The issue was with the file format.

I had saved the file in different format instead of .properties.

This is working now. :-) Thank you..

Nic Brough [Adaptavist] Community Leader Jul 03, 2017

By "format", you mean "location"

3 votes
Aron Gombas [Midori] Community Leader Sep 12, 2016

If CSV does not work for you (or you're looking for something more powerful), the Better Excel Plugin can export actual XLSX files for you.

Ben Middleton Oct 03, 2016

Thanks - this looks interesting. However, we were using the previous bundled functionality successfully. Atlassian should not be removing functionality which requires customers to have to invest in 3rd party solutions.

Tayyab Bashir Dec 14, 2016

This is a nice plugin.
Are there any other plugins that provide the export functionality for Excel but a little expensive? 
 

 

Dan Chambers Jan 09, 2017

You might be interested in the Exporter Issue Comments for CSV and Excel - cheaper but still has the now gone Export to Excel functionality.

Michael Kornatzki Sep 18, 2017

Great, i payed for jira and with every version i need more 3rd party plugins :(

Nic Brough [Adaptavist] Community Leader Sep 18, 2017

Mmm, I think Atlassian's explanation here might be "if you do it the Jira way, you don't need to export"

Michael Kornatzki Sep 19, 2017

It's interesting how Atlassian might be to know how we have to use it.

We need the Excel in the communication with our customers.
They want to get alle the changes in a version in an Excel-Sheet.

3 votes
Valentijn Scholten Oct 09, 2016

Another way in which functionality is reduced with the CSV export is that it no longer exports a direct link (URL) to the issue in JIRA. The prevouis Excel export had this, very conventient for people receiving an Excel sheet and wanting to look at the issue details.

2 votes
Nic Brough [Adaptavist] Community Leader Sep 11, 2016

It's not a case of enabling it, it has gone.

Excel should have no problem reading CSV though.  Is there a setting in Excel that's breaking it?

Michael Kolb Sep 11, 2016

The problem is simple to reproduce: Create an issue with the description 'this is a text containing a "text-delimiter"', and export it (including the field "description") to CSV. The CSV will contain '"this is a text containing a ""text-delimiter"""', which destroys the whole column layout in excel, as the escaped text-delimiter is not recognised.

Denis Boisvert Sep 12, 2016

It should work. You might have the following issue that I had myself not too long ago:

http://stackoverflow.com/questions/2668678/importing-csv-with-line-breaks-in-excel-2007

 

 

Ben Middleton Oct 03, 2016

There are other issues with the new CSV export. For example, if your field includes commas, you can no longer export sensibly. There's a bug for this:

 

https://jira.atlassian.com/browse/JRA-62517

2 votes
Deepali Bagul Feb 27, 2017

Thanks @Nic Brough [Adaptavist],

I was looking at wrong place. I added the jira-config.properties to the root of your JIRA home directory (var/atlassian/application-data/jira/) and added the line jira.export.excel.enabled=true and restart the JIRA server.

I got it working correctly for JIRA 7.2.3 , Thanks !

Quy Duong Sep 13, 2017 • edited

Same here, thanks for the home directory path info.

I created jira-config.properties file (with a text line jira.export.excel.enabled=true), but saved to wrong location /opt/atlassian/jira/ 

After correct saving the properties file to /var/atlassian/application-data/jira/, I restarted JIRA, there are 2 new options added to Export: Excel (All fields) and Excel (Current fields)

I have JIRA v7.4.3

JIRA application home directory
https://confluence.atlassian.com/adminjiraserver073/jira-application-home-directory-861253888.html

Tejas Naik Sep 18, 2017

Thanks guys, It worked.

CANVIA SIGERI May 09, 2018

Si funciona,

Yo estoy in Linux y seguí las instrucciones de  Quy Duong,

 

Saludos,

Ananías

1 vote
AMIT GULATI Jul 11, 2018

We are recently migrated to JIRA 7.2 and faced the same challenge. Here are two ways in which we have been able to workaround:

1. Using Pivot Table and Pivot Chart gadgets in confluence, we are able to create pivot charts on realtime data. 

2. Instead of using export to csv, I have used export to printable, copy all and paste in excel. Although this approach requires little cleanup but it ensures that required fields are in the right format in excel.

 

In my view, export to excel must be avoided as much as possible because that leads us away from using live dashboards and set wrong expectations with stakeholders.

Nic Brough [Adaptavist] Community Leader Jul 11, 2018

I agree - I don't like export to a spreadsheet because it implies the user is going to try to do "clever" reporting. 

I was on a project at a major financial company many years ago where there were a lot of spreadsheets floating around.  We were increasingly having problems where people would use the reports in a system and get a true representation of what was in there, and then seeing people export to a spreadsheet, do "clever" reporting, and start arguments in meetings because their report didn't tell the same story as the one in the system.

We did a project that took a selection of spreadsheets and went into detail about how accurate they were.  The numbers that stick in my mind were that the reports coming out of 30% of them were, quite simply, wrong.  But that was only for simple exports by a single user.  When they were shared and edited by 2 people, the failure rate jumped to over 80% and 3 or more people gave us a 98%.

To be fair, these were not simple spreadsheets where someone has got a couple of hundred lines and generated a simple graph.  All of them had at least one calculation or formula, and at least a thousand lines.

But, I stand by it.  Extracts are mostly useless.  A data extract, manipulation and report should always be questioned as to its accuracy.  And its timing, as a lot of people fail to grasp that exports are point-in-time, and obsolete seconds after being done.

Like Damien Davis likes this
Rafal Sojka Jul 12, 2018

We don't have impact on people who tweak their data but the functionality of application should not be limited due to such reason. Excel is and will be a standard tool in many businesses and unfortunately not all people are so technically savvy they know what CSV is and know how to deal with it. Finally, we had to enable the export to Excel by setting the jira.export.excel.enabled variable to true.

0 votes
Mark Biro Mar 23, 2017

Hi there,

With ImpEx you can import and export your issues to XLSX or HTML (even with comments, images and attachments)!

Feel free to give it a try: https://marketplace.atlassian.com/plugins/com.moresimp.impex/server/overview 

Best regards, Mark

 

0 votes
Gezim Shehu Sep 21, 2017

Still working in JIRA 7.3

 

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.

Sean Kronberg Oct 10, 2017

works in 7.5.0, as well.

Jobin James Apr 01, 2018

works. Thanks

0 votes
Gairat Rakhimbaev Nov 13, 2017

configuration file workaround works in 7.5.0

thanks much!

0 votes
M. Demhartner Nov 24, 2017

We´re using Jira 7.6.0 - with Excel 2016 i am getting an error when trying to open the exported excel file. Excel basiclly says, that the file format is not correct. I can open it after i press Yes, but it looks "broken" - Any1 else has this problem? 

Michael Kornatzki Nov 24, 2017

As far as i know jira never exports an excel-file.

It was only a menu item named "Excel" but it was a html-file with an extension xls.

Therefore now the menu export-HTML is better.

If you look into the "xls" file with an editor you will see html (also in old files).

Gezim Shehu Nov 24, 2017

Michael is correct (Y)

Aron Gombas [Midori] Community Leader Nov 24, 2017

Yes.

Jira exports HTML files with the .xls file extension and Excel finds them suspicious. It has always been working like this.

Please read this question from the top, there are multiple things you can do.

Rafal Sojka Dec 29, 2017

Thank you for update. However, business users who work with JIRA daily do not understand the different between HTML and CSV format and are familiar only with Excel. For them, this change, no matter how it was implemented underneath, is problematic.

Anu Alppiranta Jan 08, 2018

Special characters won't get exported as expected.
UTF-8 encoding worked well with Excel export, but not with Export CSV.

CSVExport.png

Michael Kornatzki Jan 08, 2018

For german umlauts UTF-8 in csv works as expected.

0 votes
Solomon Vansteenburg May 01, 2018

I hate to rise the dead on this thread, but I seem to be in a pickle. I HAD this issue, solved it due to this thread, and now have the same issue again even though the fix is still in place. I upgraded to 7.3.7 back in June of last year and haven't applied any updates since. We were able to export to Excel for a good long while, but suddenly in the past month or so I've been getting reports from the users that they can't do it anymore. Why?

Nic Brough [Adaptavist] Community Leader May 01, 2018

It can't just change like that.  You (as in your organisation, not just you) have removed  or changed the flag from the properties file and restarted Jira

Solomon Vansteenburg May 01, 2018

I'm (supposed to be) the only one who has access, let alone knows anything about me doing it. The setting is still there in the properties file, and the file hasn't been modified since 8/10/2017 when I made the original change. There are a few people who have heightened privileges inside of JIRA. Could it have been meddled with inside of JIRA?

Nic Brough [Adaptavist] Community Leader May 01, 2018

It might be possible to kill it with a property in global configuration -> advanced, or with javascript hacks.  Is the properties file still fully read/write by the jira user? 

I can't think of other ways to remove it. 

Solomon Vansteenburg May 01, 2018

Still fully read/writable. I'm not seeing anything in the advanced settings that pertains to the jira-config.properties file, but there are a few people who have high enough privilege to modify in that space. I will have to look more into that.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

662 views 7 0
Join discussion

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