Saving data files in Excel format

You can save your data in one of three Microsoft Excel file formats. Excel 2.1, Excel 97, and Excel 2007.

• Excel 2.1 and Excel 97 are limited to 256 columns; so only the first 256 variables are included.
• Excel 2007 is limited to 16,000 columns; so only the first 16,000 variables are included.
• Excel 2.1 is limited to 16,384 rows; so only the first 16,384 cases are included.
• Excel 97 and Excel 2007 also have limits on the number of rows per sheet, but workbooks can have multiple sheets, and multiple sheets are created if the single-sheet maximum is exceeded.

Options

• For all versions of Excel, you can include variable names as the first row of the Excel file.
• For Excel 97 and later versions, you can write either variable names or labels. For variables without defined variable labels, the variable name is used.
• For Excel 2007 and later versions, you can specify a sheet name. You can also append a sheet to an existing file.

Variable types

The following table shows the variable type matching between the original data in IBM® SPSS® Statistics and the exported data in Excel.