Convert POR to SQLITE

Turn POR files into SQLITE. A SQLite database with one table named data and one column per variable.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Your SPSS data as a SQLite table.One table named data, one column per variable.

  1. What you get

    A SQLite database in one file. It holds a single table named data, and each variable in the POR file becomes a column. Variable names, numbers and text are kept as stored.

    Numeric variables shown without decimals become integer columns when every value is whole. Other numbers become doubles, and text variables become text columns. Missing numbers are left NULL.

  2. Dates and times

    SPSS date, time and date-time formats become dates and times in the table. They are stored as text, such as 2024-02-03 for a date and 2024-02-03 09:15:00 for a date-time.

  3. What it leaves behind

    Variable labels, value labels and missing-value definitions are dropped. A code such as 9 for no answer stays an ordinary value in its column, so you need to handle it yourself in your queries.

    Only the data comes across. The descriptive text that SPSS attaches to variables and values is not in the database.

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

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data

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

terminal
$ cv convert report.por report.sqlite
$ cv convert report.por report.sqlite

Questions.What people ask about POR to SQLITE.

01OF 04

The table is named data. It is the only table in the file.

One file. The whole database is a single SQLite file.

No. Value labels are dropped, so a coded answer stays as its stored number or text.

As text. A date looks like 2024-02-03, and a date with a time looks like 2024-02-03 09:15:00.

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