converting SPSS to Excel

[Todd, Alison C.]

Has anyone had success converting SPSS data to Excel?  Please let me know if
there are any tips!  I'm lost!

THANK YOU!

The information transmitted in this electronic communication is intended only
for the person or entity to whom it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or other
use of or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you received this
information in error, please contact the Compliance HelpLine at 800-856-1983 and
properly dispose of this information.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Parry, James]

Unless I'm missing something, you just have the SPSS file open in SPSS and go to File . . . Save as . . . Excel(various version)- if you want the value labels instead of the values exported make sure to check that off.

HTH-

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Todd, Alison C.
Sent: Thursday, May 01, 2008 7:21 AM
To: [hidden email]
Subject: converting SPSS to Excel

Has anyone had success converting SPSS data to Excel?  Please let me know if
there are any tips!  I'm lost!

THANK YOU!

The information transmitted in this electronic communication is intended only
for the person or entity to whom it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or other
use of or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you received this
information in error, please contact the Compliance HelpLine at 800-856-1983 and
properly dispose of this information.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Sara House]

Alison said:
Has anyone had success converting SPSS data to Excel?  Please let me know if
there are any tips!  I'm lost!
If you're working with syntax, you would use SAVE TRANSLATE.  I believe for excel, the basic syntax is:
 
SAVE TRANSLATE
/OUTFILE = 'FILE.XLS'
/TYPE = XLS
/FIELDNAMES . *This adds the variable names to the top row of your spreadsheet.  It isn't required but is very useful, especially for larger data sets.
 
There are other things you can add to this syntax, such as dropping or renaming variables, or giving a name to the worksheet your data will appear on (I believe that if you don't specify, it just makes the name your SPSS file name).  If you look up SAVE TRANSLATE in the Command Syntax Reference, you can get more information on this command.
 
Sara
 
 
 
Sara M. House, M.A.
Adjunct Faculty
Loyola University Chicago, Psychology Department
Email: [hidden email]
Teaching: Research Methods, Psychology & Law

AND

Data Analyst
Chicago Public Schools, Department of Program Evaluation
Email: [hidden email]

====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD