Jira Issues XLS export is not compatible with non-Excel spreadsheets

I am unable to export Jira issues into any format I can easily use.

In particular, an XLS file exported from one of my saved filters (10300, with "Current Fields") uses an HTML format file instead of the typical XLS format. I imagine some versions of Office support such a thing, but Numbers, even the most recent version, certainly doesn't.

Can you all please fix this? Or better yet just support CSV export? (See https://answers.atlassian.com/questions/84144/how-to-export-issues-as-a-csv-file#fmanswer) I don't think it's a lot to ask that we should be able to import our issues data into things other than Excel.

2 answers

JIRA's XLS export is really not XLS. It is HTML renamed as XLS. There are still some pending requests for that feature - https://jira.atlassian.com/browse/JRA-27567 and https://jira.atlassian.com/browse/JRA-32352

This add-on might be of help - https://marketplace.atlassian.com/plugins/com.zenofx.jira.dynamicreport

Use the Better Excel Plugin for JIRA to export real Excel spreadsheets (in XLSX format) from JIRA.

It produces files in Excel's native file format (that can also be imported to Open Office or Google Spreadsheets), allows using Excel formulas and functions, Excel pivot tables and more.

See the comparison why it makes a difference (there is a lot!) or read the user docs.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,442 views 15 19
Read article

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