Skip to content

Instantly share code, notes, and snippets.

@snurhussein
Last active October 31, 2021 23:49
Show Gist options
  • Save snurhussein/008dbe9858b12235f0d5 to your computer and use it in GitHub Desktop.
Save snurhussein/008dbe9858b12235f0d5 to your computer and use it in GitHub Desktop.
Using PSPP to convert sav files to csv

#Converting SPSS files to csv with PSPP#

Install and open PSPP Use the File menu to open your file (it probably has a .sav extension) Go to File>New>Syntax to open PSPP's command line window

Enter:

SAVE TRANSLATE
  /OUTFILE="path/newcsvfile.csv"  //location for your new file
  /TYPE=CSV
  /FIELDNAMES       //optional command to insert fieldnames in the top row
  /CELLS=LABELS.     //optional command specifying to export "labels" from the SPSS codebook (e.g. excellent). Change "labels" to "values" for value reponses (e.g. "5" for "excellent")

RUN

@xlxs4
Copy link

xlxs4 commented May 11, 2021

Sorry to jump in on this, but you can follow something like this, and export to .csv from within Excel (and I would guess OpenOffice, etc.)

@snurhussein
Copy link
Author

Thanks @xlxs4 and sorry @RobotimusPrimed. I really have no idea what could be causing this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment