How to Export Microsoft Forms to Excel (2026)
Microsoft Forms exports every response to Excel with one click, giving you a clean table — one row per submission, one column per question. From there you can sort, filter, pivot, and chart the data far beyond what the Forms summary shows.
1. Open the Responses Tab
- Open your form at forms.office.com.
- Switch from Questions to Responses at the top.
2. Export to Excel
- Click Open in Excel (in some versions Open results in Excel or the Excel icon).
- A
.xlsxfile downloads, or opens directly in Excel for the web. - The workbook includes columns for the response ID, start/completion time, respondent name or email (if recorded), and each question’s answer.
3. Get a Live, Refreshing Copy
A plain export is a snapshot. For a workbook that updates as new responses arrive:
- On the Responses tab, choose Open results in Excel when the form is connected to Excel for the web / OneDrive.
- Forms stores the workbook in your OneDrive and keeps it in sync, so reopening it shows the latest responses without re-exporting.
If you only see a one-time download, that account or form isn’t set up for the live workbook — re-export to refresh.
4. Clean Up and Analyze
- Use Data > Filter to focus on subsets, or Sort to order by time or score.
- Insert a PivotTable (Insert > PivotTable) to summarize Choice answers.
- Add a chart with Insert > Recommended Charts for a quick visual.
5. Troubleshooting
”Open in Excel” does nothing
A browser pop-up or download block may be stopping the file. Allow downloads/pop-ups for forms.office.com, or try a different browser.
The export is missing recent responses
A downloaded file is a snapshot. Re-run Open in Excel to capture new responses, or use the OneDrive workbook that refreshes automatically.
Names or emails are blank
The form is anonymous (Anyone can respond). To capture identity, restrict it to people in my organization with Record name on, then re-export.
Columns are jumbled or split oddly
Long text or commas in answers can shift cells in some viewers. Open the file in the Excel desktop app rather than a basic CSV preview.
Related Microsoft Forms guides: How to see responses · How to use Microsoft Forms · How to create a survey · How to share Microsoft Forms · How to make Microsoft Forms anonymous
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
