How to export a form submission
Data entered in a submitted form from the app can be exported to a CSV or XLSX file. The information included in the export contains all the inputs entered and the options selected on the submitted form. Keep in mind this is not a report of the information formatted neatly.
You can use data in exported forms to update external programs or sort it in other ways to see the data from several forms for analysis. How you want to rearrange and use the data is up to you.
- From the Submissions and Logs menu, select Submission Exports. The Submission Exports page opens.
- From the Form Name field, select the form for which you want to export a submission. To limit the data retrieved enter a date range and the user who submitted the form. If you want to further limit the submissions by a particular piece of data on the form, select a field from the Form Field list, then enter the corresponding entry you’re looking for in the Field Value field. Click Find. The form submission(s) are displayed.
- Select what you want to include in the export. Text-based form selections and inputs are automatically included in the export. To include additional submission data in the export mark the appropriate options: Headers, Paragraphs, Links, Embedded Images, Image Captures, Signature Images and Attachments. These fields are excluded as a default because all, but image captures and signatures aren’t data entry information that would be valuable in a spreadsheet.
If you select to include embedded images, image captures, signature images, or attachments, the export will be in a zip file that contains the CSV or XLSX file, the image file and attachment. - Select the forms you want to include in the export. Depending on the browser you are using, you can open or save the file.
- Click the Export as CSV button or Export as XLSX button to export to the file type you want to use. All forms in the list are exported to that file. If you have a very large list of forms, or if there are many images, it may take a few moments for the import to complete. If you have tables on the form, they will be displayed in separate tabs on the XLSX spreadsheet.
- From there, the data from the forms can be reorganized as needed.