Creating a Survey123 form using an Excel Spreadsheet File

TahirTamba

Hi,
I'm trying to load an Excel file with 78 columns and 28560 records into Survey123 Connect in order to create a questionnaire based on existing variables in the Excel file.
Unfortunately I get this error message while loading the file:

XLSForm file conversion failed
The survey sheet is either empty or missing important column headers

See the screenshot in attached file.

Any ideas abour this error?

 

Thanks!

survey123_error_screenshot.png

Anonymous User

Hi @TahirTamba,

To create a new survey in Connect, if you don't have a XLSform template already, you need to start by using the Standard or Advanced template, or a Sample, to create the base requirement of sheets and columns to get started. Once you have the base template, you can then add question types, names, labels and other more advanced configurations.

If you want to use the exported xlsx file you provided as a choice list so that users can select a value from it (as it appears you exported this from a feature layer or file geodatabase) you will need to copy these values into the choice sheet with a choice list name, value and label, that refers to a select one or select multiple question in the survey sheet. Given the size of the values in your list, you should probably use an external choice list or if you are just wanting to search and return one value, use a pulldata() at CSV calculation.

Please refer to the Survey123 online documentation to get started.

Regards,

Phil.