Easy Tech TutsHow to Save Your Responses in Microsoft Forms Easily 2026
By Impran M N
Once a survey or quiz has run its course, you'll usually need a permanent local copy of the results rather than relying on the live dashboard. This guide covers exporting response data to Excel, saving individual submissions as PDFs, and understanding how group forms sync automatically.
01Open the Responses tab
Switch from your form editor into the Responses tab to see your collected data.
02Export to Excel
Click Open in Excel to trigger a background compile, which your browser then downloads as a structured spreadsheet.
03Save an individual PDF transcript
Click Review Answers to inspect a specific submission, then use the three-dot menu and select Print response, choosing Save as PDF.
04Check cloud sync for group forms
If your form belongs to a group, use Sync all responses to cloud to keep a live spreadsheet updated in SharePoint or Teams.
05Verify your data
Confirm your exported Excel file aligns every question title with its corresponding data column correctly.
Frequently asked questions
Can I save just one respondent's answers instead of the whole set?
Yes, opening an individual response and using Print response with Save as PDF creates a standalone transcript.
Does the Excel export update automatically as new responses come in?
For group-owned forms, syncing to the cloud keeps a live spreadsheet updated, while a manual Excel export is a one-time snapshot.
Where does the exported Excel file save to?
Your browser downloads it directly to your local drive when you click Open in Excel.
Will my question titles match the spreadsheet columns?
Yes, each question title should align with its corresponding data column in the exported file.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
