CODEWITHSUNDEEP
excelcsvexportspss
valeria91
valeria91

Reputation: 11

Open .sav file in excel after converting it to .csv online

I am trying to process a data base, which is in .sav format, on excel. I have converted sav to csv online: through http://pspp.benpfaff.org/ but I get csv text, not a file.

How can I import this into excel so that it reads it as columns? otherwise I have the text in commas.

Thank you!

Upvotes: 1

Views: 17594

Answers (1)

Michael
Michael

Reputation: 11

I have found the easiest method after online conversion is to save the resulting text as a .txt file. From there you will open Excel-->File-->Import

If your data has headers you will select that option, but the main thing is to set the delimiter as comma and then hit finish. It should retain the data structure initially found in your SPSS file.

Upvotes: 1

Related Questions