Forms response columns are out of order

This article was written by Zakir Haveliwala, Senior Support Escalation Engineer.

Symptoms

In Microsoft Forms, you may experience an issue in which the response columns are out of order in the response workbook for a form when you compare the columns to the order of the questions on the form.

Cause

This is a known issue that's being investigated.

Workaround

To work around this issue, locate the Responses tab on the form, click the ellipses, and then select Sync all responses to a new workbook. This resets the order of the columns to match the order of the questions on the form.

Screenshot to select the Sync all responses to a new workbook option in Excel.