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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Agree with @Joseph Chung Yin ! doing an export of all fields is how I add comments to my csv file when doing export from Jira.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have many custom fields and its pushes data to extreme right, also it converts all authors name to account ID.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can always convert to xml and use chatgpt to help you digest and convert it to formal csv table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.