Problem: Choice values in a survey created in survey123.arcgis.com do not display correctly when exported as a CSV, Excel file, or shapefile
If a Dropdown question with multiple choices is created in survey123.arcgis.com and the survey is exported as a CSV, Microsoft Excel file, or shapefile, the values of the choices do not display correctly when viewed in Microsoft Excel.
In the example below, the Town Location field displays the names of the cities in the graphic on the left, but the values in Excel display as 'choice0', 'choice1', and so forth.
This is a known limitation. The exported choice values display the underlying values instead of the named value for each choice. Therefore, if the choices in the example above are named based on town location, such as 'Walkerton', 'Clifford', 'Elmwood' and 'Southampton', the exported choices are displayed as 'choice0', 'choice1', 'choice2', 'choice3', and 'choice4'.
Solution or Workaround
To resolve this issue, use one of the following workarounds, depending on the file type needed.
Create the survey with Survey123 Connect for ArcGIS
Create the survey using Survey123 Connect for ArcGIS and publish the survey. When the survey is exported from survey123.arcgis.com, the choices retain the intended values instead of showing the underlying values.