Convert QIF to XLSX

Turn QIF files into XLSX. 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

Your transactions as rows in a sheet.Each transaction becomes one row with its account, date, amount, payee and category.

  1. What you get

    An XLSX workbook with one sheet, named after the 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.

    The header row is bold and frozen, so it stays in view as you scroll. Its columns are the same as in the CSV conversion.

  2. How values are stored

    Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells, shown with as many decimals as the file wrote.

    Every other column is text. Account numbers and ids keep their leading zeros and all their digits.

    When a transaction is split and names no category of its own, the categories of its split lines are joined into the category column.

  3. What is left out

    Investment transactions are not converted. QIF holds no currency, so the sheet has no currency column. Amounts are numbers only.

    To combine several converted sheets, merge XLSX joins workbooks into one. You can also browse every XLSX conversion.

QIF and XLSX.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 · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

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

terminal
$ cv convert report.qif report.xlsx
$ cv convert report.qif report.xlsx

Questions.What people ask about QIF to XLSX.

01OF 04

Bank, cash, credit card and other asset or liability accounts. Each transaction in them becomes a row, with the account's name in its own column.

No. Investment transactions are left out of the workbook.

Yes. They are date cells shown as YYYY-MM-DD, so you can sort and filter them as dates.

No. Account numbers and ids are stored as text, so the leading zeros and all digits stay.

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