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 (Repeatable Field): In this format, each row of the Excel is a response of a Repeatable Field. In case of having multiple repeatable fields, 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.

---

Check out this informative video on how to export data

into different formats on Excel:

(https://fast.wistia.net/embed/iframe/8d5rv0ejhz)

-----------------------------------------------------------------------------------------------------------------------------

Related Articles

-----------------------------------------------------------------------------------------------------------------------------

Did this answer your question?