SPSS files downloaded from the Survey Monkey platform do not conform well with Displayr's recommended SPSS file specifications, and there are no options in Survey Monkey to change the format. There is a separate routine in Displayr's automatic survey data file setup which tries to detect the Survey Monkey format and set up the file according to the patterns that have been identified in Survey Monkey files.
If you import an SPSS (*.sav) file from Survey Monkey 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 Survey Monkey 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 Survey Monkey 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.
Please note that you will need a Displayr license to import data from Survey Monkey.
Problems in the Survey Monkey SPSS Format
No missing values in multiple-response questions
Survey Monkey 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 Survey Monkey 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 Survey Monkey 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