This question is in reference to Atlassian Documentation: Exporting Search Results to Microsoft Excel
Please find attached an example, where you would see that I'm not able to export excel spreadsheets anymore. I'm just able export CSV's
Screen Shot 2016-09-21 at 10.29.33.png
Thanks in advance
Not happy with this, now I'm asking for Excel, can we get back the excel export functionality?
But I don't understand why removing this feature which was working quite well and very easy to export?
Now I need to do more steps and need to take risks with converting it from CSV to XLSX.
I'm not sure why it was removed - the options are already in a menu, which means it's not like adding the CSV links would have cluttered a view any more. I don't think anyone would have complained about two more appropriate items being added to a menu. My best guess is just that Atlassian don't want to have to maintain the old excel code as well as CSV. If I were the product owner, I'd have said "deprecate them and note that we won't be spending any more time on Excel, but leave them in for now"
Excel exports have been deprecated and replaced with CSV exports as that's what people were asking for. CSV files can be opened by spreadsheets, although they don't have as much formatting as the excel stuff had.
CSV results are nasty when trying to retain format, and some values change their entire presentation.
Suggest you use the HTML option, download the file and open it with Excel. You can then save it as an xlsx file.
This seems to work the best for me.
You may have heard that Microsoft recently made a security update in MS Excel, which disallowed opening the "Excel exports" generated by JIRA anymore. I'm using quotation marks, because in fact, the Excel files that JIRA generated were HTML files with the ".xls" file extension, that were prepared in a way so that Excel can import them.
You could actually work around that recent change, by turning off some security checks in MS Excel, but that's to be done in all staff member's Excel. (It may not be realistic in large teams.)
This change has broken certain routine procedures for me. Tom Proctor's answer above held some promise, but now the HTML option is also missing from the selection choices.
A workaround for Tom's workaround is to use the Print List option instead which will bring up a static web page. Right click in the browser window, Save Page As..., then Web Page (html only). Open that file in Excel. The formatting is better than csv (at least it retains column integrity) but not as good as the old way.
My next step is to set up a preformatted Excel template to make the regular reports look good.
Several steps to replace the deprecated feature.
With add-on 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
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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