Others

How to Find a Missing Microsoft Forms Response in Excel

Steven ParkerSteven Parker Nov 13, 2026 869 views

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.

How to Find a Missing Microsoft Forms Response in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Responses in Excel

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.

2
Search for the respondent

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.

3
Compare older workbook copies

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.

Response data may still exist: Microsoft Forms does not expire responses after one year. If the row is also missing from the linked workbook, the response was likely deleted manually by a form owner or collaborator.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office website, click Download, and install WPS Office on your Windows or Mac computer.
  2. 2. Open the exported workbook: Launch WPS Spreadsheets, click Menu > Open, and select the Excel workbook exported from Microsoft Forms.
  3. 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.
Open and inspect exported Microsoft Forms response workbooks in WPS SpreadsheetsFull compatibility with .xlsx Excel workbook filesFree and lightweight Office suite with a familiar ribbon interfaceNo Microsoft 365 subscription required for everyday spreadsheet review
microsoft office alternative - wps office

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.