- 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.
4. The SPSS file then appears with all of your raw data and variables included for your analysis.