How to Change Microsoft Forms Options After Sharing a Survey
Question details
The user wants to update the choice options (such as changing Woman/Man to Female/Male) in a Microsoft Form that has already been shared and has collected responses.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Editing choice labels in a live Microsoft Forms survey after it has been distributed to respondents.
- Observed behavior
- Updating options changes what new respondents see, but previous responses retain the old text values and may appear categorized under 'Others' in the form's summary view.
Keep in mind that modifying options in a live form will not automatically retroactively update the text values of the responses you have already received.
Edit Form Options and Harmonize Data in a Spreadsheet
Change the labels directly in Microsoft Forms for new respondents, and export your results to a spreadsheet to standardize the old data.
When you change an option label in Microsoft Forms after collecting responses, the original data is not lost. However, because the text values differ (e.g., 'Woman' versus 'Female'), old responses will often be grouped under an 'Others' category in the form's response page.
To properly analyze all the data together for consistent reporting, you must export the responses and clean up the old labels in a spreadsheet program.
Open your Microsoft Form in edit mode, select the question you want to update, and type over the existing options to apply the new labels.
Navigate to the 'Responses' tab at the top of your Microsoft Form design page and click 'Open in Excel' to download your collected data.
Open the downloaded spreadsheet and use the 'Find and Replace' feature to replace all instances of the old labels with the new ones.

Analyze Your Survey Data Using WPS Office
While Microsoft Forms is used to collect survey data, you need a reliable spreadsheet tool to analyze and clean the exported results. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, allowing you to easily manage and format your exported survey files.
- 1. Open the exported data: Right-click your downloaded Microsoft Forms spreadsheet and select 'Open with WPS Office'.
- 2. Access Find and Replace: Press the Ctrl + H keyboard shortcut to launch the Replace dialog box in WPS Spreadsheet.
- 3. Update the labels: Enter your old survey label in the 'Find' field and the new label in the 'Replace with' field, then click 'Replace All'.

Frequently Asked Questions
Will changing survey options delete previous responses in Microsoft Forms?
No, changing survey option names does not delete previous responses. The existing records retain their original text values, but they may be grouped under an 'Others' category in the visual results summary.
How quickly do form updates appear for new respondents?
When you change an option directly on the Microsoft Forms design page, the updates are saved automatically and should appear for new respondents almost immediately upon refreshing the shared link.
Can I merge the old and new responses automatically in Microsoft Forms?
Microsoft Forms does not automatically merge or convert old response values to match the newly updated option labels. To consolidate your reporting data, you must export the responses to a spreadsheet and manually replace the old terms.




