Data Import & Export

How to Keep Microsoft Forms Multiple-Choice Answers in Original Order in Excel

Kushani NimanthikaKushani Nimanthika Oct 22, 2026 869 views

Question details

The user wants to enforce the original predefined order of options for Microsoft Forms multiple-choice responses when exported to Excel.

How to Keep Microsoft Forms Multiple-Choice Answers in the Original Order in Excel
Product
Microsoft Forms and Excel
Device & OS
not provided
Scenario
Exporting survey or form data from Microsoft Forms to Excel for data analysis and reporting.
Observed behavior
Multiple-choice responses populate in the Excel cell in the chronological order the respondent selected them, rather than the original option order set in the form.
Before you start

Before applying formulas to reorder your data, ensure you have a complete master list of the original multiple-choice options in their exact intended order.

Solution 1Recommended

Use Nested IF Formulas to Reorder Responses

Map user selections to your predefined order using text manipulation and nested IF formulas in Excel.

Because Excel populates the response exactly as the Forms API delivers it (by selection order), you cannot change the native export behavior directly within Microsoft Forms. However, you can use formulas to restructure the output in Excel.

This method works best for questions with a manageable number of options. For forms with 18+ options, consider using Power Query to split and restructure the dataset.

1
Create a Helper Column

Insert a new column next to your Microsoft Forms response data in your spreadsheet to hold the reordered text.

2
Write a Text Search Formula

Use a nested IF formula combined with SEARCH or FIND to check if specific options are present in the response string. For example: =IF(ISNUMBER(SEARCH("Alpha", A2)), "Alpha, ", "") & IF(ISNUMBER(SEARCH("Beta", A2)), "Beta", "").

3
Construct the Predefined Order

Ensure you arrange the IF statements in the exact order of your original form options. This forces the output to concatenate the matched choices in the correct sequence.

4
Apply to All Responses

Drag the fill handle down to apply the formula to all survey responses in your dataset.

Use Nested IF Formulas to Reorder Responses
Alternative Automation: If you are familiar with Microsoft Power Automate, you can build a custom flow to split the response array, compare it against a predefined list, and rebuild the string before inserting it into Excel.
Free Microsoft Office alternative

Analyze Form Responses Easily with WPS Office

While Microsoft Forms' native export behavior might complicate your raw data structure, you can seamlessly open, edit, and analyze exported form data using WPS Office. It provides powerful formula support, an intuitive interface, and full compatibility with Microsoft Office formats completely free of charge.

  1. 1. Download WPS Office: Install WPS Office for free on your Windows, Mac, or Linux computer.
  2. 2. Export Your Form Data: Export your Microsoft Forms multiple-choice responses as an .xlsx file.
  3. 3. Open and Analyze: Open the file directly in WPS Spreadsheet to clean, reorder, and analyze your data using familiar formulas.
Fully compatible with Microsoft Excel (.xlsx) and CSV formatsEasily process exported form data and survey responsesSupports advanced nested IF formulas and text manipulation functionsFree, lightweight, and features a familiar UI for seamless migration
microsoft office alternative - wps office

Frequently Asked Questions

Why do Microsoft Forms answers appear out of order in Excel?

Microsoft Forms and its underlying API record multiple-choice selections in the exact chronological order the respondent clicked them, rather than the predetermined order listed on the original form.

Is there a built-in setting in MS Forms to fix the export order?

No, currently Microsoft Forms does not have a built-in toggle or setting to force exported multiple-choice answers into their original predefined order. Workarounds like Excel formulas or Power Query are required.

Can Power Automate fix the selection order automatically?

Power Automate also receives the data from Forms in the selection order. To fix it, you would need to build a custom flow step that splits the response string, compares it to a predefined ordered array, and rebuilds it in the correct sequence.

How do I handle form questions with too many options to use nested IF formulas?

For questions with a large number of options, nested IF formulas become impractical. It is better to import your data into Power Query, split the response column by the delimiter (such as a semicolon), unpivot the columns, and sort them against a master reference table.