Why are "none of the above" answers blank in exported data? | XM Community
Skip to main content

I have exported the data from a survey to .csv and opened in Excel. I have several questions that had a "none of the above" option, but respondents who selected this choice just have a blank cell in the spreadsheet. When I open individual responses in the Data & Analysis tab online, I can see that they marked none of the above. I need to be able to distinguish between active "none of the above" selections and missing data. Any ideas?

When you add none of the above to the list of answers, Qualtrics sets to "exclude from analysis" by default. Did you uncheck that?


Thank you, I was not aware of this default. Is it possible to change that setting retroactively for the responses already received?


If its in the PDF, you should be able to get the data. Just disable it and download the csv again.


Leave a Reply