The Scenario
Your NPS survey has been running on CabinPanda for six months. Six hundred responses. Your customer success lead asked for the score and a breakdown of low-responder comments three days ago. The responses are sitting in CabinPanda — not in a workbook, not scored, not cleaned. The comments field pulled in some HTML formatting from the embed. You know the score matters to a director-level conversation happening this week, and you haven't started yet.
The bad version:
- Export six hundred rows as a CSV, open it in Excel, discover that the comment field contains raw HTML like
<p>and<br />inline with the text. - Write a formula to strip the HTML tags, drag it down 600 rows, then copy-paste the cleaned values over themselves to drop the formula dependency.
- Manually write the NPS calculation: COUNTIF for scores 9–10, COUNTIF for 0–6, do the arithmetic.
- Conditionally format the rows. Spend twenty minutes getting the red and green thresholds right.
This is a scorecard someone will present to leadership. Arriving with a workbook you built at midnight is a different kind of professional embarrassment than arriving late.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook, connects to CabinPanda directly, fetches the survey submissions, strips the HTML, scores the responses, and formats the rows — in a single prompt.
Pull all satisfaction survey responses from CabinPanda into this sheet, calculate the average score in cell E1, and colour rows red where score is below 6 and green where score is 9 or 10
What You Get
- Respondent email in column A, numeric score in column B, clean comment text in column C — HTML stripped.
- Average score calculated in E1.
- Rows with a score of 0–6 highlighted red, rows with 9–10 highlighted green.
- Row count in a nearby cell so you can confirm no submissions were dropped.
What If the Data Is Not Quite Ready
The score field came in as text, not a number — convert before scoring
Pull all NPS survey submissions from CabinPanda into this workbook, convert the score column to numeric values, then calculate the NPS score in E1 and flag rows where the score column is not a valid integer
You only want to analyze responses from the last 90 days
Fetch CabinPanda NPS submissions submitted after March 1 2026, write them into Sheet1 columns A through C with HTML stripped from comments, and calculate the average score in E1
The form has multiple question fields beyond the score — extract only the ones you need
Pull all CabinPanda NPS survey submissions and write to columns A through D: respondent email, NPS score, the answer to the 'What could we improve?' question, and submission date — ignore all other fields
Clean the comments, calculate the score, segment by product tier, and flag promoters who haven't renewed
Fetch all CabinPanda NPS responses, strip HTML from the comment field, calculate the NPS in E1, then cross-reference emails against the Renewals worksheet — mark rows where the respondent is a promoter (score 9–10) but does not appear in Renewals as 'Upsell Candidate' in column E
The pattern: the fetch, the cleaning, the scoring, and the cross-reference can all live in a single prompt — you don't need to checkpoint between steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your NPS analysis needs to live, then ask SheetXAI to pull the submissions, strip the HTML, and calculate your score in one go. You might also want to explore how to audit your full CabinPanda form inventory or return to the CabinPanda integration overview.