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.
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.
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.
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
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
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.
$ cv convert report.por report.json$ cv convert report.por report.jsonQuestions.What people ask about POR to JSON.
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.