SPSS files downloaded from the SurveyMonkey platform do not conform well to Displayr's recommended SPSS file specifications, and there are no options in SurveyMonkey to change the format. There is a separate routine in Displayr's automatic survey data file setup that tries to detect the SurveyMonkey format and set up the file according to the patterns that have been identified in SurveyMonkey files.
If you import an SPSS (*.sav) file from SurveyMonkey and you get a poor result, like variables from multiple response questions not being grouped as variable sets or blank labels in tables, then please contact us at support@displayr.com. If SurveyMonkey has altered the format of its data files, then we can incorporate this information into Displayr's setup routine. We may also be able to provide you with a QScript to help you set up your data.
Note that you need to have an Advantage SurveyMonkey account (or higher) to be able to obtain SPSS files. Lower-level accounts allow for Excel-style survey data files, but these are of poor quality for use in Displayr, and additional setup may be required. See How to Set Up Files With No Metadata for more on how to do this.
Problems in the SurveyMonkey SPSS Format
No missing values in multiple-response questions
SurveyMonkey does not record missing values in multiple-response (Binary - Multi) questions. This means that if a respondent skips a question, then there is no way for any software to be able to distinguish that respondent from one who simply did not select any of the options in the question. To tackle this, Displayr will attempt to detect multiple response questions where some respondents have not given answers and create a new copy of the question where the variables are rebased to the sample who have at least one answer.
If you need to rebase the question later, see How to Rebase a Table in Displayr. The original variables remain in your project at the bottom of the Data Sources tree. They will be marked as hidden and will have the extra label: Original Data (Incorrectly Set Up).
Poor labeling of multiple-response questions
The Variable Labels for multiple-response (Binary - Multi) questions don't contain information about which survey option the variable refers to. This information is instead stored in the Value Attributes for the question. When Displayr detects a SurveyMonkey file, it will copy this information into the variable labels.
No question text for grid questions
The variables for grid questions, like Nominal - Multi and Binary - Grid, do not store any information about what question was asked in the survey. This information is entirely absent from the file. As a result, when Displayr detects a SurveyMonkey file, it will name grid questions with their question number and the first three rows and column labels from the grid. To give your question a better name, right-click on the variable set in the Data Sources tree and select Rename.
Next
How to Import Data by Connecting to an SQL Database