Update Feature Service directly from Excel Spreadsheet

265
4
02-24-2020 06:18 AM
SharitaUnderwood
New Contributor

Is there a way to update a feature service directly from a spreadsheet? I've been looking into Survey123 which has potential but requires users to have to submit results one at a time with page refreshing in between, which is a bit tedious. Was wondering if there was a way to submit results (including location) directly into a spreadsheet which will then update the feature service, or a way to update a spreadsheet and autofill a survey for each entry.

0 Kudos
4 Replies
DougBrowning
MVP Notable Contributor

You would need to turn them into features first.  Then you can use Append.  Note none of your rules or calculations will be in effect.  So do this very carefully and make a backup first.

0 Kudos
SharitaUnderwood
New Contributor

Thanks! I was thinking about this method. If I were to append the data, I assume the new points would be automatically geocoded using arcgis online's geocoder. Is that correct?

0 Kudos
DougBrowning
MVP Notable Contributor

For sure no on that.  You need to make them features manually.  Nothing is automatic here.

0 Kudos
SharitaUnderwood
New Contributor

Okay, thank you Doug. I appreciate your help.

0 Kudos