Free online SAV to XLS converter

A reporting system, colleague, or older office installation may require an Excel workbook instead of an SPSS dataset. Converting the file makes its tabular values easier to inspect and edit without SPSS Statistics.

What the SAV format is

.sav is primarily the native data-file format of IBM SPSS Statistics. It stores case data along with variable names, labels, measurement levels, value labels, missing-value definitions, display formats, and other statistical metadata. GNU PSPP can open and save many SPSS-compatible SAV files.

SAV files are common in survey research, clinical studies, academic analysis, market research, and government statistics. Excel and LibreOffice Calc do not reliably open them as ordinary spreadsheets, because SAV is a statistical data format rather than a general-purpose workbook.

What the XLS format is

.xls is the binary Excel 97–2003 workbook format. It is appropriate when the recipient or an older application accepts XLS but does not support the newer .xlsx format.

An XLS workbook can contain worksheets, rectangular tables, formatting, formulas, filters, and charts. Each worksheet is limited to 65,536 rows and 256 columns, so large SAV datasets may need XLSX, CSV, or multiple output files.

How to convert SAV to XLS

Using IBM SPSS Statistics

1. Open the file with File → Open → Data.
2. Inspect the Data View and Variable View for incorrect missing values, dates, string lengths, labels, and decimal formats.
3. Use File → Export and choose an Excel output type. Depending on the SPSS version, the same function may be available through File → Save As.
4. Select Excel 97-2003 (*.xls), specify the output filename, and complete the export.
5. Open the result in Excel or LibreOffice Calc and compare the row count, column names, dates, missing values, and representative numeric values with the original SAV file.

SPSS may offer export options for variable names, labels, and worksheets. Select the option that matches the intended report, and retain the original SAV file because XLS is not a replacement for the statistical data dictionary.

Using 101convert.com

On 101convert.com, select the SAV-to-XLS converter, upload the .sav file, start the conversion, and download the generated .xls file. This option requires no installed statistical software and is available for free. Do not upload confidential, regulated, or personally identifiable data unless the service's data-handling terms satisfy your requirements.

Using Python for repeatable exports

For scripted conversion, pyreadstat reads SPSS files and xlwt writes the older XLS format:

pip install pyreadstat xlwt

import pyreadstat
import xlwt

frame, metadata = pyreadstat.read_sav(
    "input.sav",
    apply_value_formats=False
)

book = xlwt.Workbook()
sheet = book.add_sheet("Data")

for column, name in enumerate(frame.columns):
    sheet.write(0, column, name)

for row, values in enumerate(frame.itertuples(index=False, name=None), start=1):
    for column, value in enumerate(values):
        sheet.write(row, column, value)

book.save("output.xls")

Setting apply_value_formats=False keeps the stored SPSS values, such as numeric category codes. Setting it to True exports formatted value labels instead, which can change the values used for later analysis. This script does not reproduce SPSS variable labels, measurement levels, user-missing definitions, syntax, or other dictionary metadata.

Quality and compatibility limits

Only the spreadsheet-like portion of an SAV file transfers cleanly. Variable labels, measurement levels, user-defined missing values, multiple-response definitions, custom tables, formats, syntax, and some date or currency representations may be lost or changed.

Check whether categorical fields contain numeric codes or displayed labels after conversion. Also verify the distinction between blank cells, system-missing values, and user-defined missing codes before using the workbook for reporting or analysis.

If the data exceeds the XLS row or column limits, use .xlsx, CSV, or several XLS files. Keep the original SAV file with its metadata; an XLS workbook cannot preserve the full SPSS data dictionary or guarantee identical results in statistical procedures.