Importing Excel file into SPSS
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
3 comments April 10th, 2006 andris