How to Preserve Historical Survey Responses When Removing Choices
Question details
The user needs to maintain the accuracy of historical survey response data when old project choices are removed from a recurring survey.
- Product
- Microsoft Forms / Excel
- Device & OS
- not provided
- Scenario
- Modifying a recurring survey by updating the choice list, specifically removing outdated project options without losing past data.
- Observed behavior
- When an old choice is removed from the survey list, previously collected responses that selected that choice incorrectly display as 'Other' because the data is no longer synchronized.
Before altering any choices in your active survey, ensure you have access to the survey's response tab to securely download and back up your existing collected data.
Export and Archive Existing Responses
The safest method to preserve previous survey results before making any changes to the choice list is to export the current responses to an Excel workbook.
Exporting creates a permanent archive of your respondents' selections before the survey structure changes. This ensures that even if live data gets re-categorized as 'Other', you still have the original historical mapping.
Open your survey and click on the 'Responses' tab located at the top of the form editor.
Click on 'Open in Excel' to generate and download a workbook containing all historical response data and individual selections.
Save this downloaded Excel workbook in a secure location as a permanent archive before deleting any survey choices.
Reorder Inactive Choices Instead of Deleting
Keep historical project names in the choice list but move inactive projects to the bottom to avoid desynchronizing past responses.
Create a New Survey for New Projects
Start completely fresh by creating a new survey dedicated to the new project set, leaving the historical survey intact.
Manage Your Exported Survey Data with WPS Office
Once you have exported your historical survey responses to an Excel file, use WPS Office as a lightweight, free alternative to Microsoft Office. It seamlessly opens your exported workbooks, allowing you to organize, preserve, and analyze your survey data without any formatting loss or costly subscriptions.
- 1. Download WPS Office: Download and install the free WPS Office suite from the official website.
- 2. Open WPS Spreadsheet: Launch the application and select the Spreadsheet module.
- 3. Open Your Survey Archive: Locate and open the .xlsx file you downloaded from your survey to safely view and analyze your historical responses.
Frequently Asked Questions
Why do my old survey responses show as 'Other' after deleting a choice?
When you delete a choice from the active survey list, the system can no longer match the historical response data to a valid option. As a result, the survey platform defaults to displaying the removed value under the generic 'Other' category.
Can I restore the original responses if I add the deleted choice back?
Sometimes, adding the exact choice text back to the survey can restore the data mapping, but it is not guaranteed across all form platforms. It is highly recommended to export an archive to Excel before testing this.
Does the exported Excel file update automatically with new responses?
If your form was created directly in standard Microsoft Forms, downloading the Excel file provides a static snapshot of the data. However, if the form was created via OneDrive or Excel for the web, the workbook may remain connected to the live survey and update automatically.
