Importing excel spreadsheet to Survey123

[NkatekoMARIMA]

Good day

I have an Excel spreadsheet with information on training needs for officials in my Organization. I want to convert the information into Survey123 form. I managed to convert the information into a survey, but the questions are empty (the survey only have questions and no information).

Please assist on how I can get the information into the survey form, and be able to analyze and produce reports.

Regards

Nkateko

[ZacharySutherby · Accepted solution]

Hello @NkatekoMARIMA, 

You will need to append your existing data to your ArcGIS feature service that was created when you published your survey. 

You can append data directly from the item details page of the feature service, or by using the append geoprocessing tool in ArcGIS Pro. 

[NkatekoMARIMA]

Hello Zach

The data does not have location. I created a Hosted Table in ArcGIS Online. When I try to create a survey in ArcGIS connect, I got an error when publishing "the survey sheet is either empty or missing important column headers".

In short, there was no feature service that was created. 

Regards

Nkateko

[NkatekoMARIMA]

Hello Zach

I got it right after creating the survey from the Web. I created a shapefile for the data and zip it. I then appended the data to the Hosted Feature Service on ArcGIS Online.

Thank you 

Nkateko