topic Re: Export Survey123 hosted feature layer to csv or excel with Field Names in ArcGIS Survey123 Questions

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

GrantBenn1 — Thu, 25 Feb 2021 15:08:12 GMT

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

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

JamesTedrick — Thu, 25 Feb 2021 17:02:45 GMT

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.

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

GrantBenn1 — Fri, 26 Feb 2021 07:01:34 GMT

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

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

MicZatorsky_AEC — Mon, 01 Mar 2021 01:08:13 GMT

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.

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

GrantBenn1 — Tue, 02 Mar 2021 10:44:35 GMT

Thanks a lot, this is exactly what I needed.

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

RobertTaylor5 — Thu, 30 Sep 2021 16:47:10 GMT

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.

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

RobertTaylor5 — Thu, 30 Sep 2021 16:48:07 GMT

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