The tutorial was created while I was a teaching assistant for a quantitative analysis course at Claremont Graduate University.Using SurveyMonkey was discouraged because students often had great difficulty exporting the data into SPSS. I created this tutorial to help fellow graduate students and my adviser was kind enough to allow me to use the finish product to fulfil one qualitative exam requirement.

When I started this tutorial there was only one export option. The data was exported into a basic Excel spreadsheet. However, in 2011 SurveyMonkey added an advanced spreadsheet export - a format better suited for statistical software. Because I started creating this tutorial before the advanced spreadsheet option was available, the instructions are for both the basic and the advanced. However, the advanced spreadsheet is a better option as long as the data is in numerical format. I have information about exporting the advanced spreadsheet with numerical values here.

This tutorial is not for the beginning student. I will not show you how to create a survey in SurveyMonkey and a basic knowledge of both SPSS and Excel are needed. The tutorial uses data that was collected specifically for this exercise. The questions were designed for entertainment. In the second section of the tutorial I will show you how to download your own data from SurveyMonkey.

The examples, screen shots, and files were made with Excel 2007 and SPSS 17 but they should work with other versions of both programs.

BEFORE YOU START

Action: Create a folder on your desktop. Name it tutorial

Working with the Basic Spreadsheet Option

Working with the Advanced Spreadsheet Option