Menu
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.
953
The Colectica for Excel addin for Microsoft Excel allows you to open SPSS (. sav) data files in Microsoft Excel. The addin imports and converts all data, as well as metadata including variable and value labels.
Go to www.spss.com/statistics and click on the DOWNLOADS tab. Notice that you can navigate through the SPSS output the same way as you can with the full version of SPSS. The SAS System viewer is available for free download, but you have to register with SAS Institute, first.
From the menus choose: File > Open > Data... A dialog box for opening files is displayed. By default, IBM® SPSS® Statistics data files (.
I converted sav to csv online: http://pspp.benpfaff.org/
66
(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
24
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.
36
answered Oct 05 '22 18:10
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
