Others

How to Change Microsoft Forms Options After Sharing a Survey

Ayan MasoodAyan Masood Nov 3, 2026 869 views

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.

How to Change Microsoft Forms Options After Sharing a Survey
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.
Before you start

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.

Solution 1Recommended

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.

1
Edit Form Options

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.

2
Export Responses

Navigate to the 'Responses' tab at the top of your Microsoft Form design page and click 'Open in Excel' to download your collected data.

3
Standardize Data

Open the downloaded spreadsheet and use the 'Find and Replace' feature to replace all instances of the old labels with the new ones.

Edit Form Options and Harmonize Data in a Spreadsheet
Data Preservation: Previous responses are never deleted when you change option names; they simply retain their original text in the exported file.
Free Microsoft Office alternative

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. 1. Open the exported data: Right-click your downloaded Microsoft Forms spreadsheet and select 'Open with WPS Office'.
  2. 2. Access Find and Replace: Press the Ctrl + H keyboard shortcut to launch the Replace dialog box in WPS Spreadsheet.
  3. 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'.
Seamless compatibility with Microsoft Excel (.xlsx) formats for exported survey data.Free built-in 'Find and Replace' tools to quickly clean up inconsistent survey responses.Lightweight software that runs smoothly on Windows, Mac, and Linux systems.Familiar user interface makes transitioning from Microsoft Office effortless.
QA img-9

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.