XLSTAT: How to import SPSS and Other Data File Formats in Excel

 

The XLSTAT-R engine allows a user to import data into Excel from other sources, such as SPSS.

For the purpose of an example, 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.

We will use this feature 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:

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

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

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.

Other Software

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