#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
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")
I used your code (TY) to convert the NSSE files from sav to csv, however, now there are multiple problems and I am not sure if I can trust the conversion. Several columns that were numbers came in as custom columns and changed to dates. Other columns came in with a number, with the value label, and both, and some, the digit in sav file was converted to a word in the csv such as 1, one. Any suggestions?