Open Quicken Interchange Format data in Excel. Convert legacy QIF transactions from Quicken, Microsoft Money and other finance software into clean spreadsheets — free, no signup.
QIF (Quicken Interchange Format) has been around since the late 1980s. It's plain text, but not a table — each transaction spans multiple lines, each line starting with a single-letter field code:
D = date, T = amount, P = payee, M = memo, ^ = end of transaction. Open this in Excel and you get one long column of codes — useless for analysis. Conversion means parsing these records and rebuilding them as a proper table: one row per transaction, one column per field.
| QIF Quirk | Problem | Handled By Conversion |
|---|---|---|
| Ambiguous dates | 01/04/2026 = Jan 4 (US) or April 1 (EU)? | Date locale detection across the full file |
| Multi-line records | One transaction ≠ one line | Records parsed on ^ delimiters into single rows |
| Mixed account types | Bank, cash, credit card sections in one file | Type headers respected, data kept consistent |
| Sign conventions | Debits negative, but not always consistent | Amounts normalized to consistent debit/credit |
If your QIF file was exported from a bank, the original statement PDF is the better source to convert: it contains the running balance, which lets our converter verify every extracted amount mathematically. QIF files don't carry balances — errors in them can't be detected. Upload the statement PDF and download Excel, CSV and JSON from one verified conversion.
Bank statement PDF — any bank, any era, digital or scanned
Transactions extracted and checked against running balances
Clean XLSX, CSV and JSON — ready for analysis or import
If you need QIF output for legacy software like Microsoft Money or GnuCash, our PDF to QIF converter produces valid QIF files from any bank statement. For modern Quicken use PDF to QFX, and for QuickBooks use PDF to QBO.