Convert POR to JSON

Turn POR 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 POR files on the dialor turn it to pick what to do

SPSS data as plain JSON.One object per case, keyed by variable name, in a single JSON file.

  1. What you get

    A JSON array with one object per case. Each object uses the variable names from the POR file as its keys, so a row of survey answers becomes one record you can read in any program that handles JSON.

    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 a column is not turned back into the text it stood for.

    If you need those meanings, keep the codebook from the original file. The JSON holds the values only.

  3. Working with the result

    The output is one file. To learn more about the format, see every JSON conversion. To combine several results into one file, you can merge JSON.

POR and JSON.What each format is.

The formats

From · POR

SPSS Portable

SPSS portable files, the plain-text exchange format of older SPSS versions and PSPP.

Extensions
.por
MIME type
application/x-spss-por
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 POR to JSON conversion through the API, for your app or your agent.

terminal
$ cv convert report.por report.json
$ cv convert report.por report.json

Questions.What people ask about POR to JSON.

01OF 04

One case from the POR file. Its keys are the variable names, and its values are that case's answers.

As null. Numbers are written as decimals, such as 34.0.

No. Value labels, variable labels and missing-value definitions are dropped, so coded answers stay numbers.

No. There are no options to set, and the result is one JSON file.

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