Sourcetable Integration

Export Jira comments to CSV

Jump to


    Mastering the art of exporting Jira comments to a CSV file can unlock a new level of productivity and analysis for project managers and teams. Delving into the detailed feedback and insights hidden within comments, when moved to a spreadsheet, allows for in-depth auditing of Jira information, analysis of SLA compliance, and generating comprehensive reports for both internal and external review. This page serves as a comprehensive guide on the 'what', 'how', and 'why' of exporting Jira comments to CSV. We'll explore the practical steps to perform the export, discuss use cases that can transform your project management, introduce an innovative alternative to CSV exports using Sourcetable, and answer your most pressing questions about the process.

    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.

    Sourcetable Integration

    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
      Sourcetable Integration
      Easing Jira migrations
    • J
      Sourcetable Integration
      Enhancing issue reporting outside Jira
    • J
      Sourcetable Integration
      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.


    Exporting Jira comments to CSV is straightforward whether you use Issue History for Jira or the Better Excel Exporter. You can either add the Comments field to the grid and click the export button or use the "Export Excel CSV (All fields)" option after running a JQL search. Remember that when using Jira Cloud, you may encounter a limit of 1,000 issues for the export, but this is easily circumvented by modifying your search or exploring different menu locations. If exporting to CSV seems cumbersome, consider using Sourcetable to import your Jira data directly into a spreadsheet, streamlining your workflow. Sign up for Sourcetable today and enhance your data management experience.

    Start working with Live Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.