Export to excel missing

Hi,

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

Thakns,

3 answers

1 votes

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.

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.

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,981 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot