April 10th, 2006 andris
This weekend we got a question from Zakya, who desperately needs information on how to import Excel data into SPSS.
Actually, importing from SPSS is not that hard at all. But before you import, there are some steps to take to make importing more easy:
- Close the Excel file (otherwise SPSS will give an error message)
- Make a header row in Excel with column names (keep them brief and descriptive)
- Do not mix up numbers and text in the same column
In SPSS, select Open -> File from the menu. In the Open file dialog, select Excel file as file type. Browse to the right directory and select the Excel file. Click Open. After this, you will get a new dialog (Hurray!) “Opening Excel Data Source”. If you have made a header row with column names, check the box “Read variable names from the first row of data”. If you do not have other irrelevant data in your Excel file, just click OK. Otherwise select the right worksheet and range, and click OK. If everything went allright, you now have your data in SPSS. Now you can start adjusting the Variables to the right types etc.