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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

795 views 2 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