Mass Uploading data into Survey123

[HaileyTimmons]

I am trying to see if there is a way to mass upload a bunch of data into a survey.

I have the survey built and is ran off a unique identifier tied to a layer (Location List) from the design pane. I am trying to figure out a way to upload several data points at once for when we have mass closures so we are not manually entering 100+ sites every time. Is there a way to do this?

This data then feeds into a dashboard, so it needs to run off the unique identifier as that has all the location data.

[DavidSolari · Accepted solution]

If you're fine going outside of the Survey123 apps you can upload data directly to the feature service that comes with every survey form. Just make sure all your domain codes and whatnot are valid and you can do mass updates in Pro, a web app, etc. etc.

[HaileyTimmons]

I tried doing it through the feature service and it wouldn't let me, or I am doing it wrong. I would not let me upload data unless I had a Lat/Long field.

[ZenMasterZeke]

In Pro, if the new data is a table, add the it as a csv file (other files like xlsx work, but csv is easiest).  Add lat and long fields (data type double) if you don't already have them. Then, geocode the file (this assumes you have address info), which will give you a feature layer with lat/long. You can then copy the lat/long data into your original file and update or append that data into your S123 layer. Or append the geocoded layer to the S123 layer, either using the field map to match fields, or just deleting unwanted fields before appending.

If the data is already a feature layer,  calculate the x/y geometry in the attribute table and append it to the S123 layer