Spreadsheets (SAVE TRANSLATE command)

Variables in the active dataset become columns, and cases become rows in the spreadsheet file.

  • If you specify FIELDNAMES, variable names become the first row.
  • To save value labels instead of data values, use the CELLS subcommand. See the topic CELLS Subcommand (SAVE TRANSLATE command) for more information.
  • System-missing values are translated to #NULL! in Excel files.

IBM® SPSS® Statistics formats are translated as follows:

Table 1. Format conversion for spreadsheets
IBM SPSS Statistics 1-2-3/Symphony Excel
Number Fixed 0.00;#,##0.00;...
COMMA Comma 0.00;#,##0.00;...
DOLLAR Currency $#,##0_);...
DATE Date d-mmm-yy
TIME Time hh:mm:ss
String Label General