Others

How Changing Likert Scale Options Affects Microsoft Forms Responses

Camila Milosovich Oct 1, 2026 868 views

Question details

The user needs to understand how editing the order of Likert scale choices in a live Microsoft Form affects the responses that were submitted prior to the edit.

How Changing Likert Scale Options Affects Responses in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Editing or reordering the choices of a Likert scale question in a survey after some responses have already been collected.
Observed behavior: Responses submitted before the edit shift to match the new option located in the previously selected positional index, causing historical results to appear inaccurate.

Before you start

Before making any changes to a live survey, always navigate to the Responses tab and export the current data to an Excel spreadsheet to ensure you do not lose the original context of early submissions.

Solution 1Recommended

Managing and Correcting Shifted Likert Scale Data

Understand how the positional data mapping works in Forms and manually reconcile your pre-edit survey results.

Microsoft Forms records Likert scale choices based on their structural position index (e.g., 1st option, 2nd option, 3rd option) rather than the exact text of the choice. If you change the text or order of the choices after responses have been collected, any previous answers will automatically map to whatever text now occupies that numerical position in the sequence.

Export the current dataset

Open your Microsoft Form, navigate to the 'Responses' tab, and click 'Open in Excel' to download your current data.

Identify the change timeline

Check the submission timestamps in your exported Excel file to identify exactly which responses were submitted before you edited the Likert scale choices.

Manually adjust the affected data

In Excel, manually correct the answers for the early respondents by mapping the new text back to the original option text (for example, if a respondent selected 'Slightly disagree' when it was the third option, and the third option is now 'Neutral', change their response back to 'Slightly disagree' in your spreadsheet).

Managing and Correcting Shifted Likert Scale Data

Automatic UI Updating: Once the choice order is changed, the Forms results dashboard automatically updates to reflect the new positions. It is impossible to view the old alignment directly within the Forms web interface.

Free Microsoft Office alternative

Try WPS Office to Analyze Your Survey Data

While Microsoft Forms manages survey collection, you need a powerful spreadsheet tool to clean and analyze the exported data. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office, perfect for managing your survey reports.

1. Download WPS Office: Install the free WPS Office suite on your computer or mobile device.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet and select 'Open' from the main menu.
3. Import Forms Data: Locate the Excel file exported from Microsoft Forms to begin cleaning and analyzing your Likert scale responses.

100% compatible with Microsoft Excel (.xlsx) formats for opening exported survey data.Free and lightweight suite including Writer, Spreadsheet, and Presentation.Familiar user interface with no learning curve, making data reconciliation simple.

microsoft office alternative - wps office

Frequently Asked Questions

Can I revert the Likert scale choices to restore my old data in Microsoft Forms?

Yes, if you change the options back to their exact original order, the previous responses will map back to the correct text for those earlier submissions. However, doing so will then skew any responses that were collected while the temporary order was active.

Does Microsoft Forms warn you before editing a live Likert scale?

Microsoft Forms allows you to edit a live form at any time, but it does not provide a specific pop-up warning that altering Likert scale options will misalign the display of already submitted responses.

How do I safely fix a Likert scale if the survey is already active?

The safest method is to duplicate the form, correct the Likert scale in the newly created version, and send the new link to future respondents. This ensures your previous dataset remains completely untainted.

Office Quick Solutions