Import data from an Excel file

May 3rd, 2006 andris

First refer to Importing data into SPSS. If you have read it, than you can continue below.
Before you start the actual import process, please keep in mind that the Excel file should not be opened in Excel.

1. Select File -> Open -> Data
2. Choose Excel as the File Type
3. Select the file you want to import and click Open

 

4. The next thing that will pop up is a screen called Opening Excel Data Source. If you use a header row, than tick the option Read variable names from the first row of data. Select the right worksheet you want to import from (the same as the tabs in Excel). If you have no clue, leave it as is. It will probably select the right one automatically. If you do not want to import the whole worksheet, you can use the field Range to define the cells you want to import, otherwise just leave empty. Click OK.

SPSS will automatically determine the type of each variable, so after you clicked OK, you are ready!

Entry Filed under: 1. Getting data into SPSS, Questions and answers