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.
Variable Types
The following table shows the variable type matching between the original data in IBM® SPSS® Statistics and the exported data in Excel.
| IBM SPSS Statistics Variable Type | Excel Data Format |
|---|---|
| Numeric | 0.00; #,##0.00; ... |
| Comma | 0.00; #,##0.00; ... |
| Dollar | $#,##0_); ... |
| Date | d-mmm-yyyy |
| Time | hh:mm:ss |
| String | General |