The Scenario
The Monday leadership standup is at 8 AM. The CTO wants a single Excel view of every P1 and P2 issue currently open across WEB, API, MOBILE, and INFRA — with assignee, status, and age — sitting in his inbox when he wakes up. The request arrived Friday at 4:30 PM. The data is in four separate Jira projects.
The bad version:
- Open Jira, run a JQL filter for P1/P2 issues in WEB. Export as CSV.
- Open the CSV in Excel. Rename the columns. Delete the eight you don't need.
- Run the same filter for API, paste below the WEB data. Align the column order.
- Repeat for MOBILE and INFRA.
- Manually add a days-open column by subtracting the created date from today across 80 rows.
Four exports, four reformatting passes, one manual formula column. You send it by 7 PM Friday. The CTO will want fresh data by Monday 8 AM — and you'll do the whole thing again next week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the workbook and through the Jira integration queries all four projects simultaneously and assembles the combined output.
Fetch all critical and high priority open Jira issues across all projects and paste them into my Excel sheet with columns: key, project, summary, assignee, priority, status, created date.
What You Get
- One row per qualifying issue across all four projects.
- Issue key, project key, summary, assignee, priority, status, and created date in separate columns.
- No reformatting needed — the layout matches the column labels you specified.
- Unassigned issues show 'Unassigned' rather than a blank in the assignee column.
What If the Data Is Not Quite Ready
You want days-open calculated automatically rather than a created date
The CTO's standup uses days-open, not the raw created timestamp.
Search Jira for all open issues with priority P1 or P2 across projects WEB, API, MOBILE, and INFRA. Write the issue key, summary, project, assignee, priority, status, and days open into my Executive Report sheet.
Issues should be sorted by days open descending so the stalest ones appear first
The CTO wants to see what has been sitting longest at the top of the list.
Search Jira for all open P1 and P2 issues across projects WEB, API, MOBILE, and INFRA. Write the issue key, summary, project, assignee, priority, status, and days open into my workbook, sorted by days open descending.
You want a per-project summary above the issue list
The standup opens with a quick count per project before diving into individual tickets.
Search Jira for all open P1 and P2 issues across projects WEB, API, MOBILE, and INFRA. First, write a summary block at the top of my workbook: one row per project with the project key and total open P1 plus P2 count. Then write the full issue list below with columns: key, summary, project, assignee, priority, status, days open.
Kill chain: fetch issues, flag unassigned P1s, sort by severity and age, add project subtotals
Search Jira for all open issues with priority P1 or P2 across projects WEB, API, MOBILE, and INFRA. Write issue key, summary, project, assignee, priority, status, and days open into my Executive Report sheet. Flag any unassigned P1 issue with 'Escalate' in a separate column. Sort by priority (P1 first) then by days open descending within each priority group. Below the issue list, add a subtotal block with one row per project showing its P1 and P2 open counts.
One prompt pulls the combined view, sorts it, adds escalation flags, and appends the subtotals — the workbook is ready to land in the CTO's inbox before you close your laptop Friday.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before the next leadership sync, then ask it to pull all critical open issues across your Jira projects into a single sorted view. See also: how to export team workload by assignee and how to export open bugs for triage.