How to Quickly Transfer Data from Excel to SPSS for Analysis

  1. To quickly merge your Excel raw data into an SPSS file, open your SPSS program and go to the FILE option and drop down to IMPORT DATA to select EXCEL data. (Note: you need to ensure your EXCEL data file consists of raw numbers with variable names in the first row to ensure easy transition of variables and data into SPSS.)

2. After selecting EXCEL, the file popup appears and you then go to your file containing the EXCEL data or type in the file name in the file name box and then select OPEN.


3. The READ EXCEL BOX then automatically appears and you want to keep all boxes checked, preview how the data looks and then if it appears accurate click OK.

4. The SPSS file then appears with all of your raw data and variables included for your analysis.