Still having trouble with long list

[KaraGrady]

Still having trouble uploading my 2000 option list as a CSV file into Survey123. I have it uploaded as both a hosted table and a CSV file in my ArcGIS content, but when I go into Survey123 to upload it as a list for the dropdown menu, nothing shows up. Trying to make it public access hasn't helped. 

[abureaux]

Is there any way you can provide the CSV and XLSX files either on the forms of in a PM? If not, I'd recommend calling Esri Support for help. It's hard to say what's wrong without seeing the files.

One thing to try. If you cut out 1900 lines from the CSV, save it, and use that file, does it magically work? If not, then the issue is either a poorly formatted CSV, or improperly referenced external CSV in the XLSX. If it does work, then it may still be an improperly formatted CSV, but the issue is in one of the lines you deleted.

[KaraGrady]

[KaraGrady]

I also saved it as an CSV UTF-8

[abureaux]

Have you tried simplifying the items in the name column to remove all special characters? (Select that one column > press Ctrl+F > go to the Replace tab > replace all '*' with '_' for instance).

Edit. And I meant to add, is it possible to upload the actual CSV and XLSX files?

[KaraGrady · Accepted solution]

A coworker of mine figured it out, you need to have it in as a feature layer with location data, it won't accept it without location data.

[abureaux]

That sounds odd for just a drop down. I have several large drop down CSVs that all work without location data. Location data isn't an explicit requirement for external selects.