How can I export comments in the issues?

[Sofia Grunspan]

When I do my reports, I export the issues in XLSX format (Excel spreadsheet) but I've been asked to export the comments too, there is a way to do this? 

My environment is Cloud. 

Thanks 

[Yuliia_Borivets__SaaSJet_ · Accepted solution]

Hi @Sofia Grunspan 

You can export comments and their history with Issue History for Jira to CSV or Excel. Just add the Comments field to the grid and click on the Export button.

The app is developed by my team, let me know if you have any questions.

[Levente Szabo _Midori_ · Accepted solution]

@Sofia Grunspan If you are looking to export to a native Excel spreadsheet and not CSV, you follow this guide on how to export Jira comments to Excel with Better Excel Exporter.

As others already mentioned, comment is not a field you can add to Issue Navigator to export using built-in Export features. CSV is one solution but it's usually not the well-readable, expected format for end-users.

Browse some real-life examples. You can even decide if you want to include internal JSM comments or not:

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

[Hamza Chundrigar · Accepted solution]

Hi @Sofia Grunspan 

1. Configure a JQL query returning the issues you would like to export.
2. Once you create and run your JQL query, click on the "Export" button at the top-right corner of the search page where you created your query and select the option "Export Excel CSV (All fields)":

The exported CSV file will properly contain all your issue fields, including each comment made. Each comment will be mapped in a different "Comment" column in chronological order.

This is confirmed by Atlassian: source

Best regards,

Hamza

[Joseph Chung Yin · Accepted solution]

@Sofia Grunspan -

Hi Sofia:

You will need to use the option of Export CSV (all fields).  Once you open the CSV in Excel, you will find multiple columns for "Comments".  Example - My issue has two comments, and the CSV file contains the following -

NOTE - In the JQL result via the Search UI, you cannot add the COMMENTS column in the display.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[chengran327]

You can always convert to xml and use chatgpt to help you digest and convert it to formal csv table.