Importing an Excel File
- Open SPSS and click File.
- Click Open.
- Click Data. The open data window will appear.
- In the Files of type: list select Excel (*.xls, *.xlsx, *.xlsm) to specify that your data is an Excel file. If you do not specify the type of file that you wish to open, your file will not appear in the list of available files.
- Locate and click on the file you want to import.
- The file name will appear in the File name: text box. Click Open. The Opening Excel Data Source window will appear.
- If your variable names are in the first row of data, select the Read variable names from the first row of data check box.
- In the Worksheet: list, select the sheet (from your Excel workbook) that contains your data. (If you have not assigned names to the sheets in your Excel workbook, the labels you see here will usually be Sheet1, Sheet2, Sheet3, etc.) You can only import one sheet from your Excel file at a time.
- You may also specify the range and maximum width for string columns if you wish. It is suggested to keep the default value unless you have a reason for altering it.
- Click OK when you are finished.