How to Find a Missing Microsoft Forms Response in Excel
Question details
The user has a Microsoft Forms form with dozens of responses, but one response is no longer visible and they are concerned it may have expired automatically because the form is more than a year old.

- Product
- Microsoft Forms with the associated Excel workbook
- Device & OS
- not provided
- Scenario
- The user needs to determine why a single Microsoft Forms response disappeared and whether the data can still be found.
- Observed behavior
- One response is missing from the Microsoft Forms response list while other responses remain visible.
Sign in to the same Microsoft account that owns the form and verify that you can access the associated Excel workbook. If multiple people can edit the form, remember that another collaborator may have manually deleted the response.
Check the Associated Excel Workbook for the Missing Response
Use this method first because Microsoft Forms can retain response rows in the linked Excel workbook even when a response is no longer visible in the Forms view.
The linked Excel workbook is the most reliable place to investigate a missing Microsoft Forms response. Microsoft Forms does not automatically delete responses based on age, so the data may still be present in the workbook even if the Forms interface no longer displays it.
Sign in to Microsoft Forms, open the affected form, select the Responses tab, and click Open in Excel to open or update the linked workbook.
In Excel or WPS Spreadsheets, press Ctrl+F and search for the respondent's name, email address, or a unique answer from the missing response.
If you have a previous copy of the linked Excel workbook, compare the row counts or look for deleted rows to identify whether the response was removed from the sheet.
Confirm Whether Another Collaborator Deleted the Response
Use this if the response is absent from both Microsoft Forms and the associated Excel workbook.
Review Microsoft Forms Response Data with WPS Office as a Free Alternative
WPS Office cannot restore a response that was deleted from Microsoft Forms itself, because Forms responses are managed in the Microsoft cloud. However, WPS Office is a free, lightweight Office suite that supports Excel workbooks and .xlsx format compatibility, with a familiar Microsoft Office-style interface, so you can seamlessly open, review, and manage exported response data without a Microsoft 365 subscription.
- 1. Download WPS Office: Go to the official WPS Office website, click Download, and install WPS Office on your Windows or Mac computer.
- 2. Open the exported workbook: Launch WPS Spreadsheets, click Menu > Open, and select the Excel workbook exported from Microsoft Forms.
- 3. Search the response data: Press Ctrl+F in WPS Spreadsheets and search for the respondent's name, email, or unique answer to check whether the missing response is retained.

Frequently Asked Questions
Do Microsoft Forms responses expire after one year?
No. Microsoft Forms does not automatically delete responses because of the form's age. If a response disappeared, it was more likely deleted manually or filtered from the current view.
Can I recover a deleted Microsoft Forms response from the Forms website?
Microsoft Forms does not provide a recycle bin for individual deleted responses. Check the associated Excel workbook, and if the response is not there, ask other collaborators whether they deleted it.
How do I open the Microsoft Forms Excel workbook in WPS Office?
In Microsoft Forms, open the Responses tab and click Open in Excel to export or update the linked workbook. Then download the .xlsx file and open it in WPS Spreadsheets using Menu > Open.
Why is only one response missing while the other responses are still visible?
Selective deletion is the most common cause. A form owner or collaborator can delete an individual response from the Responses tab, while leaving all other responses intact.
Does WPS Office manage Microsoft Forms responses?
No, WPS Office does not manage Microsoft Forms. However, WPS Spreadsheets can open the .xlsx workbook exported from Microsoft Forms so you can review and search the response data.




