Data Import & Export

Recover Missing Microsoft Forms Responses in an Excel Export

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

Recover responses that appear in Microsoft Forms but are missing from an Excel workbook.

Recover Missing Microsoft Forms Responses in an Excel Export
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.
Before you start

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.

Solution 1Recommended

Export the responses again from Microsoft Forms

Use a fresh export to check whether the missing responses are available directly from the form.

1
Review the form responses

Open Microsoft Forms, select the form, and go to the Responses tab. Note the total and use View results to inspect individual responses.

2
Export to Excel

On the Responses tab, select Open in Excel or the available option to download responses. Save the exported workbook as a separate file.

3
Compare the data

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.

Export the responses again from Microsoft Forms
If the export is still incomplete: A fresh export may not recover every missing response. If repeated exports remain incomplete, inspect version history and contact your Microsoft 365 administrator or Microsoft Support.
Free Microsoft Office alternative

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.

Review and filter exported response rows in WPS SpreadsheetCompatible with Microsoft Excel XLSX and XLS formatsFamiliar spreadsheet interface for an easier transition from Microsoft OfficeFree, lightweight suite for everyday document work
microsoft office alternative - wps office

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.