Survey123 groups form individual CSV when exported

197
1
02-12-2024 11:45 AM
SamanthaHannabass
New Contributor

I'm new to Survey123 and I created a survey for collecting gillnetting data. There are a few groups to help keep information separate and a few repeats (checking the same net multiple times but wanting to keep track of which check fish are caught). When I go to export to CSV, I get an individual CSV for each group and each repeat submission. How do I set it up to get all of the information to show up in one CSV? I was using repeats and groups to make the data collection process more streamlined in the field and I was hoping it would be an easy offload of data instead of having to enter all of the data.

Any suggestions?

0 Kudos
1 Reply
MicZatorsky_AEC
Occasional Contributor III

A set of related tables is exactly what you should expect.  If you export to Excel, you should see multiple worksheets, one for every Repeat.  This is because you have relational data.  To create a single view, you can join tables in Pro (where it makes sense) using the appropriate GUIDs as primary and foreign keys.

Are you 100% sure you're getting separate files for Groups?

0 Kudos