I noticed some interesting, and in my case not desirable behaviour when I was exporting the results from a SharePoint survey to Excel: the order of the questions in Excel differed from the order in SharePoint.
Some further analysis showed the following:
When you export to Excel, the order is determined by the creation time of a question, so the questions that were create first appear before the others. This even happens after you reordered your questions in your survey, which was what I did.
To give an example:
I create a survey with 3 questions in the order 1,2,3:
I then reorder them to 3,1,2:
If I export them now to Excel, the order of the columns however is still 1,2,3:
So in case you need to export to Excel and don’t want to reorder your columns there afterwards, make sure you got the order right when you create your survey questions.
This is causing some notable frustration among my work team. I’ve seen posts as far back as 2009 about this issue, and now running SP2013, it’s still not fixed.
Not impressive, Microsoft.
SharePoint, fix this. You are making my job a lot harder and may switch to Microsoft forms