In the Resume you will be able to set the parameters (Date/User/Location/Specific Answer) before you export data.
There are three formats to export your answers
Grouped by Form: In this format each row of the Excel is a different form, and each column will have the name of the question and its respective answers. (It's the most popular format)
Grouped by Questions: In this format, each row of the Excel document is a question and answer of the selected form.
Grouped by Sub-form: In this format each row of the Excel is a response of a sub-form. In case of having multiple sub-forms, the exported data will be separated into one Sheet for each one.
Finally, just select the form you want to export and enter the e-mail address to which you will receive the Excel document with the selected format.
📌 If I modify the questions in a form, what happens to the order of the data in the Excel exportation?
The exported Excel will always reflect the current format of the form.
- If you add a new question, the previous forms that did not have this information will present this cell blank, and the following fields will all wrap forward.
- If you delete a question, the previous data will be kept in one column, and this column's cells will be left blank once you have new answers.