Export to excel missing

Hi,

The 'export tot excel' option disappeared from the drop down menu. Is it configurable somewhere?

Thakns,

3 answers

This widget could not be displayed.

On Cloud?  It's been effectively replaced by CSV (Spreadsheets can all read CSV)

Sorry for a stupid question but, how do I know what version I have cloud or server?

If you're using a Cloud system, it'll be on a url of <something>.atlassian.net

Have a look at the bottom of any of the pages to be sure, the version is often in the footer.

 

I'd say not-so-effectively. Especially our project managers have difficulty importing CSV formats (e.g. separator is non-standard) and all the formatting and links to the issues is lost!

Please bring back exporting to a real Excel file!

Ah, the wonders of English and split infinitives.  If I'd got my grammar correct, it might have been more clear.  I was not describing CSV as effective itself, just the act of replacing Excel with CSV.  Even with correct grammar, it remains a sentence that would have been unclear.  Better than what I wrote, but unclear.

I too would prefer to keep the Excel exports, at least until CSV is as good as they were.

This widget could not be displayed.

Yes it seems it is a feature missing from the cloud version.

Aaaarrrrhhhhhhh!

Excel (Current fields) is mentioned in the 7.2 documentation, but not in the cloud documentation (which is version 1000.499.3)

The origin of the problem is this:

[JRA-61891] Exports search results to Excel result in empty sheets due to Microsoft update - Atlassian JIRA

What worked for me on my ancient Excel 2007 installation was:

  • Export to HTML, download file
  • Rename "Capmon JIRA.html" -> "Capmon JIRA.xls"
  • Open "Capmon JIRA.xls" in Excel (ignoring warning)

Voila! But beware. This trick will stop working. See the issue above.

How difficult can it be for JIRA to create a real Excel file? Lesser minds have surmounted this obstacle! smile

See also: Export to Excel (HTML, All fields) or Excel (HTML, Current fields) not appearing - Atlassian Answers .

Not JIRA core, but the Better Excel Plugin can create real Excel files!

(This is currently available for JIRA Server, but will come for JIRA Cloud soon...)

I thoroughly expect JIRA to support Excel Export without having to pay extra. If that is via "Better Excel Plugin" - great! But I don't see why we should pay more because they have removed a feature.

And in 2016, getting something to write Excel files, even on Linux is entirely possible, and indeed rather trivial if one doesn't get too fancy.

This widget could not be displayed.

Hi there,

With 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 Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

220 views 1 3
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