QIF to CSV and Excel
Upload a .qif file and download a CSV — or an Excel workbook — with one row per transaction: date, description and signed amount in their own columns. A QIF is a list of tagged lines rather than a table, so this is the quick way to read it in a spreadsheet, check it before an import, or hand the transactions to someone without Quicken.
Upload a file
What the CSV contains
- A header row, then one row per transaction in the QIF
- Date as YYYY-MM-DD, whatever order the QIF wrote it in
- Payee and memo joined into one Description cell
- A signed amount: money out negative, money in positive, as the QIF has it
- Plain UTF-8 text, readable without Quicken installed
QIF to Excel
Choose Excel instead of CSV in the format menu above and the same rows come out as an .xlsx workbook, amounts stored as numbers you can sum and filter. Opening a .qif in Excel directly gives you one tag per row — D03/04/2026, T-38.40 — not a table.
Going the other way, a spreadsheet into QIF, is the CSV to QIF converter.
How QIF lines become columns
A bank or card QIF holds one block per transaction, ended by a caret:
| QIF line | CSV column | Notes |
|---|---|---|
D | Date | As YYYY-MM-DD. Day-first or month-first is decided for the whole file from the dates that can only be read one way. |
P, then M | Description | Joined into one cell, for example “Corner Grocer — Card payment”. |
T | Amount | Signed as the file writes it. |
N, L and split lines | — | Check numbers, categories and splits are Quicken bookkeeping rather than statement data, and are left out. |
!Type:CCard | — | The file is read as a credit card account; the amounts keep their signs. |
!Type:Bank
D03/04/2026
T-38.40
PCorner Grocer
MCard payment
^Investment QIFs (!Type:Invst) hold trades rather than transactions and are refused with a message. Each QIF file counts as one page, so the first 3 files of your first upload convert free.
What the CSV file looks like
The CSV you download: four columns and a header row. Balance stays empty for a QIF source, because QIF carries no running balance.
Date,Description,Amount (USD),Balance
2026-03-02,Direct Debit 4471 Acme Insurance,-120.00,1880.00
2026-03-04,Card Payment Corner Grocer,-38.40,1841.60
2026-03-06,Transfer Received J Smith,500.00,2341.60How to convert
Upload the QIF file
Drop in the .qif from your bank, Quicken, Microsoft Money or another finance app. Several files can go in at once.
Pick CSV or Excel
CSV is selected on this page; switch to Excel for an .xlsx workbook.
Open the spreadsheet
Check the rows in Excel, Numbers or Google Sheets.
Statements it handles
Layouts differ from bank to bank, so nothing is matched against a fixed template. An unusual statement still produces a table you can check before exporting — which is what makes it usable for bookkeepers and accountants who receive statements from every client.
PDF statements and CSV exports
A statement downloaded from your bank, or the CSV your bank lets you export. Both arrive as the same clean table.
Multi-page statements, read as one table
A statement that runs over several pages — or several statements uploaded together — is read as one continuous table, not one file per page.
Amounts and dates kept as your bank prints them
Debit and credit signs, decimal places and date formats are left as printed, so the numbers still reconcile against the statement.
Scanned, image-only PDFs, read with OCR
A statement with no text layer is read with OCR and may need a quick review — the one case where a row can come out wrong.
- CSV
- Scan
Frequently asked questions
How do I convert a QIF file to CSV?
Upload the .qif above, keep CSV selected and download the file. Every transaction becomes one row with date, description and amount.
Can I convert a QIF file to Excel?
Yes. Choose Excel in the format menu before converting and you get an .xlsx workbook with the same rows, amounts stored as numbers.
How do I open a QIF file?
Finance apps such as GnuCash, Moneydance and Quicken import it. To read it anywhere else, convert it to CSV or Excel — in a text editor or straight in Excel you see the tagged lines, not a table.
What does it leave out?
Categories, check numbers and split lines. They are Quicken bookkeeping rather than statement data; the date, payee, memo and amount of every transaction are kept.
Is it free?
Each QIF file counts as one page, and the first 3 pages of your first upload are free. After that it is $0.20 a file with a $3.90 minimum per batch.
Is my file kept after conversion?
No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.