Login/Register
How to open spss data files in Excel?
Asked Answered
excelspss
G

8

29

I want to open spss .sav data files in Excel without opening the spss files (I don't want to convert spss data file into Excel file). I know this is possible using OLDB connection, but I don't know how to do this.

Gershwin answered 1/3, 2013 at 4:38 Comment(0)
A
26

I converted sav to csv online: http://pspp.benpfaff.org/

Aerospace answered 8/3, 2015 at 23:22 Comment(1)
This is perfect for me. I want to analyse in R but there is a never a good way to view the labels. Especially the dictionary output is great! – Brickle
B
13

In order to download that driver you must have a license to SPSS. For those who do not, there is an open source tool that is very much like SPSS and will allow you to import SAV files and export them to CSV.

Here's the software

And here are the steps to export the data.

Bandy answered 31/1, 2014 at 22:35 Comment(0)
P
13

(Not exactly an answer for you, since do you want avoid opening the files, but maybe this helps others).

I have been using the open source GNU PSPP package to convert the sav tile to csv. You can download the Windows version at least from SourceForge [1]. Once you have the software, you can convert sav file to csv with following command line:

pspp-convert <input.sav> <output.csv>

[1] http://sourceforge.net/projects/pspp4windows/files/?source=navbar

Prompt answered 26/8, 2015 at 8:20 Comment(3)
Tried but does not work. I tried "pspp-convert quicksave foo", "pspp-convert quicksave foo -O csv", "pspp-convert quicksave.sav foo.csv", "pspp-convert quicksave.sav foo -O csv". Always gives me an error like "quicksave : no such file directory" or "quicksave.sav is not a system file or a portable file" or "foo : cannnot guess output format" – Mitsue
Thank you. Very fast. I tried the steps as described in the answer by Ameet but this (a GUI-equivalent) did not complete for some reason. – Falcone
Thank you very much for this helpful answer! To add, you can use chocolatey on Windows to instantly install PSPP: choco install pspp – Ballad
A
5

I help develop the Colectica for Excel addin, which opens SPSS and Stata data files in Excel. This does not require ODBC configuration; it reads the file and then inserts the data and metadata into your worksheet.

The addin is downloadable from http://www.colectica.com/software/colecticaforexcel

Alanis answered 24/4, 2015 at 17:10 Comment(1)
seems nice but it is pricy – Mitsue
P
3

You can do it via ODBC. The steps to do it:

  1. Install IBM SPSS Statistics Data File Driver. Standalone Driver is enough.
  2. Create DNS via ODBC manager.
  3. Use the data importer in Excel via ODBC by selecting created DNS.
Perlaperle answered 3/3, 2013 at 8:5 Comment(0)
L
3

You can use online converter, developed by me at N'counter.

This is the easiest way to open SPSS file in Excel.

1) You just have to upload your file to SPSS coN'verter at https://secure.ncounter.de/SpssConverter

2) Select some options

3) And your converted Excel file will be downloaded

No information about your file contents is retained on our server. The file travels to our server, is converted in-memory, and is immediately discarded: We don't peer into your data at any time!

Latticework answered 1/12, 2017 at 19:31 Comment(6)
OP specifically said they don't want to convert it into an excel file – Pedestrianism
@NickA, did you read other answers? Frankly, it looks like suppression. IMHO there are no way to open and work with SPSS file directly from Excel. Each resolution means some kind of convertion spss file data into Excel native format. – Latticework
no I didn't read them, your answer came up in review, so I reviewed it, nothing more – Pedestrianism
Does not work. I tried to convert a .sav file but i get "We're very sorry we could not convert the file". – Mitsue
That was particular case related to the browser you have used. Now this bug is fixed and you can try again. Sorry for inconvenience. – Latticework
This works perfectly! My file came out exactly as I needed it and give me both the var name and label which was the piece I needed the most! – Falito
G
0

I tried the below and it worked well,

Install Dimensions Data Model and OLE DB Access

and follow the below steps in excel

Data->Get External Data ->From Other sources -> From Data Connection Wizard -> Other/Advanced-> SPSS MR DM-2 OLE DB Provider-> Metadata type as SPSS File(SAV)-> SPSS data file in Metadata Location->Finish

Gershwin answered 14/3, 2013 at 4:0 Comment(0)
E
0

To convert SPSS file to Excel and vice versa!, online:

https://secure.ncounter.de/spssconverter

It's cool. I used it when I didn't access to SPSS.

Evered answered 3/6 at 14:8 Comment(1)
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review – Spoonfeed

© 2022 - 2024 — McMap. All rights reserved.