• Community
  • Products
  • Jira
  • Questions
  • I'm not able to export excel spreadsheets anymore. Only Excel CSV is possible. Before I was able to export excel spreadsheets

I'm not able to export excel spreadsheets anymore. Only Excel CSV is possible. Before I was able to export excel spreadsheets

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

Stefan

6 answers

Not happy with this, now I'm asking for Excel, can we get back the excel export functionality? wink

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"

0 vote

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.

Hi Stefan,

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.

 

0 vote

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

If, instead, you're looking for actual XLSX format files exported from JIRA, then there is the Better Excel Plugin, offering a viable alternative.

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.

Hi there,

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

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,182 views 13 19
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot