User Guide

52
Chapter 3
The modified data file is saved, overwriting the previous version of the file.
Saving Data
Files in Excel Format
You c an s ave
your data in one of three Microsoft Excel file formats. The choice of
format depends on the version of Excel that will be used to open the data. The Excel
application cannot open an Excel file from a newer version of the application. For
example, E
xcel 5.0 cannot open an Excel 2000 document. However, Excel 2000
can easily read an Excel 5.0 document.
There are a few limitations to the Excel file format that don’t exist in SPSS. These
limitatio
ns include:
 Var ia bl e
information, such as missing values and variable labels, is not included
in exported Excel files.
 WhenexportingtoExcel97andlater,anoptionisprovidedtoincludevalue
labels instead of values.
 Because all Excel files are limited to 256 columns of data, only the first 256
variables
are included in the exported file.
 Excel 4.0
and Excel 5.0/95 files are limited to 16,384 records, or rows of data.
Excel 97–2000 files allow 65,536 records. If your data exceed these limits, a
warning message is displayed and the data are truncated to the maximum size
allowed b
yExcel.
Varia b le Types
The following table shows the variable type matching between the original data in
SPSS and t
he exported data in Excel.
SPSS 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