Select to view content in your preferred language

Export Survey123 hosted feature layer to csv or excel with Field Names

2649
6
Jump to solution
02-25-2021 07:08 AM
GrantBenn1
Occasional Contributor

When exporting a Survey123 hosted feature layer to csv or excel the column names are showing the labels as set up in the XLSX file. There must surely be a way to export to csv or excel format using the field names? 

It can be done by exporting to FGDB, but what about users that don't have access to ArcMap or ArcGIS Pro?

Thanks,

Grant

0 Kudos
1 Solution

Accepted Solutions
MicZatorsky_AEC
Frequent Contributor

Actually this is super easy, barely an inconvenience.

At design-time, you can populate the column bind::esri:fieldAlias with the column label you want to see in the Excel.  Changing this after the initial publishing appears to have no effect though.  

If you have already published the survey, you can change the DisplayName in the AGOL Feature Layer to be the value you want to see in Excel, the next Excel export will pickup the change.

 

View solution in original post

0 Kudos
6 Replies
JamesTedrick
Esri Esteemed Contributor

Hi @GrantBenn1 ,

Survey123 uses the export capability built in to ArcGIS Online, which does not have the ability to choose between field names or aliases at this time.

0 Kudos
GrantBenn1
Occasional Contributor

Hi James,

Is there any intention to include this ability? The fact that it currently exports Survey123 hosted feature layers to csv or excel only with the question labels is not ideal. I have a survey where many of the questions have the same label, but for different categories of things separated with groups. 

Thanks,

Grant

 

RobertTaylor5
Occasional Contributor

Exporting display names rather than field names as column headers in a csv file seems like a bug to me.  They are called "display names" and "field names" for a reason, right?  Esri should fix this ASAP.  

MicZatorsky_AEC
Frequent Contributor

Actually this is super easy, barely an inconvenience.

At design-time, you can populate the column bind::esri:fieldAlias with the column label you want to see in the Excel.  Changing this after the initial publishing appears to have no effect though.  

If you have already published the survey, you can change the DisplayName in the AGOL Feature Layer to be the value you want to see in Excel, the next Excel export will pickup the change.

 

0 Kudos
GrantBenn1
Occasional Contributor

Thanks a lot, this is exactly what I needed.

0 Kudos
RobertTaylor5
Occasional Contributor

Barely an inconvenience?  Um.  I would disagree, especially since to do what you suggest, you would need to be the owner of the content.

0 Kudos