How to generate a report and export in excel sheet?

 

4 answers

This widget could not be displayed.

If CSV doesn't work for you, use the Better Excel Plugin to export search results to XLSX files.

Samples: http://www.midori-global.com/products/jira-better-excel-plugin/template-gallery

This widget could not be displayed.

Search for the issues you want in it, then use "export to CSV" in the navigator options.  Excel can read CSV files.

This widget could not be displayed.

Open an existing filter from a dashboard or navigate to the search page. Select the projects and issues that you want to filter. In the top right you will see a drop down option for "Export". Click on that and select the export type. You can export in excel or as CSV in two ways;

  • using current fields (those visible in the filter display) which can be modified by clicking on "Columns" just underneath the export button and selecting the fields that you want to display for each item.
  • or you can export with all fields which will produce an excel file containing the data from all fields in each selected issue's screen.

Hope this helps.

This widget could not be displayed.

We need a visual step by step with pictures or a video. The words above are almost meaningless. The sentence ' using current fields (those visible in the filter display) which can be modified by clicking on "Columns" just underneath the export button and selecting the fields that you want to display for each item".... Is so cryptic it may as well be written in cuneiform .   The word "Columns" is not present on the interface. The current fields refers to a space on the page somewhere, however the location of that space is dependant on prior knowledge that associates the title 'current fields' with that space. This is because the words 'current fields' does not appear anywhere in the interface.  

Hi Richard,

Thank you for your condescending, ill observed and boneheaded response. Frankly I feel disinclined to help any further but an Atlassian community troll is such a rare and gloriously moronic thing I'll suit up and dive into this choking sea of moldy crap.

Assuming that you were able to decipher my crude and incoherent rock scratchings of the first sentence and made it as far as the search page you would see the following;

 Filter Columns display fields.jpg

Then by clicking on "Export" you will see the elusive and definitely non-existent "Current fields" option.
Export Current Fields.jpg
Hope this helps!

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...

217 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