Convert POR to NUMBERS

Turn POR files into NUMBERS. One sheet named Data with the variable names as a bold header row and numbers as number cells.

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 in a Numbers sheet.One sheet holds your variables as columns, with a bold header row.

  1. What you get

    A Numbers spreadsheet with one sheet named Data. The variable names become a bold header row, and the values below it are number cells, so you can sort and calculate on them right away.

    The output is one file.

  2. What it leaves behind

    Value labels, variable labels and missing-value definitions are dropped. Coded answers stay as numbers, so a column of 1s and 2s stays 1s and 2s instead of turning into the words they stood for in SPSS.

    Numbers keep 15 significant digits. Fonts that Numbers does not have become Helvetica Neue.

  3. Size limit

    A document of more than 300,000 cells fails with unsupported_elements. The conversion stops with that code when the data goes past that count.

    For other conversions to the same format, see every NUMBERS conversion.

POR and NUMBERS.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 · NUMBERS

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents

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

terminal
$ cv convert report.por report.numbers
$ cv convert report.por report.numbers

Questions.What people ask about POR to NUMBERS.

01OF 04

No. Value labels are dropped, so coded answers show as numbers. Keep your SPSS codebook if you need to know what each code means.

Yes. They become the bold header row on the Data sheet. Variable labels, the longer descriptions, are dropped.

Numbers keep 15 significant digits. Values with more digits than that are not kept past that point.

The data has more than 300,000 cells. A file over that size is not converted.

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