Dear @wroos and @stephanealoo
Many thanks for both of your replies.
When I download the data from kobotool box i choose csv and XML values and headers. When I open in excel there are no delays or error messages however the data downloads as semi colon separated rather than comman separated. I import the data to SAS and have accounted for semi colon.
For this issue I opened the data in textpad see this image
The XLS form is named as highlighted green in this image
we have included a hint to state the interviewer should enter 999 if the participant doesn’t know. Now we have found out that 999 causes the row to split in two on download.
When looking on koboToolBox itsself nothing looks strange see this image:
To me it seems like an issue when converting the data to csv in koboToolbox itsself but I cannot test this assumption.
Thank you for your time
Catherine
