Kobo to SPSS

Dear everybody,
I have collected data with Kobo and have now opened it in SPSS (as XLSX file) but unfortunately the column “values” is missing completely. I read here in the forum that you have to download the SPSS labels separately and then run them in the program. I have done this, but

many error messages and no SPSS labels appear. I attached a Screenshot of the error messages. Unfortunately I do not know what the problem is… Has anyone else had this problem before?

I am greatful for any advice.

Hello Anne,
just some ideas.
At the end of your screenshot: I am not sure, if _ is valid at the beginning of a SPSS variable name, see https://www.ibm.com/support/knowledgecenter/SSLVMB_26.0.0/statistics_reference_project_ddita/spss/base/syn_variables_variable_names.html

Variable names can be up to 64 bytes long, and the first character must be a letter or one of the characters @, #, or $. Subsequent characters can be any combination of letters, numbers, nonpunctuation characters, and a period (.). … Letters include any nonpunctuation characters used in writing ordinary words in the languages supported in the platform’s character set. .

See also a previous post: Open data in SPSS

Maybe also to try import as UTF-8.

Could the […] brackets in the labels create a problems? You might try with a simple example and change them to (…) or remove them. You may just try: start "start {test}’.
All your error msg refer to Spalte 3 (column 3) and all cases have a [ …] there. But I think, it’s ok, as

Variable labels can contain any characters, including blanks. To enter an apostrophe as part of a label, enclose the label in double quotes or enter a two apostrophes (two single quotes). See https://www.ibm.com/support/knowledgecenter/SSLVMB_26.0.0/statistics_reference_project_ddita/spss/base/syn_variable_labels_overview.html

Also, your variable named Date might create a conflict with the SPSS DATE command.

Would like to hear about your solution, please.
Kind regards

1 Like