During downloading data the group data appeared into different file

[vikassamvad2020]

Data removed due to presence of identifier information

please help me i am unable to connect xls data with the parent link.

[Kal_Lam]

Could you kindly explain your issue in detail so that we could help you out.

[vikassamvad2020]

i have downloaded data from kobo XLS legacy format, and i have seen the 8 group data of the survey format is showing in 3 different sheet… till 1 to 7th group data is in one sheet but from 8th group onwards data seperated into 3 sheets and i am not able to take the date into one sheet.

like round 1100 women surveyed but in different sheet of women showing 121, 60 , 5 different number of data into sheets

[Kal_Lam]

@vikassamvad2020, please be informed that you generally get the data in different sheet when you use the repeat group question within your survey project. For better understanding please feel free to have a look at the post discussed previously:

Group questions Data

Hi @fieldwork19, Please have a look at the image attached below. It’s a sample of the xls dataset downloaded from the KoBoToolbox server. [Image%201111] 1 viz. Survey is the sheet containing the main dataset. 2 viz. D_O_O is the sheet containing the repeat group responses. Similarly, 3 viz. DO_O is the sheet containing the repeat group responses. So, generally in a dataset you will have only one 1 sheet while you may have many sheets like 2 or 3 (depending upon your questionnaire). Besides,…

So as a workaround you will need to merge them to a separate sheet as discussed in this post:

When i download my data it comes in different sheets, how do i make them appear in one?

Hi team, I have an issue with my data. My questionnaire is grouped into subsets. when i download it comes in different sheets this is not easy for analysing, how do i make themappear in one ? please help me out… Regards

or

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…

[vikassamvad2020]

i am unable to do as you suggested me previously. please help me to make one common sheet
adcWhUemSXdCnPVj5GzYoE_2021_01_05_18_11_03.xlsx (1.7 MB)

[eldarko]

Thanks. This was the solution I was looking for. I noticed that some of my groups in the form were not appearing on a separate worksheet in Excel after download. After making those groups to REPEAT, they appeared on separate sheets as needed