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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

1,005 views 3 12
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