Convert SAV to JSON

Turn SAV files into JSON. An array with one object per case keyed by variable name, with numbers written as decimals such as 34.0 and empty values as null.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

SPSS data as plain JSON.Each case becomes one object, keyed by variable name.

  1. What you get

    One JSON file holding an array. Each case in the SAV file is one object in that array, and each variable name is a key.

    Numbers are written as decimals, such as 34.0. Empty values are written as null.

  2. What it leaves behind

    Value labels, variable labels and missing-value definitions are dropped. Coded answers stay numbers, so a 1 or a 2 in your data stays a 1 or a 2 in the JSON.

    If you need the meaning of the codes, keep the codebook from the original SAV file alongside the JSON.

  3. When it fails

    A file that cannot be parsed stops the conversion with input_corrupted. This applies to a damaged or incomplete SAV file.

SAV and JSON.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 · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

terminal
$ cv convert report.sav report.json
$ cv convert report.sav report.json

Questions.What people ask about SAV to JSON.

01OF 04

No. Value labels are dropped, so coded answers stay numbers.

Empty values are written as null.

Yes. SAV and ZSAV are both listed as extensions of SPSS Data. The result is one JSON file.

The file could not be parsed. The conversion stops and no JSON is produced.

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