Skip to main content
XLSTAT is joining the Lumivero family. Learn more.

How to import SPSS and other data file formats

This tutorial explains how to import data into Excel from other sources, such as SPSS, using the XLSTAT-R engine.

For this purpose, we will use the Foreign File Formats feature developed in XLSTAT-R. This feature selects a function from the foreign R package (R Core Team) depending on the type of data we want to import and then calls that function. Here, our goal is to import an SPSS (.sav) file so the read. spss R function will be called.

Setting up the Foreign File Formats dialog box

Once XLSTAT is open, select the XLSTAT-R / formats / foreign file format command as shown below:

Choose foreign file formats from the XLSTAT-R menu

The foreign file format dialog box appears. Select SPSS in the Format field and click OK to continue.

Choose the type of format in the XLSTAT dialog box

A new window appears. Select the data file from your computer and click Open.

downloads.PNG

Output

The data are now imported into a new Excel sheet. Variables are stored into columns and headers into the first row of the data table. On the top of the sheet, you can use the action buttons to relaunch the procedure or import a new data file as well as to copy-paste the table into Word/PowerPoint.

results.PNG

Going further

You can follow the same steps to import data stored by other software such as Minitab, SAS and Stata.

Was this article useful?

  • Yes
  • No
Home

A complete statistical add-in for Microsoft Excel