The Scenario
A customer success manager needs to export all 300 NPS survey responses from last quarter — respondent distinct_id, score, and comment text — into an Excel workbook so she can segment promoters, passives, and detractors and hand the detractor list to the CSM team for follow-up calls. PostHog shows 300 responses. The UI lets you view them one at a time. There is no export button. Her manager asked for this workbook by end of day.
The bad version:
- Scroll through 300 NPS survey responses in PostHog's UI one at a time, manually copy distinct_id, score, and comment text into a workbook row for each
- Reach response 140 and realize PostHog truncates long comments in the list view — you've been copying incomplete feedback for responses longer than 80 characters
- Finish the export after two and a half hours, hand it to the CSM team, get a message that the detractor segment has only 40 rows when there should be closer to 60 — some responses were missed during manual transcription
Three hundred responses, manually transcribed, end-of-day deadline. A workbook that takes two and a half hours to build still has errors.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads PostHog's survey responses endpoint and writes every response — with full comment text — into a worksheet in one operation.
Export all responses to PostHog survey ID survey_xyz and write respondent distinct_id, submission date, NPS score, and comment text into columns A through D of the 'NPS Responses' worksheet.
What You Get
- All 300 responses appear as rows — distinct_id, submission date, score, and full comment text
- No comment truncation — the API returns the full text even when the UI clips it
- The workbook is immediately ready for segmentation by score range
What If the Data Is Not Quite Ready
You want automatic segment labels
Export all responses to PostHog survey ID survey_xyz and write distinct_id, submission date, NPS score, and comment text into columns A through D. In column E, write 'Promoter' for scores 9-10, 'Passive' for 7-8, and 'Detractor' for 0-6.
You only want last quarter's responses
Export PostHog survey responses for survey ID survey_xyz where submission date is between 2026-01-01 and 2026-03-31. Write distinct_id, submission date, score, and comment into columns A through D of the 'Q1 NPS' worksheet.
Cross-reference respondents with plan tier
Export PostHog survey responses for survey ID survey_xyz into columns A (distinct_id), B (score), C (comment). Join against the 'Users' worksheet (distinct_id in column A, plan tier in column B) and write each respondent's plan tier into column D. Write 'Unknown' for respondents not found.
Full NPS export with segmentation and CSM action list
Export all responses to PostHog survey survey_xyz. Write distinct_id, submission date, score, comment text, and NPS segment into columns A through E of the 'NPS Export' worksheet. Then create a second worksheet named 'Detractors' containing only Detractor rows, sorted by submission date descending. Add column F in 'Detractors' with the text 'Needs follow-up call'.
One prompt builds both the full export and the CSM action list.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, ask it to pull your PostHog NPS survey responses, and have the segmented list ready for the CSM team before their standup. Also see: Export PostHog Event Definitions Into an Excel workbook for Governance and the PostHog hub.