Exported data to Excel is shows "choices" instead of answers

330
1
03-12-2024 10:27 AM
ChanelleDavis
New Contributor

When I export my data from Survey 123 to Excel, certain fields only "Choices o,1,2 etcetera in stead of the actual data

0 Kudos
1 Reply
abureaux
MVP Frequent Contributor

That is most likely your choices "name". S123 database likes to store items as names rather than labels. If you made your survey in the Web App, I am not sure if you can even change a choice's name, so those may be the default if that is the case.

I find creating meaningful names is helpful, and tend to abide by these rules:

  • Letters, numbers, and underscores only
  • No spaces
  • Short descriptive text that relates to the choice being made
  • Never use meaningless codes that need to be deciphered (ironic example being "choice1")

Technically select_one can have spaces in the name, but select_multiple can't. I prefer consistency. And some of my label are rather large, so I don't bother with 1:1.

0 Kudos