I am downloading data from a survey on the survey123.arcgis.com as csv files. It all works fine except that the column heading on all downloaded CSVs are derived from the "label" and not the "name" column in the xlsform (the opposite is the case for the FGDB and Shp downloads). Its an issue because we want to work with the CSVs, but our survey has duplicate labels (for good reason and we don't want to chnage this) in the xlsform, which produces CSV tables with duplicate headers. Is there a way for me to change this or do I just take the the dbfs form the shape file and go from there instead.
Have you tried taking advantage of the Field Alias column in the spreadsheet? https://doc.arcgis.com/en/survey123/desktop/create-surveys/esricustomcolumns.htm#ESRI_SECTION1_9AC57...
This is a way to define a new 'label' to match your field names for the exported .csv. These aliases don't affect the way they form is viewed through the app.