Hello, I was download kobotoolbox data in xls form. I have many different group in my data that’s why i have many spreadsheet. My question is how to gather all spreadsheet in spss. is it possible to gather all data in spss including group data? please help Thank you :slight_smile:

Hi @fieldwork19 To fully do what you are looking for i is important to note the following behaviors around KoBoToolBox & integrating IBM (SPSS) 1… If you have repeating groups KoBoToolBox stores each group within its own sheet in the excel. The repeats from one questionnaire administration (instan…

Using SPSS to Merge Data from the Different Sheets in XLS from a Form that had Repeating Groups using SPSS

User Support Data Management

Kal_Lam February 12, 2020, 7:40am 2

Hi @fieldwork19,

Please be informed that you should be able to merge your dataset using SPSS. However, please ensure the following that has been discussed earlier while merging:

Have a great day!