Have to export all data from comments field to excel file in jira server

[Lisa New]

How to export all data from comments field to excel file. 

any possibility through api?

[Dave Mathijs]

Hi @Lisa New please have a look at this KB article: How to export issue and comment in CSV with proper format to import in Jira

[Aron Gombas _Midori_]

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

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

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!)