Is it possible to export data into separate sheets for all groups?

User Support Data Management
, ,
1

Suppose my project contains 5 groups of questions. I want to export these 5 groups in 5 separate sheets. Is it possible to do so?

2

Hello @tamal and welcome to the community.

Can you tell us what do you mean by “seperate sheets”, so the community help you better?

1 Like
3

Thank you for your response. By separate sheet, I mean it could separate Excel files or separate worksheets within an Excel file. My main objective is to segregate the data by groups so that a large questionnaire/project can be easily handled during analysis. So, if I can export it in separate Excel files/separate worksheets, that might be helpful to deal with. Does that make sense?

4

Hi @tamal,

I’m not sure if it can be done during data downloading process in KoBo, but you can find some VBA codes for excel to do so.

I’m sure someone from community will give you a direct answer. Or a workaround.

Best,

1 Like
5

Thank you for bringing this to the community @tamal! Maybe we could explore the option to integrate this into our system.

6

Hi Tamal. I am just started learning Kobotoolbox and I have the same concern as yours. Were you able to solve it? Can you share with me how you do it? Thanks in advance.