Pulldata function: something wrong with CSV file

Support
1

What is the problem? Please be detailed.
I am working on an endline survey and this is the first time that I work with the pulldata() function. Basically I do everything correctly it seems, but collect does not load the data or gives an error. So I tried looking into the tutorial (http://xlsform.org/#how-to-pull-data-from-csv) which has an example file called pull_data with a CSV called 'fruits'. It turns out that when I download both in excel format and turn the 'fruits' file into CSV myself, it does not work. But when I download 'fruits' already as a CSV file, it does work! Apparently something goes wrong when I turn the data files into CSV, but what am I doing wrong?

What ODK tool and version are you using? And on what device and operating system version?
ODK Collect v1.15.0 on an android tablet.

2

Can we see your excel version and CSV version that you made?

3

Thank you for the quick reply. I solved the problem for myself now by using STATA instead to create a CSV file. This works. Perhaps my excel version is too old.

4

My guess is that there was a format issue with the CSV, probably with UTF-8 encoding.