Name Vs Label export in Survey123 CSV downloads

2462
2
02-20-2017 06:41 PM
TerryBeutel
New Contributor II

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.

Thanks

0 Kudos
2 Replies
CarmelConnolly3
Occasional Contributor II

Hi Terry,

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.

Carmel

TerryBeutel
New Contributor II

I tried it Carmel and it worked perfectly. Thanks so much!