topic Re: Populate Survey 123 answers from an excel in ArcGIS Survey123 Questions

Populate Survey 123 answers from an excel

GustavoAdolfoMartinezHincapie — Wed, 05 Oct 2022 23:25:46 GMT

I have a survey and I want you to know it it is possible to load an excel file and automatically populate some answers.

For example:

Every two weeks a contractor sends to me an excel with a list of workers.

The excel has around 20 names and IDs. In order to request authorization from my boss to grant access to the workers, I created a survey in survey123. However, I am wasting time filling in the names of those 20 names and IDs in my survey. I don´t want to waste time typing all the info again.

So, is it any way to load the excel in the survey and automatically fill it?

Re: Populate Survey 123 answers from an excel

LaurenceTait — Wed, 05 Oct 2022 23:59:19 GMT

What exactly are you trying to do? Do you just want to list all the names in a single field, or do you want to have the names as options so you can fill out the survey for each person?

There's a simple enough solution either way, but you need to explain what you are trying to achieve.

In general terms, you just need to convert the Excel sheet into a csv file and then use the select_from_file question type:

https://community.esri.com/t5/arcgis-survey123-blog/work-with-csv-data-in-arcgis-survey123/ba-p/1157642

Re: Populate Survey 123 answers from an excel

DougBrowning — Thu, 06 Oct 2022 14:17:55 GMT

You can also upload it to AGOL and link to it directly.

https://community.esri.com/t5/arcgis-survey123-blog/work-with-csv-data-in-arcgis-survey123/ba-p/1157642

Re: Populate Survey 123 answers from an excel

GustavoAdolfoMartinezHincapie — Fri, 07 Oct 2022 00:12:53 GMT

Thanks!!!! this was exactly what I was looking for!!!!

Re: Populate Survey 123 answers from an excel

GustavoAdolfoMartinezHincapie — Fri, 07 Oct 2022 00:13:22 GMT

Thanks!!! Never used AGOL before, great opportunity to learn.