blocks|key|149971|text|要下载该驱动程序，您必须有SPSS许可证。对于那些不这样做的人，有一个开源工具，它非常类似于SPSS，允许您导入SAV文件并将其导出为CSV。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|149972|这是the+software|offset|length|149973|这是the+steps+to+export+the+data。|149974|entityMap|0|LINK|mutability|MUTABLE|url|http://www.gnu.org/software/pspp/|1|http://lists.gnu.org/archive/html/pspp-users/2011-11/msg00033.html^0|0|2|C|0|0|2|S|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

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 <a href="http://www.gnu.org/software/pspp/">the software</a>

And here are <a href="http://lists.gnu.org/archive/html/pspp-users/2011-11/msg00033.html">the steps to export the data</a>.

blocks|key|149992|text|我将sav转换为csv+online：http://pspp.benpfaff.org/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|149993|entityMap|0|LINK|mutability|MUTABLE|url|http://pspp.benpfaff.org/^0|J|P|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I converted sav to csv online: <a href="http://pspp.benpfaff.org/">http://pspp.benpfaff.org/</a>

blocks|key|150024|text|我帮助开发Colectica+for+Excel插件，它在Excel中打开SPSS和Stata数据文件。这不需要ODBC配置；它读取文件，然后将数据和元数据插入到工作表中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150025|该插件可从http://www.colectica.com/software/colecticaforexcel下载|offset|length|150026|entityMap|0|LINK|mutability|MUTABLE|url|http://www.colectica.com/software/colecticaforexcel^0|0|5|1F|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

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
<a href="http://www.colectica.com/software/colecticaforexcel" rel="nofollow">http://www.colectica.com/software/colecticaforexcel</a>

blocks|key|368417|text|(这对你来说不是一个确切的答案，因为你想避免打开文件，但这可能会对其他人有所帮助)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|368418|我一直在使用开源GNU+PSPP包将sav磁贴转换为csv。至少可以从SourceForge+1下载windows版，安装软件后，可以通过以下命令行将sav文件转换为csv文件：|368419|pspp-convert+<input.sav>+<output.csv>|code-block|syntax|javascript|368420|1|offset|length|368421|entityMap|0|LINK|mutability|MUTABLE|url|http://sourceforge.net/projects/pspp4windows/files/?source=navbar^0|0|0|0|0|1|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

(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:

<pre><code>pspp-convert &lt;input.sav&gt; &lt;output.csv&gt;
</code></pre>

[1] <a href="http://sourceforge.net/projects/pspp4windows/files/?source=navbar" rel="noreferrer">http://sourceforge.net/projects/pspp4windows/files/?source=navbar</a>

blocks|key|150098|text|你可以使用我在N'counter开发的在线转换器。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|150099|这是在Excel中打开SPSS文件的最简单方法。|150100|1)你只需要上传你的文件到https://secure.ncounter.de/SpssConverter的SPSS+coN‘’verter|150101|2)选择一些选项|150102|3)，您转换后的Excel文件将被下载|150103|我们的服务器上不会保留有关您的文件内容的任何信息。文件传输到我们的服务器，在内存中转换，然后立即丢弃:我们在任何时候都不会窥视您的数据！|150104|entityMap|0|LINK|mutability|MUTABLE|url|http://secure.ncounter.de/|1|https://secure.ncounter.de/SpssConverter^0|7|9|0|0|0|D|14|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|17|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|18|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|19|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]|V|$5|Q|R|S|C|$T|W]]]]

You can use online converter, developed by me at <a href="http://secure.ncounter.de" rel="nofollow noreferrer">N'counter</a>. 

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

1) You just have to upload your file to SPSS coN'verter at <a href="https://secure.ncounter.de/SpssConverter" rel="nofollow noreferrer">https://secure.ncounter.de/SpssConverter</a> 

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!

I want to open spss <code>.sav</code> 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.

How to open spss data files in Excel?

服务器

我想在Excel中打开spss .sav数据文件而不打开spss文件(我不想把spss数据文件转换成Excel文件)。我知道使用OLDB连接可以做到这一点，但我不知道怎么做。

问如何在Excel中打开spss数据文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Excel中打开spss数据文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Excel中打开spss数据文件？
EN