Export data and value labels to excel

* (Q) How to export a sav file (with value labels) into Excel 2000.

* (A) Posted to SPSSX-L list by Raynald Levesque on 2002/12/27.
With SPSS 11.5 and above , this is an option in the  File>Save Data menu when you choose Excel 97 format.

If you do not have version 11.5: the following is an alternative method:

1. Open a draft output window

2. List all cases (with value labels) using
SUMMARIZE
  /TABLES=ALL
  /FORMAT=VALIDLIST NOCASENUM TOTAL
  /TITLE='Case Summaries'
  /MISSING=VARIABLE
  /CELLS=COUNT .

3. In the Draft Output: Delete everything except the table of results

4. Use the menu: File> Export> All text

5. Import the txt file into excel