Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,687
Community Members
 
Community Events
165
Community Groups

Is there a way to export comments in multiple JIRA issues into an excel sheet?

I'm trying to export every field from JIRA to migrate it to another system, but having trouble finding a way to export comments.

5 answers

1 accepted

Hello, 

For everyone who gets on this thread, the steps below provide the correct instructions to properly export all the fields (together with the comments) from a specific set of issues on your Jira Cloud site in the CSV format:

  1. Configure a JQL query returning the issues you would like to export. You can follow the instructions of the documentation below to know where/how to create the query you need:
    Use advanced search with Jira Query Language (JQL) 
  2. Once you create and run your JQL query, click on the "Export" button at the top-right corner of the search page where you created your query and select the option "Export Excel CSV (All fields)":
    Screen Shot 2022-03-31 at 12.26.05.png

Following the steps above, 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.

Thanks!

When exporting to a CSV, if you select 'Export Excel CSV (all fields)', it includes the comments. Steps

  1. Navigate to advanced search and query for target issues
  2. Select Export
  3. Choose 'Export Excel CSV (all fields)'

Hi Ravi,

Our Excel Online Integration add-on can export comments to the Cloud version of Excel:

https://marketplace.atlassian.com/apps/1220350/excel-online-integration?hosting=cloud&tab=overview

I'm sure there are others. Hope that helps.

 

Best regards,

- The Mobility Team

@MobilityStream We have on premise JIRA

Hey @Ravi Gupta and All,

Better Excel Exporter also exports Jira comments as well as other non-regular Jira data (like issue history, worklog, other meta data) into custom Excel spreadsheets. Better Excel  Exporter is an established (on the Marketplace for 8 years!) and professional Excel exporting and reporting solution for Jira Server, DC (and coming soon for Jira Cloud).

Check out Excel export samples and the documentation and let me know if you have questions!

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

Hi,

You need to go to a Filters or Advanced search for it to work. Doing it from Issues will not export the comments. It seems like a bug.

0 votes
Joe Pitt Community Leader Aug 19, 2021

Comments don't export in Excel. There may be a plug-in that will do it. I was told long ago (2007-8) that it is because all the comments for an issue are stored in one entry in the database and the UI handles making them readable so exporting them to a csv/excel file would make the unreadable 

@Joe Pitt Could you please share plug-in name?

Joe Pitt Community Leader Aug 19, 2021

I just said there MAY be a plugin. I'm not aware of one. You need to search the marketplace. 

When exporting to a CSV, if you select 'Export Excel CSV (all fields)', it includes the comments

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you