Skip to main content
Breadcrumb
Home
Administration
Structure
Webforms
Invoice Form
Primary tabs
View
Test
Results
Build
Settings
References
Secondary tabs
Submissions
Download
Clear
The
Download
page allows a webform's submissions to be exported into a customizable CSV (Comma Separated Values) file and other common data formats.
Format options
Export format
?
Delimited text
HTML Table
JSON documents
YAML documents
Delimited textExports results as delimited text file.HTML TableExports results as an HTML table.JSON documentsExports results as JSON documents.YAML documentsExports results as YAML documents.
Warning message
Warning:
Opening
Delimited text
files with spreadsheet applications may expose you to
formula injection
or other security vulnerabilities. When the submissions contain data from untrusted users and the downloaded file will be used with Microsoft Excel, use the
Webform XLSX export
module.
Delimiter text format
?
Comma (,)
Tab (\t)
Semicolon (;)
Colon (:)
Pipe (|)
Period (.)
Space ( )
This is the delimiter used in the CSV/TSV file when downloading webform results. Using tabs in the export is the most reliable method for preserving non-latin characters. You may want to change this to another character depending on the program with which you anticipate importing results.
Generate Excel compatible file
?
If checked, the generated file's carriage returns will be compatible with Excel and a marker flagging the data as UTF-8 will be added at the beginning.
Warning message
Warning:
Opening
HTML Table
files with spreadsheet applications may expose you to
formula injection
or other security vulnerabilities. When the submissions contain data from untrusted users and the downloaded file will be used with Microsoft Excel, use the
Webform XLSX export
module.
Open HTML table in Excel
?
If checked, the download file extension will be change from .html to .xls.
File name
?
Used to create unique file names for exported submissions.
File name
?
Used to create unique file names for exported submissions.
Element options
Element multiple values delimiter
?
Semicolon (;)
Comma (,)
Pipe (|)
Period (.)
Space ()
The delimiter used when an element has multiple values.
Header options
Column header format
?
Element titles (label)
Element keys (key)
Choose whether to show the element label or element key in each column header.
Include an element's title with all sub elements and values in each column header
Column header label delimiter
Column header key delimiter
Entity reference options
Entity reference format
ID, an entity's unique identified
Title, an entity's title/label
URL, an entity's URL
Column options
?
The selected columns will be included in the export.
Titre
Nom
Date type/Element type
Serial number
Serial number
serial
integer
Submission ID
Submission ID
sid
integer
Submission UUID
Submission UUID
uuid
uuid
Token
Token
token
string
Submission URI
Submission URI
uri
string
Créé
Créé
created
created
Terminé
Terminé
completed
timestamp
Changed
Changed
changed
changed
Is draft
Is draft
in_draft
boolean
Current page
Current page
current_page
string
Remote IP address
Remote IP address
remote_addr
string
Submitted by
Submitted by
uid
entity_reference
Langue
Langue
langcode
language
Webform
Webform
webform_id
entity_reference
Submitted to: Entity type
Submitted to: Entity type
entity_type
string
Entity ID
Entity ID
entity_id
hidden
Verrouillé
Verrouillé
locked
boolean
Sticky
Sticky
sticky
boolean
Notes
Notes
notes
string_long
Metatags (Hidden field for JSON support)
Metatags (Hidden field for JSON support)
metatag
metatag_computed
Product Name
Product Name
product_name
hidden
sf retirement number
sf retirement number
sf_retirement_number
hidden
order number
order number
order_number
hidden
Invoice number
Invoice number
invoice_number
hidden
Reference
Reference
reference
hidden
Amount including tax
Amount including tax
amount_including_tax
hidden
Billing Date
Billing Date
billing_date
hidden
Status
Status
status
hidden
Article
Article
article
hidden
Quantity
Quantity
quantity
hidden
Delivery method
Delivery method
delivery_method
hidden
Download Invoice
Download Invoice
download_invoice
hidden
SF Account ID
SF Account ID
sf_account_id
hidden
SF Invoice ID
SF Invoice ID
sf_invoice_id
hidden
SF Order ID
SF Order ID
sf_order_id
hidden
user id
user id
user_id
hidden
amount_excluding_tax
amount_excluding_tax
amount_excluding_tax
hidden
invoice_type
invoice_type
invoice_type
hidden
paid
paid
paid
hidden
Description
Description
description
hidden
Due Date
Due Date
due_date
hidden
Currency ID
Currency ID
currency_id
hidden
External Order Ref
External Order Ref
external_order_ref
hidden
Payment Terms
Payment Terms
payment_terms
hidden
Still to Pay
Still to Pay
still_to_pay
hidden
VAT
VAT
vat
hidden
Country
Country
country
hidden
Country ID
Country ID
country_id
hidden
Address
Address
address
hidden
Address Line 1
Address Line 1
address1
hidden
Address Line 2
Address Line 2
address2
hidden
Area Code
Area Code
area_code
hidden
track
track
track
hidden
BAT Url
BAT Url
bat_url
hidden
Product ID
Product ID
product_id
hidden
Download options
Limit to
Tout
Latest
Submitted by
Langue
Submission number
Submission ID
Created date
Completed date
Date de modification
Number of submissions
User
Loading…
Langue
- Select -
Anglais
French
German
A partir de
À
A partir de
À
A partir de
À
A partir de
À
A partir de
À
Order
?
Sort ascending
Sort descending
Order submissions by ascending (oldest first) or descending (newest first).
Starred/flagged submissions
?
If checked, only starred/flagged submissions will be downloaded. If unchecked, all submissions will downloaded.