Skip to main content
How to export data into Excel?

How to export data in Excel Spreadsheet

Aristotle avatar
Written by Aristotle
Updated over 10 months 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?