Forum Discussion

Raquel_inResearch's avatar
Raquel_inResearch
Copper Contributor
Jun 07, 2023

Form Questions in Wrong Order in Excel Dowload

I am trying to start data analysis from responses to a Microsoft form. When I open the responses using the "open in excel" option, the questions are shown out-of-order in the excel sheet. I saw si...
microsoft forms
Survey
DingkunXie's avatar
DingkunXie
Icon for Microsoft rankMicrosoft
Jun 07, 2023

Raquel_inResearch 

 

If you perform 'Sync all responses to a new workbook', when you click the 'Open in Excel' button again, the newly generated workbook will be opened. When you open the newly generated workbook, you can see the name of the workbook displayed in the upper right corner. Clicking on it will bring up a window where you can view the current storage path of the workbook in the 'Location' field.

 

 

 

 

Resources