Version History Issues

How to Recover Missing Microsoft Forms Responses in Excel

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to recover historical form responses in Excel exports after modifying a question type in Microsoft Forms.

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Exporting collected response data to Excel after replacing an open-ended question with a drop-down question in a long-running form.
Observed behavior: Previous responses collected before the question modification no longer appear in the synchronized Excel export.

Before you start

Locate any older offline Excel exports to serve as a partial backup, and ensure you have full edit permissions for the Microsoft Form before attempting to resync the workbook.

Solution 1Recommended

Disconnect and Sync to a New Excel Workbook

Force Microsoft Forms to generate a fresh Excel export, which often restores hidden or disconnected historical responses.

When a question type is modified, the data mapping between Microsoft Forms and the active Excel spreadsheet can break, causing older responses to be hidden. Syncing to a new workbook forces the system to rebuild this connection and map all historical data properly.

Open the Form

Navigate to Responses

Click on the 'Responses' tab located at the top of the form interface.

Open the Workbook Menu

Click the three-dot '...' menu icon located right next to the 'Open in Excel' button.

Sync to a New Workbook

Select 'Disconnect and sync to a new workbook' from the dropdown menu, then wait for the new Excel file to generate.

Verify Data Recovery

Open the newly synchronized Excel workbook and check if the historical responses collected prior to the question change are now visible.

Solution 2

Contact Microsoft 365 Administrator for Support

If syncing to a new workbook fails to retrieve the data, the historical responses might require backend retrieval via a support ticket.

Free Microsoft Office alternative

Manage Your Exported Form Data Easily with WPS Office

While Microsoft Forms handles your online surveys, you can use WPS Office to open, analyze, and manage your exported Excel files. WPS Office is a highly compatible, lightweight, and free alternative to Microsoft Office, perfect for handling large datasets.

1. Download the Export: Download your synchronized responses as an Excel (.xlsx) file from Microsoft Forms.
2. Open in WPS Spreadsheet: Launch WPS Office, select 'Spreadsheets', and open your downloaded file.
3. Analyze Data: Use WPS Spreadsheet's built-in filtering and pivot table tools to analyze your complete response history seamlessly.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight software that loads large response datasets instantlyFree alternative with familiar spreadsheet UI and functionsBuilt-in data analysis, sorting, and chart generation tools

Frequently Asked Questions

Does changing a question type in Microsoft Forms permanently delete old responses?

No, Microsoft Forms does not normally delete historical responses when you change a question type. The data is retained in the backend, even if it temporarily disappears from the live Excel export due to mapping errors.

Where can I find the 'Disconnect and sync' option in Microsoft Forms?

In the 'Responses' tab of your form, click the three-dot menu icon next to the 'Open in Excel' button to access the 'Disconnect and sync to a new workbook' option.

Why did my previous responses disappear from the Excel file in the first place?

When a question type is fundamentally changed (such as switching from a text field to a drop-down menu), the data formatting changes. This breaks the data mapping to the active Excel sheet, causing older mismatched responses to be hidden.

Can I merge my old partial export with the newly synced workbook?

Yes. Once you generate a new synced workbook, you can safely copy the missing data from your older offline Excel backup and paste it into the new spreadsheet to manually consolidate your records.

Document & File Issues