The Scenario
A client services handoff is happening Friday. The account lead needs to pull every comment from 20 support ticket keys — already listed in an Excel workbook — and format them into a clean communication log to send to the incoming team. The keys are in column A. What she doesn't have is a way to get the comment threads out of Jira without opening each ticket.
The bad version:
- Open Jira, navigate to the first issue key, click into the comment section.
- Read through the thread, copy each comment, paste into a new Excel worksheet.
- Navigate to the second ticket. Repeat.
- Realize at ticket 9 that the client wants all comments in chronological order across all tickets, not grouped by ticket, so the layout you've been building is wrong.
Twenty tickets with four comments each is eighty comment entries to move by hand. The handoff doc has three other sections that actually require writing, and the deadline is Friday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the Tickets worksheet and through the Jira integration fetches every comment from every listed issue in one operation.
Export all comments from the Jira issues in column A and paste them into my Excel sheet with columns: issue key, commenter, date, and comment text.
What You Get
- One row per comment across all listed issues.
- Issue key, commenter name, comment date, and comment body in separate columns.
- Comments appear in the order Jira returns them — oldest first within each issue.
- Issues with no comments produce no rows, keeping the output clean.
What If the Data Is Not Quite Ready
You only need comments posted after a specific date
The client's new team only needs context from the last two months, not the full ticket history.
For each issue key in column A of my Tickets sheet, fetch all Jira comments posted on or after March 1, 2025. Write the issue key, commenter name, date, and comment text into a new worksheet called Comments.
The comment bodies contain internal markup and mentions that look messy in Excel
Jira comment formatting includes @mention syntax and bold/italic markup that doesn't render in Excel.
For each issue key in column A, fetch all Jira comments. Strip @mention syntax and formatting markup from the comment body before writing issue key, commenter name, date, and cleaned comment into a new worksheet.
You want a comment count per ticket written back to the Tickets worksheet
The account lead wants to see at a glance which tickets had the most back-and-forth.
For each issue key in column A of my Tickets sheet, fetch all Jira comments. Write issue key, commenter name, date, and comment body into a new worksheet called Comments. Also write the total comment count for each issue back into column B of the Tickets sheet.
Kill chain: filter internal comments, remove duplicates, format, and export
For each issue key in column A of my Tickets sheet, fetch all Jira comments. Remove any comment from an author whose email ends in @ourcompany.com. Remove any duplicate comment body text. Strip formatting markup. Write the remaining comments into a new worksheet called Client Comments with column headers in row 1: Issue Key, Commenter, Date, Comment.
Internal filtering, deduplication, and cleanup in one pass means the client-facing output goes directly from SheetXAI to the handoff doc without a manual review step.
Try It
Get the 7-day free trial of SheetXAI and open your client account Excel workbook with Jira issue keys in column A, then ask it to pull every comment thread into a formatted worksheet ready for the handoff team. See also: how to post batch comments to Jira issues and how to export open bugs for triage.