Can Survey123 export data to excel sheets?

Question

We are using survey123 with Portal to host our forms. Is it possible to export collected data from a survey to an excel sheet? I thought I saw something sometime ago where you could use an API but I can't seem to find anything searching google. We hope to export the selected data collected from survey123 and print them to our layouts and file them.

FRSadmin · Answer

Hello @BrandonArmstrong

I am also experiencing issues when trying to download directly from the Data Tab.

The Excel spreadsheet is in Japanese, but the first images blue buttin is to download.

By clicking on that the following error appears.

Has anyone else experienced this?

Exported Excel Spreadsheet.PNG

Error.PNG

BrandonArmstrong · Answer

Can you provide more information related to your environment?

What version of Portal are you using?

Were these surveys created from an existing feature service, or an XLSForm using Survey123 Connect?  If Survey123 Connect, can you upload your XLSForm or send to me in a private message on GeoNet?

One other thing to review is the following documentation related to exporting data

http://enterprise.arcgis.com/en/portal/latest/use/extract-data.htm#ESRI_SECTION1_01107CC9773F47BB815AED05EC24EB4C

JordanMiller4 · Answer

For some reason I am generating generic errors when I tried using the "Export" and "Report (Beta)" options. Any thoughts?

The first error occurs when we try using the Export feature.

The second error occurs when we try using the Report (Beta) to download a template: