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?
Solved! Go to Solution.
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.
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.