What are Jira Comments?

Jira comments are a type of data within the Jira platform that allows users to add simple text updates, code snippets, images, and tables to issues. These comments can be utilized to share detailed information, provide updates, and collaborate with teammates by mentioning them using the @ symbol. Additionally, Jira comments can be enhanced with emoji reactions for quick feedback.

In Jira Software, comments can be tailored for specific audiences through comment permissions. This functionality enables comments to be restricted to certain project roles, making them visible only to members of the development team, for example, and not visible to clients. These restrictions can be managed through the General Configuration settings and apply to all projects within the company's Jira instance.

Jira Service Management expands the utility of comments by integrating forms for additional information gathering and automating customer support with a virtual agent. Comments in the Jira Service Management can be added to multiple requests simultaneously from the issue view. However, it is important to note that comments within Jira Service Management cannot be shared with customers and only Jira administrators have the authority to grant comment permissions on service project issues.

Exporting Jira Comments to a CSV File

Using Issue History for Jira

To export comments along with their history, users can utilize the 'Issue History for Jira' functionality. This feature allows the extraction of comments and their corresponding history directly into a CSV file format. By following the appropriate options within the Issue History plugin, users can generate a comprehensive CSV document containing the desired comment data.

Using Better Excel Exporter

For those looking to export their Jira comments to an Excel file and then convert it into CSV format, the 'Better Excel Exporter' app can be employed. This tool facilitates the exportation of Jira comments into an Excel file, which can subsequently be saved as a CSV file through the standard 'Save As' functionality within Excel, allowing for easy manipulation and use of the comment data outside of Jira.

Using the 'Export CSV (all fields)' Option

Jira Cloud offers a straightforward method to export all comments to a CSV file via the 'Export CSV (all fields)' option. This built-in feature will enable users to include all comments within the exported CSV file, ensuring a complete dataset is available for reporting, analysis, or other purposes that require the use of standard spreadsheet tools.

Converting to XML and Using ChatGPT

Users also have the option to convert their Jira issue data, including comments, to an XML format. Once in XML, the data can be processed using ChatGPT or similar tools to convert into a structured CSV table. This method may be beneficial for those who require further customization or transformation of the comment data before finalizing it in the CSV format.

Streamline Your Workflow with Sourcetable for Jira Comment Integration

For professionals seeking a seamless way to incorporate Jira comments directly into their spreadsheets without the hassle of traditional exporting and importing methods, Sourcetable offers a revolutionary solution. By syncing your live data from nearly any application or database, including Jira, Sourcetable simplifies the process of managing your workflow. The platform's capability to automatically pull in data from multiple sources into a cohesive spreadsheet interface is not only a time-saver but also enhances the accuracy of your data management.

Using Sourcetable for Jira comments integration allows you to bypass the cumbersome steps of exporting comments to a CSV file and then importing them into another spreadsheet program. This direct integration significantly reduces the risk of data loss or errors that often occur during data transfer. Moreover, Sourcetable's intuitive design, mirroring the familiar spreadsheet environment, permits users to query and manipulate their live data effortlessly. This is a game-changer for those who rely on real-time data for automation and business intelligence, providing them with up-to-date insights for better decision-making.

Common Use Cases

• J

  
  Easing Jira migrations
• J

  
  Enhancing issue reporting outside Jira
• J

  
  Auditing SLAs

Frequently Asked Questions

How can I export Jira comments to a CSV file?

To export Jira comments to a CSV file, use Issue History for Jira to export them to CSV or Excel. Add the Comments field to the grid in Issue History for Jira and click the Export button. Alternatively, you can use the Export Excel CSV (All fields) option which will include all issue fields, including comments in the CSV file.

Can I export Jira comments to Excel?

Yes, you can export Jira comments to Excel by using the Better Excel Exporter, which allows you to export to a native Excel spreadsheet. This method is more readable than CSV and can include internal JSM comments if desired.

Will the exported CSV file include all the comments?

Yes, when you export all fields to a CSV in Jira, each comment will be included in a different 'Comment' column in chronological order.

How do I ensure that comments are included when exporting issues to CSV in Jira?

When using JQL to export issues to CSV, make sure to include comments in your search criteria. The resulting export will contain comments along with other issue fields.

Why can't I find the feature to export to CSV in Jira Cloud?

The feature to export to CSV in Jira Cloud may be temporarily missing or moved to a different menu location. It is not known if the Cloud version updated to remove this feature, but it was available last week.