Skip to main content

How to export data into Excel?

How to export data in Excel Spreadsheet

Written by Aristotle
Updated over 2 weeks ago

In the Home you will be able to set the parameters (Date/User/Location/Specific Answer) before you export data. To begin, navigate to the Data Section that contains the form responses you wish to export. Locate and select the "Export" option, typically a button or menu option in this section.

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.

---

📌 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?