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?
You can activate Excel in your jira-config.properties with following line:
(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
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.
PS: Another restart helped the export-functionality do re-appear. Thanks for this hint!
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!
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.
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!
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"?
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.
@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
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.
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.
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 !
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
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
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?
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?
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
...; ## Developed by: Alana Fernando ## Shared with love ## @param style:title=style type|type=enum|required=true|desc=Choose a style.|enumValues=Style1,Style2,Style3,Style4,Style5 ## @param alignment:title...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs