Recover Missing Microsoft Forms Responses in an Excel Export
Question details
Recover responses that appear in Microsoft Forms but are missing from an Excel workbook.

- Product
- Microsoft Forms and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A form owner needs to reconcile the Microsoft Forms response summary with a connected or exported Excel workbook.
- Observed behavior
- The Forms summary shows more responses than the workbook, possibly because rows were deleted or the workbook data became inconsistent.
Open the form in Microsoft Forms and note the response count on the Responses tab. Locate the affected workbook in OneDrive or SharePoint and check whether version history is available.
Export the responses again from Microsoft Forms
Use a fresh export to check whether the missing responses are available directly from the form.
Open Microsoft Forms, select the form, and go to the Responses tab. Note the total and use View results to inspect individual responses.
On the Responses tab, select Open in Excel or the available option to download responses. Save the exported workbook as a separate file.
Open the new workbook in Excel and compare its response rows and identifiers with the Forms summary and the existing workbook. Clear any worksheet filters before counting rows.

Inspect an earlier workbook version without overwriting the current file
Use version history to look for rows that were present before the workbook changed.
Ask Microsoft Support or your administrator for recovery help
Use this route when fresh exports and available workbook versions do not contain the missing responses.
Review Forms exports with WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel exports in WPS Spreadsheet to review and compare response data; it does not recover missing data from Microsoft Forms.

Frequently Asked Questions
Why does Forms show more responses than my Excel workbook?
Workbook rows may have been deleted, filtered, or become inconsistent with the form data. Check for filters in Excel, then compare a fresh export from the Forms Responses tab with the existing workbook.
Will exporting from Forms again always recover the missing responses?
No. Select Open in Excel or the available download option on the Responses tab to create a fresh export, but some missing responses may still be absent. If that happens, check workbook version history and seek Microsoft recovery guidance.
Can I check an older workbook without losing recent data?
Yes. Open Version History from Excel or the file's OneDrive or SharePoint menu, inspect an earlier version, and download or save it as a separate copy instead of restoring it over the current workbook.
What should I do if neither the export nor version history has the missing responses?
Contact your Microsoft 365 administrator or Microsoft Support. Provide the form name, the response count shown in Forms, the export count, and the versions you have already checked.




