Convert SAV to PARQUET

Turn SAV files into PARQUET. A Parquet table with one column per variable.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SAV files on the dialor turn it to pick what to do

A Parquet table with one column per variable.Numbers, text and dates keep their types. The labels stay behind.

  1. What you get

    One Parquet file with one column per variable in the SAV file. Variable names, numbers and text are kept as stored, and missing numbers are left empty.

    Numeric variables shown without decimals become integer columns when every value is whole. Other numbers become doubles, and text becomes text strings.

    SPSS date, time and date-time formats become dates and times in the Parquet table, not plain numbers.

  2. What it leaves behind

    Variable labels, value labels and missing-value definitions are dropped. Parquet keeps the names and the values, not the descriptions that SPSS attaches to them.

    A code such as 9 for no answer stays an ordinary value. It is no longer marked as missing, so count or filter it yourself after the conversion.

    If you need the labels, keep the original SAV file next to the Parquet file. To go the other way, use PARQUET to SAV.

SAV and PARQUET.What each format is.

The formats

From · SAV

SPSS Data

SPSS data files with variable labels and value labels.

Extensions
.sav .zsav
MIME type
application/x-spss-sav
Kind
Text and data
To · PARQUET

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

In your code.The same SAV to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.sav report.parquet
$ cv convert report.sav report.parquet

Questions.What people ask about SAV to PARQUET.

01OF 04

Yes. The Parquet table has one column per variable, and the variable names are kept as stored.

Yes. SPSS date, time and date-time formats become dates and times in the Parquet file.

No. Value labels are dropped, so a coded value stays as its number or text. Variable labels are dropped as well.

Missing numbers are left empty. The missing-value definitions from SPSS are dropped, so a code such as 9 for no answer stays an ordinary value.

More conversions.Other ways in and out of SAV and PARQUET.