Downloded file with many sheets

[feron1]

Hi all, I downloaded data from kobocollect and the file come with four sheets included the main page and on the other sheets they group on each sheet. Please someone to help to combine these information correctly

[Kal_Lam]

Hi @feron1,

Welcome back to the community! Did you mean that you are seeing a sheet similar to what has been shared below while downloading your dataset:

Have a great day!

[feron1]

Hi @Kal_Lam,
Yes I have a file like that

[feron1]

Hi @Kal_Lam,
Yes I have a file like that. Please help me

[Kal_Lam]

Hi @feron1,

Kindly please be informed that you are seeing this as your survey project should has a repeat group question in it. The data in the first tab represents the main dataset for your survey project. The subsequent tab then represents the repeat group question present within the survey project.

You could merge the dataset (using a third party software) as outlined in the post that has been discussed previously:

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

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 (instance) will be linked to the main part (non repeating) questionnaire with the index (I believe you already knew this.) When working with SPSS or event STATA there are two data formats, long format a…

Have a great day!

[feron1]

Hi All,
Thanks for your feedback. So can you help me on how to link all this data with the data on the main page

[Kal_Lam]

Hi @feron1,

Kindly please follow the instructions outlined in the post shared above.

Have a great day!