HOW TO build XLS files with more than three search questions/ How to export XLS files built on Excel to the aggregate server

Support
1

Hi world,
ODK is a great data collection tool with endless propect and possibilities.
Friends i develop ODK forms using odk build web application.However i learnt about building XLS files through members on this platform, am exploring building XLS files through microsoft excel however am having some challenges.
1)I want to add more than three choices where i will include search for some questions how do i go about this(I would love a sample form that includes search widget to aid me in developing the XLS forms.
2)In what format do i export files after building in excel to enable me upload on the ODK server.
Thanks Guys

2

Hi @peter1

  1. Here is an example: https://docs.google.com/spreadsheets/d/1af_Sl8A_L8_EULbhRLHVl8OclCfco09Hq2tqb9CslwQ/edit#gid=0

  2. You just need to convert your xlsx file using, for example, our online tool: http://opendatakit.org/xlsform/ an output file is .xml that you can use.

3

Just for completeness, there is also an offline version of the XLSForm tool at this address: https://github.com/opendatakit/xlsform-offline/releases

2 Likes
4

Just for more completeness, there is also a command line tool:

Docs here:
https://docs.opendatakit.org/pyxform/

1 Like