How to open spss data files in excel?

2019-02-04 08:48发布

I want to open spss .sav data files in excel without open 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.

Can anyone help me to do this?

Thanks in advance.

标签: excel spss
8条回答
爷、活的狠高调
2楼-- · 2019-02-04 09:23

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.
查看更多
一纸荒年 Trace。
3楼-- · 2019-02-04 09:27

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

查看更多
Evening l夕情丶
4楼-- · 2019-02-04 09:29

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.

查看更多
【Aperson】
5楼-- · 2019-02-04 09:30

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

查看更多
Rolldiameter
6楼-- · 2019-02-04 09:30

(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

查看更多
做个烂人
7楼-- · 2019-02-04 09:36

I also just made a webapp to do this where you can just upload the file: https://rkbarney.shinyapps.io/thisnotthatstat/ upload your .sav and choose .csv and then open in Excel

You could also use the Haven Package in R to transfer to .csv and then open the .csv file in Excel.

查看更多
登录 后发表回答