We can import data from Excel (or other databases).
Before we import make sure the data in Excel is in one table and laid out in the same way as in SPSS’ Data View (variables as the columns, the column’s order, etc)
then…from SPSS Aplication:
File > Open > Data …..> choose “*.xls” and
on the panel, define the Worksheet, Range, and thick ‘Read variable names from the first row of data’ if we want to import the Headings as well.
Then..check on the ‘Variable view’ maybe there are some properties need to be modified.