You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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.)
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
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