The Scenario
A talent acquisition director at a 200-person company is building a hiring dashboard for the board. The ask: a single Excel sheet with open job offers as columns and pipeline stages as rows, showing how many candidates are in each cell. Not 18 separate job pages. Not a CSV that needs pivot-tabled. A matrix, ready to drop into the slide deck.
Recruitee has all of this data. The problem is that it lives in individual job views, one at a time. There is no built-in cross-job matrix export.
The bad version:
- Open job 1, read the stage counts, type them into the matrix manually.
- Open job 2, repeat.
- Finish all 18 jobs, realize the column headers need to be truncated so the table fits on the slide, and reformat by hand.
This is not a data problem. All the data is there. It's an extraction-and-arrangement problem — and doing it manually means someone spent an hour transcribing numbers from a browser into cells.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook and connects to Recruitee natively. It can pull all open job offers, fetch the stage-level candidate counts for each, and build the cross-tab matrix directly in the workbook — stages as rows, jobs as columns.
Get all open Recruitee job offers, fetch the pipeline stages and candidate counts for each, and build a cross-tab matrix in my sheet with job titles as columns and pipeline stages as rows — write candidate counts in each cell
What You Get
- A matrix written into the workbook with job titles as column headers and pipeline stage names as row labels.
- Each cell contains the candidate count for that job-stage combination, 0 where there are none.
- All open jobs included, not just the ones you can see on screen.
- A table the board deck can pull from directly.
What If the Data Is Not Quite Ready
You want to filter to only certain departments before building the matrix
Get all open Recruitee job offers in the Engineering and Product departments, fetch pipeline stages and candidate counts for each, and build a cross-tab matrix in my sheet with job titles as columns and stages as rows
Job titles are too long for column headers — truncate them
Pull all open Recruitee job offers with pipeline stage candidate counts and build a matrix with job titles as columns and stages as rows — truncate any job title longer than 20 characters to the first 20 characters followed by an ellipsis
You need the matrix plus a totals row and column
Build a cross-tab matrix in my sheet with Recruitee job titles as columns and pipeline stages as rows, candidate counts per cell, a Totals row at the bottom summing each job column, and a Totals column on the right summing each stage row
Full board-ready table: matrix, totals, and a summary stat block
Pull all open Recruitee job offers with stage-level candidate counts; build a matrix in Sheet1 with job titles as columns and stages as rows including totals; then in Sheet2 write a summary block with total open roles, total candidates across all roles, the role with the most candidates, and the stage with the most candidates across all jobs
Pull the matrix and the summary in one prompt — no need to build the matrix first and then calculate the stats separately.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, then ask it to build a pipeline stage matrix from your Recruitee data. You can also pull a simpler hiring pipeline snapshot for a single-table overview or export all candidates at a specific stage.