Whenever I export Form results to Excel, the data is formatted in a way that makes it difficult to work with. Even if I remove all formats or convert text to numbers, I frequently encounter bugs. F4 doesn't work to lock cells in equations, dates written in MM/DD/YYYY format don't actually convert to dates format even when I remove formatting or change it manually, etc.

Plus, I also find that these document regularly add dead cells hundreds of columns in so that my scroll bar is useless without manually deleting all extra columns. This usually happens with Online Excel documents.

If i have two question regarding to time and i want the subtract value in Question 3 then it need to give the subtraction value of two different question into other question or form input/output.

If i have two question regarding to time and i want the subtract value in Question 3 then it need to give the subtraction value of two different question into other question or form input/output.

We use Microsoft Forms at our school as a way to track student behavior. When a teacher provides a consequence to a student, they log it on a Microsoft Form. Due to privacy concerns, we cannot allow all teachers to have access to the Excel results. Is there a way that when a teacher submits a form, it can go two places: the private Excel spreadsheet containing all submissions from all teachers AND a personal Excel spreadsheet containing just that teacher's submissions?

This is a known issue for MS. A solution could be as described in the following link:

https://blogs.technet.microsoft.com/fesiro/2012/12/01/how-to-includeretain-the-document-version-with-export-to-excel-spreadsheet/

Should be nice, if we don't have to us this workaround, but that MS comes with a solution.

自分で作成したExcelシートの指定した列に入力結果が保存されるようになると嬉しいです。

I would like to be able to select a number of answers to show in the spreadsheet (rather than all of them)

That is to say select say five pithy questions and their responses and generate the spreadsheet so I can present focused data :-)

as above

At present when results are exported, not all feedback is exported. If questions are reviewed and fed back after a test is taken then this feedback is not exported in the Excel file - which kind of defeats the point in the feedback column for each question being there. This would be incredibly useful when making a record of feedback given.

Looks like it combines all responses into one Excel doc when you go to Excel. We want to be able to save someone's response with their file outside of MS Forms.