Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,363,600
Community Members
 
Community Events
168
Community Groups

JIRA Tickets Export to Excel.

Kenady I'm New Here Sep 11, 2022

How to automatically show the latest added Comment in JIRA extract when using Export->Excel(All fields)?

 

The Comment field in the extract comes blanks unless manually edited each ticket and copy/paste the Comment..

3 answers

You can export the latest comment to Excel with the calculated fields feature of Better Excel Exporter.

Here is a tutorial video of how to do that.

jira-issues-with-built-in-calculated-fields.png

Find more detailed documentation on how to use calculated fields in Better Excel Exporter.

If you get stuck anywhere or have questions, reach out to our support, we are ready to help!

0 votes

If you're familiar with a little python, you can follow this article I wrote and get export in CSV all fields into a single file. It should work with username and password on Jira server.

0 votes

Hello,

It seems that the excel report doesn't include the comment field. The only one export that allow you to export all the comment is the CSV export, but you will have all the comment of the issues.

So you have several option, create a field and a script that will copy the last comment into that field and export it or create a macro in that will retrieve the last comment (not sure if it's possible, i'm not a vba expert)

Suggest an answer

Log in or Sign up to answer