User Guide

33
Reading Data
E
Make sure that Read variable names from first row of data is selected. This option
reads column headings as variable names.
If the column
headings do not conform to the SPSS variable-naming rules, they are
converted into valid variable names and the original column headings are saved as
variable labels. If you want to import only a portion of the spreadsheet, specify the
range of cel
ls to be imported in the Range text box.
E Click OK to
read the Excel file.
Thedatanow
appear in the Data Editor, with the column headings used as variable
names. If you’re using a spreadsheet application other than Excel or Lotus, you should
be able to export your data to a supported format that can then be read into SPSS.
Figure 3-6
Imported Excel data