Instead of each question having its own column in Excel, there should be one column which contains the question number, another column with the question title, and another column with the response.

Essentially, each question/response would be a seperate ROW in excel, not all questions/responses on the same row.

Each row should also contain "KEY" information like the date, respondant's name etc.

This would enable us to analyse response in PowerBI much easier.

Please see the attached file. the DATA tab shows the prefered data format

ทุกครังที่จะเข้าดูการตอบแบบฟอร์มต้องโหลดทุกครั่งทำให้เกิดชื่อไฟล์ที่ไม่จำเป็นจนเป็นขยะใครเครื่อง

It used to have a "locked" on forms when I uncheck the "receiving response" now it's gone... I lost the ability to differentiate draft from production forms !

Please bring it back or assign other indicator.

Once a form has been submitted, I sometimes need to add data. For example my teachers log missed prep on a form, but then the office needs to add a date when prep was recovered. I have added a question "For Office Use only" but we can't add to a submitted form.... We can only track when the teacher's miss prep, but not when their prep is recovered.

Hi team, I have an issue exporting the results of my Form on Excel; some answers come with the number 6 for a rating between 1 and 5 in the question. Where does the 6 come from ? It happened on several questions and with several respondents. We can't rely on false results. Thank you for your help.

En Google cuando copio y pego celda, automáticamente se generan las múltiples opciones. Pero si hace eso aquí, todo se pega en una misma celda.

połączcie mechanizm formularzy i ankiety w arkuszach online z formularzami, tak aby oba rozwiązania miały taką samą funkcjonalność, a dostęp do pliku z wynikami był z poziomu OneDrive, tak jak ma to miejsce z ankietą w arkuszu.

If the restriction is selected as a number then the data populated into excel should be in number format as well to do formulas. Otehrwise you need to change the numbers to number value each time.

This will allow me to build "reporting" (i.e. pivot tables, charts, etc.) in excel and then update them without needing to manually download the data and copy/paste it.

to provide option to give a column header name for each question such that when exporting the responses in excel the customized header name will appear instead of the question

Como puedo ir eliminando información que no necesito de los formularios de excel?

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.