Your data analysis solution

Importing SPSS and other data file formats into Excel

2018-06-27

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.

Dataset

The data file used in this tutorial can be downloaded by clicking on the button below:
Download the data

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.  

Select the data file from your computer

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.

XLSTAT output after importing an SPSS data file

Going further

You can follow the same steps to import data stored by other software such as MinitabSAS and Stata

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9202