Exporting submissions

Last updated:

You can export submissions as a CSV file or Excel file and then work on these submissions in other applications.

If you only want to export some of your submissions, you can use criteria to filter your submissions before exporting them. To find out more about using filters, see our article on Filtering submissions.

Which export format is right for you?

CSV Export – Ideal for:

  1. Large datasets
  2. Import into various text or database applications
  3. Full data history (includes removed form fields from previous versions)

Excel Export – Ideal for:

  1. Visualizing survey responses (charts, graphs)
  2. Direct access to file attachments via links
  3. Clear display (only current form fields, separate sheets per form version)

Exporting submissions

  1. Click Forms at the top of the screen.
  2. Locate the form whose submissions you want to export.
  3. In the Submissions column, click the submissions number.
  4. In the Submissions overview, click Export at the top right.
  5. If you have adjusted the column view, choose whether to export all columns (including hidden columns) or only the current view.
  6. If filters are applied, choose whether to export all submissions or only the filtered submissions.
  7. Choose your export format and follow these steps:


CSV Export
:

  1. Select CSV
  2. Click Export
  3. (Optional) Enable Rename file to provide a custom filename
  4. Click Export
  5. The file is automatically saved to your download folder


Excel Export
:

  1. Select Excel
  2. (Optional) Under Advanced options, enable Export attachments to include uploaded files
  3. (Optional) Enable Rename file to provide a custom filename
  4. Click Export
  5. The file is automatically saved to your download folder

Structure of the export files

Header row (first row)

Both formats contain the following columns:

  1. Form ID: Automatically assigned identifier
  2. Version: Form version identifier
  3. Received: Timestamp of the submission
  4. Form elements: Labels displayed to users in the form
  5. Status: Current state of the submission
  6. User Agent: Information about the user's agent
  7. Language: User's language setting
  8. HTTP referrer: Source of the submission
  9. Email confirmation: Indicates whether double opt-in was used

Technical names (second row)

Lists the technical names assigned to each form field during creation. Metadata key names are listed according to the user's language setting.

Submission data (from third row)

Each row represents a submission. The Form ID identifies the start of a new submission.

Feedback