Extracting Comments into a spreadsheet

Ashley Roberts February 25, 2025

We are using Jira 8.20 and we have a request to extract comments from tickets that are past their due dates. When we do an extract all fields, there is a column for comments, but it is blank.

The system does not have an add-on that we can use (as it is very expensive with the number of users we have).

Please can someone help in getting the comments exported?

The filter that we use is the following:

project = PROJECTID AND resolution is EMPTY AND duedate <= startOfDay(7d)

2 answers

1 accepted

0 votes
Answer accepted
Hannes Obweger - JXL for Jira
Atlassian Partner
February 27, 2025

Hi @Ashley Roberts

as already suggested, you should be able to include comments using the All Fields option. The downside is - if I remember correctly! - that this will create one column per comment, which might not quite be what you are after.

As an alternative, there's a number of apps available on the Atlassian Marketplace that provide better comment-exporting capabilities. E.g., you may want to have a look at the app that my team and I are working on: JXL for Jira

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including all comments (along with many other comment-related columns).

With the all comments column, you can easily view, sort, and filter by the latest comment directly in JXL, and get all comments into an Excel/Sheets export in just one click:

comments-all.gif

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

As noted before, there'll be other Marketplace apps that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever.

Any questions just let me know,

Best,

Hannes

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 26, 2025

Hi,

you can try to export your issues using the csv export option (all fields).

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events