JIRA Tickets Export to Excel.

[Kenady]

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

[Levente Szabo _Midori_]

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.

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!

[Prince Nyeche]

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.

[Mohamed Benziane]

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)