EXPORT FORM SUBMISSIONS
Learn to export form submissions from the submissions panel.
- Step 1: Click Export Submission
- Step 2: Select a date range
- Step 3: Click Export
The file downloads as a zip file. If your form has multiple revisions, the file will include a different CSV for each revision.
The CSV file includes:
- All form data
- Submission date
Please Note: URLs do not include the domain name. To open a URL, add the prefix https://design.formcan.com to the given URL extension.
Here’s a description of some fields within your export:
| Field Type | Description |
|---|---|
| Choice | The Choice label. If more than one is selected, they are separated by commas. If the Other option is used, its input value appears after the last comma. |
| Dropdown | The Dropdown field can have a different label and value. Exports show the value of a Dropdown. If more than one is selected, they are separated by commas. |
| Signature | A URL path can be appended to https://design.formcan.com to download the signature. |
| Upload Files | A URL path can be appended to https://design.formcan.com to download the file. |
Exported CSV Settings
You can get the CSV of a form submission in three different places. The first is this submission export. Second, if “attach_csv_data” is set in the notification email, the notification will be sent along with its CSV data.
Finally, if you have enabled the cloud drive feature, the CSV file will also be uploaded to your cloud drive.
For email and cloud drives, the default format of CSV is vertical columns. This is because CSV always includes a submission data and vertical formatting of CSV is usually for easy reading. However, you can change this setting in this Export CSV dialog in this Export CSV dialog. Please note that this setting is specific to each form.
In addition to the CSV format, you can also set the CSV delimiter, which currently supports Comma, Semicolon and TAB.