Thursday 10 August 2017

Processing Survey Data using Excel for Import into SPSS

Hi All,

Here is a video that I have recently made on my process for getting surveymonkey data into SPSS via Excel.

There are a number of general steps illustrated, laying out the worksheets, coding questions that have mixed text and numeric answers and formatting for export to SPSS.

Near the end of the video I demonstrate the quick way to set up an SPSS data file using names autogenerated in Excel and then copy/paste the formatted data into the worksheet.