topic Survey123 exporting to EXCEL Issue in ArcGIS Survey123 Questions

Survey123 exporting to EXCEL Issue

JustinDonaghy — Fri, 11 Oct 2024 11:20:17 GMT

i have a begin repeat in my form, I have two questions. (select one)

1. please choose a fibre cable: Answers: 1 -10 (Select Multiple)

2. Please chose a POE: Answers 1-12

How can I when I export the data to an excel that the POE answer goes onto the next row instead of being bunched up in one cell with cable fibre matching in row C

Re: Survey123 exporting to EXCEL Issue

ChristopherCounsell — Fri, 11 Oct 2024 23:12:22 GMT

That looks correct?

Repeat = new table.

Then each repeat entry will create a new table row. Your two questions will be columns in that table.

Select one = one value in a cell.

Select multiple = multiple values separated by a comma in one cell.

So the screenshot appears correct. If you're seeing something different or expect a different result please clarify.