Typeform's live integration goes to Google Sheets, not Excel, and the native event-based route misses responses submitted before you connected.
Typeform's export to Excel is clean and straightforward: open the Results panel, go to Responses, and download as XLSX. You have your data in a flat table in under a minute. The problem is the same one every manual export hits: the next time you need fresh responses you repeat the process, and any analysis you built in the workbook needs to survive the copy-paste. Typeform does have a native Excel Online integration that sends new responses to an OneDrive workbook automatically, but it is forward-only and misses responses submitted before you connected. This guide covers every method, what each one misses, and which ones work in Excel on the web.
Method 1: Results panel export (all plans, any Excel)
From your Typeform Workspace, open the form, click Results, then Responses. To export everything, click the download icon in the upper-right of the table. To export a selection, tick the checkboxes on the rows you want and click the download icon that appears at the bottom. A window opens with options for CSV or XLSX. Pick XLSX for direct Excel use, then click Export.
For large response sets, Typeform prepares the file in the background and emails a download link to your account address. For smaller sets, the file downloads immediately to your device. You can also apply a date filter or a question filter before exporting so only matching responses are included.
The catch: export is only available from a desktop browser. The mobile app does not have the export option. And each export is a frozen snapshot: responses submitted after you clicked Export are not in the file. Yes/No question answers arrive as 1 and 0, which requires a quick recode before sharing the workbook.
Method 2: Typeform's native Excel Online integration
Typeform has a built-in Excel Online integration available in the Connect panel of your form. Click Connect next to Excel to link your Microsoft account, and Typeform will send each new response to an Excel Online workbook stored in OneDrive as it arrives. There is also a native Google Sheets integration that works the same way. Both are available on all plans and require no code to set up.
The catch: both integrations are event-based and forward-only. They capture responses submitted after the integration was enabled, not responses already in your form. Typeform does let you manually push up to 1,000 existing responses to Sheets as a one-time backfill, but the Excel Online integration does not have an equivalent backfill option. The workbook must live in OneDrive; locally saved files and network-drive workbooks are not supported. Automation tools like Zapier and Make can also route Typeform responses to Excel via OneDrive, but they add a monthly cost on top and have the same forward-only limitation.
Method 3: Responses API via Power Query
Typeform's Responses API endpoint is https://api.typeform.com/forms/{formId}/responses. You authenticate with a personal access token from your Typeform account settings. In Excel, use Data, then Get Data, then From Web, add the token as an Authorization header, and use Power Query's M code to expand the nested answers array into columns. The API returns up to 1,000 responses per call and includes a before parameter for pagination through older responses.
The API covers the full response history, not just new submissions, which is the key advantage over the native event-based integration. Multiple Choice questions with multi-select enabled arrive as separate boolean columns per answer option, matching the export behaviour.
The catch: Power Query refresh works in desktop Excel on Windows and Mac, but not in Excel on the web. The answers array in the API response is nested JSON, and parsing it into a flat table requires some M code work. Token expiry is silent: the query returns an auth error and stops refreshing without an obvious notification.
Method 4: Brooked for Excel (scheduled, with backfill)
Brooked for Excel is an add-in that connects to Typeform, imports responses into the worksheet you choose, and keeps them current on a schedule. It includes the full backfill of responses submitted before you connected, which is the gap that the native event-based Google Sheets integration cannot fill. It works in desktop Excel on Windows and Mac, and in Excel on the web, where Power Query refresh is not available.
Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the Typeform connector is fully live, so the response pipeline itself is mature.
Setting up the Typeform connection
Open Brooked in the Excel ribbon, choose Typeform as the source, and sign in with your Typeform account. Pick the form you want, choose whether to import all responses or a date range, and pull them into the active worksheet. Each row is one response, each column is one question, with the question text as the header rather than the field ID.
Brooked AI, TypeformMethod comparison
| Method | Cost | Works on | Refresh | Best for |
|---|---|---|---|---|
| Results panel export | Free, all plans | Any Excel (desktop export only) | Manual re-export | A one-off snapshot of all responses |
| Native Excel Online integration | Free, all plans | Excel Online (OneDrive) only | Live as responses arrive (forward-only) | Teams who want auto-append to an OneDrive workbook |
| Responses API via Power Query | Free (API) + Power Query effort | Windows & Mac desktop Excel | Manual refresh in Power Query | Developers comfortable with M code and pagination |
| Brooked for Excel | Free during beta | Desktop, Mac & web Excel | Scheduled (rolling out in beta) | Ongoing response tracking with backfilled history |
What teams build with Typeform response data in Excel
- NPS tracking over time with rolling 30-day and quarterly trend charts
- Lead qualification scoring where response answers map to a points model in Excel
- Customer satisfaction dashboards segmented by product line or region
- Research data exports that combine multiple Typeform surveys into one analysis workbook
- Onboarding survey tracking to correlate early responses with downstream retention metrics
Troubleshooting common issues
Related Articles
- How to Connect JotForm to Excel
- How to Connect SurveyMonkey to Excel
- How to Connect Typeform to Google Sheets
Frequently asked questions
Can Typeform export to Excel?
Yes. In your Typeform Workspace, open the form, click Results, then Responses. Use the export icon at the top-right of the table or at the bottom after selecting specific rows, and choose XLSX or CSV. For large response sets the file is prepared in the background and Typeform emails you a download link. Note: export is only available from a desktop browser, not the mobile app.
Does Typeform integrate with Excel directly?
Yes. Typeform has a native Excel Online integration available in the Connect panel of your form. It sends each new response to an Excel Online workbook stored in OneDrive as it arrives, with no code required. The limitation is that it is event-based and forward-only: it does not backfill responses that were already in your form before you connected. It also requires OneDrive; it does not write to locally saved files. For historical data or a locally stored workbook, the Responses API or Brooked are the alternatives.
How do I export only some Typeform responses to Excel?
In the Responses tab, tick the individual responses you want using the row checkboxes, then click the export icon at the bottom of the table. Only the selected rows are included. You can also apply a date filter or a question filter first, then export, to get only the matching responses.
Does the Typeform export work the same on Windows, Mac, and Excel on the web?
The downloaded .xlsx file opens the same in Excel on Windows, Mac, and Excel on the web. The difference is in keeping it current: Power Query refresh works in desktop Excel on Windows and Mac, but not in Excel on the web. Brooked's add-in works across all three environments.
Does Typeform's API include responses submitted before I connected?
Yes. The Responses API returns all responses collected on your form, not just new ones after the connection was made. This matters compared to event-based integrations like the Typeform to Google Sheets native integration, which only captures responses submitted after the integration was set up and misses any historical data unless you manually send up to 1,000 existing responses. If you need the full backfill, the API or Brooked are the right paths.
Why do Yes/No questions show as 1 and 0 in my Typeform export?
Typeform encodes Yes/No question answers as 1 for yes and 0 for no in CSV and XLSX exports. This is documented behaviour. If you want plain text, add a helper column in Excel with an IF formula that converts the 1/0 to Yes/No, or recode the values with Find and Replace after importing.
Get Typeform responses into Excel on a schedule, including the full backfill.
Brooked for Excel is in beta and free to try. Using Google Sheets instead? Read the Sheets version of this guide.
See Brooked for Excel →
