Survey123 Export Options Single page excel

643
1
Jump to solution
02-21-2021 02:26 PM
JamesHolland
New Contributor II

Hello one and all.

Still new to Survey123 and was wondering if there was a way to export surveys received into an excel or csv with just a single sheet to it? 

0 Kudos
1 Solution

Accepted Solutions
MicZatorsky_AEC
Occasional Contributor III

Does your survey have repeats?  If it does, you will get a separate worksheet for each repeat due to the 1:M relationship, so in that case it is not possible to download an Excel workbook with a single sheet.

You can transform this data (denormalised it) into a single table /worksheet with redundant data.  You can use either Excel or ArcGIS Pro depending on which you are more comfortable working in.

View solution in original post

1 Reply
MicZatorsky_AEC
Occasional Contributor III

Does your survey have repeats?  If it does, you will get a separate worksheet for each repeat due to the 1:M relationship, so in that case it is not possible to download an Excel workbook with a single sheet.

You can transform this data (denormalised it) into a single table /worksheet with redundant data.  You can use either Excel or ArcGIS Pro depending on which you are more comfortable working in.