0

I have a form / survey created for Survey123. It has been published and I can access the data which has been captured through the ArcGIS Online Portal.

I would like to read the attribute information from this form in Excel. Similarly as I have connections to my SQL Databases and I can read the attribute information stored in the databases connected to my Collector for ArcGIS maps.

I know how to download the CSV / SHP / FGDB information, but I would like to connect to this information without the need to have a user logon to the AGOL and download it. Some users will not have ArcGIS Installed on their machines, so using Python is an option, but I cannot use arcpy.

Is there a workflow that will allow me to have a live connection between Excel and the attribute information stored in my Survey123 Form?

2

You can configure your survey123 form with a webhook, so everytime data is submitted, a new record is added into an xls file hosted in Microsoft 365 or in a Google Spreadsheet.

In this way, you have a spreadsheet showing live data from Survey123 and people dont need anything extra to look at the data.

You can learn more about webhooks in survey123 here

https://doc.arcgis.com/en/survey123/browser/analyze-results/webhooks.htm

And here:

https://community.esri.com/groups/survey123/blog/2018/07/19/automating-workflows-with-survey123-and-microsoft-flow

Microsoft Flow, Zapier, Integromat... are all great options with connectors that let you work with spreadsheets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.