Hi everyone, I hope you’re doing great.
We developed a survey with more than 700 variables in spanish, everything was OK until we have to convert data into Spss.
I’m downloading the data in CSV format and then imported it in SPSS, but in some cases the data haved mix and do not share the format from previous cases like in the picture.
Cool, thank you @wroos!
For the type of variables we are managing, the statistics we need to make and the time we have left, I will love to work with the XLS (labels) format.
Wonderful results with categorical variables, but I have some troubles with the numeric variables, the variable’s values appears in Excel in the numeric format, but when I want to make some calculations Excel doesn’t recognise the values, and is not aviable to make statistics, like the mean.
Thanks @Kal_Lam, the other formats in XLS shows the data correctly.
It seems that the CSV format have some trouble with some spanish characters, like “ñ” or the “accent mark” (á,ó,é,í,ú…), that doesn’t appear in english lenguage.
Do you believe this can be fixed by changing the lenguage settings of the project? or this is a regular issue?
Can you please help me with the differences between XLS and XLS(legacy) format?
I enhanced the posting above.
Just go with normal XLS export (NOT legacy), I would suggest. We are using it extensively, incl. Arabic texts.
For real numeric variables in form design, unfortunately exported as text by KoBo, we use Excel conversion “Text to columns” (Data menu), selecting the column. (Partly also for date values.). Simple format change seems not enough, will only change cell alignment.
I will love to keep in touch in any issues related with gathering and processing the data…
I agree, taking a look to all the options mentioned, XLS (XLM header and values) export seems the best way to have manageable data, at least in my case (we have several questions groups, and different types of data. The legacy formart seems to complicate the variable names).
Validating the data in the platform does modify in any way the data retrived (format, including a nex variable…)?
I’ll let you know if I have any issues with the spss syntax for labeling and formating the variables, hope not!
In the meantime, what @wroos recomended has actually proven very useful even on my end. I admit we have taken sometime to update the write up on the support around the use of CSV and the XLS downloads. This is largely because CSV woudl still be the best option.
In terms of action points, we will be looking at updating the post and toying around with various options of download to fully utilize the conversion to SPSS capabilities.
Its all about data management and upload interfaces which CSV has a better versatility compared to XLS provides. Preference of CSV and XLS is however a much more subjective choice that from a user support perspective, I would rather defer users to their organizational needs.