Convert QIF to PARQUET

Turn QIF files into PARQUET. Every transaction of the bank, cash, credit card and other asset or liability accounts gives a row with the account's name, the date, the amount, the payee, the memo, the check number and the category, and the categories of split lines are joined when the transaction names none.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Bank transactions as a table you can query.Each QIF transaction becomes one row with typed columns.

  1. What you get

    A single PARQUET file. Every transaction from your bank, cash, credit card and other asset or liability accounts gives one row.

    Each row holds the account's name, the date, the amount, the payee, the memo, the check number and the category. When a transaction names no category but has split lines, the categories of the split lines are joined into the category column.

  2. How columns are typed

    The table has a column for each key of the JSON conversion. Types come from the values. Dates become dates, amounts and balances become numbers, and the other columns are text.

  3. What it leaves out

    QIF holds no currency, so the table has no currency column. Amounts are plain numbers.

    Investment transactions are left out. Only the account types listed above produce rows.

QIF and PARQUET.What each format is.

The formats

From · QIF

Quicken QIF

Quicken Interchange Format, the plain-text list of transactions with dates, amounts, payees and categories that Quicken, Microsoft Money and many banks export.

Extensions
.qif
MIME type
application/x-qif
Kind
Text and data
To · PARQUET

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

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

terminal
$ cv convert report.qif report.parquet
$ cv convert report.qif report.parquet

Questions.What people ask about QIF to PARQUET.

01OF 04

Bank, cash, credit card and other asset or liability accounts do. Investment accounts do not, and their transactions are left out.

No. Dates become dates in the PARQUET file. Amounts and balances become numbers, and the other columns are text.

If the transaction names a category, that category is used. If it names none, the categories of the split lines are joined into one value.

No. QIF holds no currency, so none is written.

More conversions.Other ways in and out of QIF and PARQUET.