Skip to main content
How to export data into Excel?

How to export data in Excel Spreadsheet

Aristotle avatar
Written by Aristotle
Updated over a week ago

In the Resume you will be able to set the parameters (Date/User/Location/Specific Answer) before you export data.

There are four 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.

  • PDF documents: this option allows you to export the data in a PDF document

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:

📌 Important:

If you cannot see the "Export" button, confirm with your Account Administrator that your user has the necessary access to perform this action.

More details in the following article:

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

Related Articles

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

Did this answer your question?