How to Keep Microsoft Forms Multiple-Choice Answers in Original Order in Excel
Question details
The user wants to enforce the original predefined order of options for Microsoft Forms multiple-choice responses when exported to 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 applying formulas to reorder your data, ensure you have a complete master list of the original multiple-choice options in their exact intended order.
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.
Insert a new column next to your Microsoft Forms response data in your spreadsheet to hold the reordered text.
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", "").
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.
Drag the fill handle down to apply the formula to all survey responses in your dataset.

Submit a Feature Request to Microsoft
Since there is no built-in setting to enforce original order for extensive option sets, submitting feedback is the official recommendation.
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. Download WPS Office: Install WPS Office for free on your Windows, Mac, or Linux computer.
- 2. Export Your Form Data: Export your Microsoft Forms multiple-choice responses as an .xlsx file.
- 3. Open and Analyze: Open the file directly in WPS Spreadsheet to clean, reorder, and analyze your data using familiar formulas.

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.




