export to excel: can't import into googleDoc's or Mac numbers - Must use Open Office?

[Wesley Monroe]

I've exported an issue list via the view:Excel (All Fields). It indeed downloads a file with a .xls extension, but neither the mac (Numbers), nor Google Doc's (spreadsheet) can open it. I CAN open it with open office, then save as .xls and I can open on other platforms. Please tell me there's a better way :-).

[Wesley Monroe · Accepted solution]

This is apparently a feature request or bug fix, depending on your perspective, so there is no answer and I'm closing this question.

[Caroline]

Imagine my surprise when I found this is still impacting users nearly 5 years later.

[Angie Canon]

I am trying to open an export of an Issues list using Google Spreadsheets and Mac Numbers. It works on neither, as the other users have noted. I have to open in an MS Excel view-only version and copy and paste to Google Spreadsheets.

What is it about the JIRA xls that causes this problem? Frankly, I don't really care. Just please come up with a solution so we can use the app of our choice.

[Mathias Ericsson]

I'm having the exact same problem and need to find a way to export information from Issue explorer, or have a way to sum all stories Story points in the issue explorer. A CSV option would be awsome, do you have any plans on implementing this?

[Meni Lubetkin]

export to Mac numbers doesn't work

please come up with a solution so we can use the app of our choice.

[Claudia Astazi]

this is a fee for microsft.. ?

[Deleted user]

Libre Office 3.4.4 didn't work for me :-( Please Jira give us CSV export!

[Ben Mehling]

For what it's worth, I've installed LibreOffice to open the ".xls" files exported from Jira. From there I can copy/paste into gDrive.

[Jack Baty]

I would also prefer a simple CSV option. The Excel export does not offer me enough benefit over CSV to justify the requirement of using Excel to view it.

[Ben Mehling]

Same issue here. Google Docs / Drive attempts a conversion and then complains "The uploaded file has the wrong format specification - for example, you might be trying to upload a CSV file as a XLS file." I've tried chaning the extension to .xlsx too, w/out any luck.

Further info: my mac can generally preview office documents, including Excel files, but in the case of this document, it cannot open them either.

This is pretty annoying (to me) as we don't use Office.

Can we please just have a download as .csv option (in the Views menu of the Jira Issues search screen)?

[Felipe Reis]

Im having the same issue....