Create with ODK compatible xls
We support importing forms designed in the ODK-compatible XLS format into Appverse. However, please note that the XLS import is restricted to the format allowed in ODK XLS. Some additional configurations that are not supported in ODK XLS but are available in Appverse may need to be configured using the Appverse Form Builder.
This feature has been provided due to the widespread use of ODK forms, and we may extend support to other similar formats in the future.
Key Sheets in an xls form
An XLSForm typically consists of three main sheets:
survey – Defines the questions and form structure.
choices – Lists answer choices for select questions.
settings – Contains metadata such as form title and version.
Survey Sheet
Broadly the following input fields and their properties are supported in the survey sheet
type
Defines the type of question (e.g., text, integer, select_one, select_multiple, date, etc.).
name
The unique identifier for the question (no spaces or special characters).
label
The question text shown to users.
hint (optional)
Additional instructions for the question.
constraint (optional)
Validation rule to ensure correct data entry (e.g., .>0 for positive numbers).
constraint_message (optional)
Custom error message if validation fails.
required (optional)
true - if the question must be answered.
relevant (optional)
A condition to show/hide a question based on a previous answer.
calculation (optional)
Pre-fills a field using a formula (e.g., calculating age from date of birth).
appearance (optional)
Modifies how the question is displayed (e.g., compact for select options).
Choices Sheet
The choices sheet lists options for select_one and select_multiple questions.
list_name
The name of the choice list (must match survey sheet).
name
The stored value for each option (no spaces or special characters).
label
The display text shown to users.
Settings sheet
The settings sheet configures metadata for the form.
form_title
The display name of the form.
form_id
A unique identifier for the form.
version
Version number (e.g., 20240101).
instance_name
Custom instance name using fields (e.g., concat(${name}, '-', ${age})).
Validate the XLS Form
Use ODK XLSForm Online Validator to check for errors.
ODK Forms
Go to XLS Form to learn more ODK forms and their configurations
Create with ODK compatible xls
Last updated
