Partial Data Exports to CSV

[joelrhine]

Hi,

I’m trying to download a KoBoToolbox survey with data in a csv format. When I try to open it in Excel, only partial data shows up. A Major chunk of the data is missing.

When I try to edit or preview the form submission on the KoBo website there are no problems and I can see all the data along with the images.

Please help.

Thank you,
Joel.

[wroos]

Hello,

• Could you provide a screenshot of what you see (and explain what is missing)?
• With what settings did you export?
• You may have several sheets in the Excel workbook, if you used repeat groups.
• If you work with Excel, why do you use csv instead of xls?

Side-note; Tests (and field pre-test) before the real survey should cover the whole data management process, including export (and transfer for analysis) of data.

[stephanealoo]

Hi,
Without more information, I would point out that you probably are missing data from repeat groups in what you are seeing on the CSV. If that is the case then you should know that the CSV will only show you data from one sheet of an excel. On the other hand, when you export data from repeat groups, this will be located in separate sheets from the main sheet (which is what you had in the CSV. My suggestion would be you download the data in XLS and not CSV if you have repeat groups in the form. See this previous discussion thread

Is there a way to have repeat group data in the same sheet?

Hi @ahmadkhalid01, Welcome back to the community! At the moment there is no way that you get the repeat group data in the same sheet in KoBoToolbox. The design is that the data is processed as a long format i.e. one variable, one response per cell in excel. As such repeat gets more responses per question which have to be taken into a seperate sheet to keep this conformation. You may need to convert the data into wide format where repeating instances of the question in repeat are indexed. You c…

If the issue is not as I had indicated above, could you please provide more detailed information.
Stephane

[joelrhine]

Hi @wroos and @stephanealoo,

Thank you for responding to my problem. @stephanealoo guessed it right, that data was in the repeating groups. downloading the submission form in xlsx and converting the required repeating sheet to csv solved the issue.

Although there is another unrelated problem. Can I download a specific submission instead of all the submission together? Should I create another topic for this?

Thank you!
Joel.

[Kal_Lam]

Downloading a specific submissions at the moment is not possible with KoBoToolbox. We already have a feature request here:

Allow downloading media for subset of records (instead of all at once)

What is the general goal of the feature? To select a subset of records for download rather than always having to export ALL media Downloading bulk photos - #11 by ebaptista What are the most likely user stories for how and when this would be used by someone on your team? *when there are multiple “rounds” of a survey, with interim analysis - e.g. in the case of a Pacific Island Nation one island is surveyed in October, a different island is surveyed in November etc. and results from each islan…

Maybe you could VOTE for it if you wish to make this a reality!

[joelrhine]

Hi @Kal_Lam,

Thanks for redirecting me to the feature request. I have voted for it too!

Thanks and have a nice week.

Best,
Joel.