XLSForm
Last updated
Was this helpful?
Last updated
Was this helpful?
Using Excel, you can create any survey using the XLSForm format. XLSForm is a standardized way to design surveys by structuring questions, options, and logic directly within an Excel spreadsheet. Each question, response choice, validation rule, or survey logic is clearly defined in dedicated worksheets, making it simple to build and maintain even complex surveys.
Once designed, an XLSForm can easily be imported in ngSurvey using the XLSForm importer.
Here's a small sample illustrating the basic structure of an XLSForm which is based on 2 worksheets "survey" and "choices":
survey worksheet
text
name
What is your name?
integer
age
How old are you?
select_one yes_no
employed
Are you currently employed?
choices worksheet
yes_no
yes
Yes
yes_no
no
No
This simple example demonstrates how clearly structured questions and choices allow rapid survey design and straightforward conversion to interactive survey forms.
Repeat and entities of the XLSForm format are not yet supported.
To start your first XLSForm based survey you may start by downloading the Excel based template below. This template contains the main structure around which you can build your XLS form and also documentation of the different types that can be used to create your form.
A standard XLSForm is built using 3 Excel sheets within the same Excel file :
the survey sheet contains the main structure of your survey with its questions, pages, constraints and visibility rules.
the choices sheet let you define groups of lists of answers. These list of answers can then be used as set of answers for the selection based questions that you have defined in the survey sheet.
the settings sheet let you define common properties for your form like the form title.