Export All Survey Responses From Formbricks Into a Excel workbook

The Scenario

The quarterly business review is in three days. Your product manager sent you a Formbricks survey ID and a note: "We collected 1,400 NPS responses last quarter — can you pull them all into a workbook for the QBR deck?"

You open the Formbricks dashboard. You find the survey. You look at the export options.

The bad version:

• Download the full CSV export — 1,400 rows, 22 columns, half of which are metadata you don't need
• Open it in Excel, delete the irrelevant columns, rename the headers to match the deck template, and fix the date format because the export uses UTC milliseconds
• Realize the comment column has newlines inside cells, which broke the import, and manually clean 40 rows where it happened

Three days before a QBR, this is not where your time belongs. The slide still isn't built. The data is finally in the workbook, but you've spent 90 minutes just getting there.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands the structure, and through its built-in Formbricks integration it can pull survey responses directly — no CSV download, no reformatting. You tell it what you need.

Fetch all responses for the Formbricks survey ID in cell A1 and populate this sheet with respondent email, NPS score, comment text, and submission date — one response per row

What You Get

• Column A: respondent email
• Column B: NPS score (0–10 integer)
• Column C: comment text (newlines cleaned to spaces automatically)
• Column D: submission date in your workbook's locale format
• One row per response, starting from row 2, with a header row written in row 1
• If any responses are missing the comment field, the cell is left blank rather than erroring

What If the Data Is Not Quite Ready

The survey ID is buried in another worksheet

Your workflow has the survey IDs in a reference worksheet called "Survey Registry" rather than pasted into A1 of the output sheet.

Read the survey ID from cell B3 in the "Survey Registry" worksheet and fetch all Formbricks responses — write respondent email, NPS score, comment text, and submission date into this sheet starting at row 2

You only want responses above or below a score threshold

Leadership wants to see only the detractors — scores of 6 or below — for the QBR discussion.

Fetch all responses for the Formbricks survey ID in cell A1, filter to only responses where the NPS score is 6 or below, and write respondent email, score, comment, and submission date into this sheet

You need responses across three different surveys combined

The NPS program runs three separate surveys — one per product line — and the QBR deck needs all of them in one sheet.

Fetch all Formbricks responses for each survey ID in column A (rows 2 through 4), combine them into a single list in this sheet, add a "Survey Name" column from column B of the same row, and sort by submission date descending

Clean the data, score the promoters, and write the summary in one shot

Fetch all responses for the Formbricks survey ID in cell A1, remove any rows where the comment text is blank, add a "Segment" column that says "Promoter" for scores 9–10, "Passive" for 7–8, and "Detractor" for 0–6, and write the full result into this sheet with totals for each segment at the bottom

The pattern: you don't have to prepare the data first and then ask a separate question about it. You ask for the cleanup and the analysis together.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook with a Formbricks survey ID in a cell — then ask it to pull the responses. The Formbricks integration is included in every SheetXAI plan. If you're also uploading contacts for targeting, see the bulk upload contacts spoke, or start with the Formbricks overview for all integration options.