Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to export all data from comments field to excel file in jira

Lisa New August 24, 2024

How to export all the data from comments field to excel file using jira.

2 answers

3 votes
Lisa Forstberg
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 24, 2024

Hi @Lisa New ,

Welcome to the community.

Create a filter for the issues you would like to export

Click on the Export issues > Export Excel  CSV (all fields)

Screenshot 2024-08-24 at 17.46.58.png

That would give you to a lot of empty columns but it will also give you every single comment as a column with timestamp and userID.

Like this:

Screenshot 2024-08-24 at 17.48.53.png

Best of luck

/Lisa

0 votes
Aron Gombas _Midori_
Community Champion
August 26, 2024

@Lisa New (I saw you posted this question for the DC, too, but this one is for the Cloud.)

You can use the Better Excel Exporter app to export comments along with other issue fields to a spreadsheet like this:

jira-issues-selected-fields-with-comments.png

As you see, comment author, time and text appear in separate columns having the correct data type.

(Discl. this paid and supported app is developed by our team. Free for 10 users!)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events