Skip to main content
Search
Search
The Academy of Lacey
Main navigation
Our AoL Team
Our Work
Home
I Love This Job
I Love This Job
Format options
Export format
?
CSV download
Delimited text
HTML Table
JSON documents
YAML documents
CSV downloadExports results in CSV that can be imported back into the current webform.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
CSV download
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.
Use UUIDs for all entity references
?
If checked, all entity references will use the entity's UUID
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
Select menu, radio buttons, and checkboxes options
Options single value format
?
Compact, with the option values delimited by commas in one column.
?
Separate, with each possible option value in its own column.
?
Elements that collect a single option value include select menus, radios, and buttons.
Options multiple values format
?
Compact, with the option values delimited by commas in one column.
?
Separate, with each possible option value in its own column.
?
Elements that collect multiple option values include multi-select, checkboxes, and toggles.
Options item format
Option labels, the human-readable value (label)
Option values, the raw value stored in the database (key)
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.
Title
Name
Date type/Element type
Serial number
Serial number
serial
integer
Submission ID
Submission ID
sid
integer
Submission UUID
Submission UUID
uuid
uuid
Submission URI
Submission URI
uri
string
Created
Created
created
created
Completed
Completed
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
Language
Language
langcode
language
Webform
Webform
webform_id
entity_reference
Submitted to: Entity type
Submitted to: Entity type
entity_type
string
Submitted to: Entity ID
Submitted to: Entity ID
entity_id
string
Locked
Locked
locked
boolean
Sticky
Sticky
sticky
boolean
Notes
Notes
notes
string_long
What type of compliment
What type of compliment
what_type_of_compliment
select
Tell us how much you love the job
Tell us how much you love the job
tell_us_how_much_you_love_the_job
textarea
When did this happen????!!!!
When did this happen????!!!!
when_did_this_happen_
date
Download options
Download export file
?
If checked, the export file will be automatically download to your local machine. If unchecked, the export file will be displayed as plain text within your browser.
Limit to
All
Latest
Submitted by
Submission number
Submission ID
Created date
Completed date
Changed date
Number of submissions
User
From
To
From
To
From
To
From
To
From
To
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.
Archive options
Archive file type
?
Tar archive (*.tar.gz)
ZIP file (*.zip)
Select the archive file type for submission file uploads and generated documents.
Download
Save settings