Convert QIF to CSV for Spreadsheets & Migration
Got a QIF file from Quicken, Microsoft Money, or your bank? Convert it to clean CSV with proper columns — ready for Excel, Google Sheets, or import into any software.
Works with Quicken, Microsoft Money, GnuCash, and bank QIF exports. Free online — no signup.
How It Works
Upload Your QIF File
QIF file from Quicken, Microsoft Money, GnuCash, or your bank. All account types supported: Bank, CCard, Investment, Cash, Assets, and Liabilities.
Transactions Parsed
Date, payee, amount, category, memo, check number, and cleared status extracted. Split transactions expanded into individual line items.
Download CSV
Clean comma-separated file with labeled columns. Opens in Excel, Google Sheets, LibreOffice, or imports into any accounting software.
What's Inside a QIF File
QIF uses single-letter codes for each field. Here's how they map to your CSV.
03/15/2026 or 15/03/2026
-45.99 or +1,250.00
Transaction description
Auto:Fuel, Food:Groceries
Additional notes
Check or reference number
Supported QIF Account Types
!Type:Bank
Checking & Savings
!Type:CCard
Credit Cards
!Type:Cash
Cash Accounts
!Type:Invst
Investments
!Type:Oth A
Other Assets
!Type:Oth L
Other Liabilities
What is QIF?
Quicken Interchange Format
Quicken's legacy text-based format. Each transaction uses single-letter field codes (D=date, T=amount, P=payee, L=category) separated by ^ markers. No formal spec — date formats vary by locale.
What is CSV?
Comma-Separated Values
Plain text with labeled columns and one transaction per row. Opens in any spreadsheet and imports into virtually any software. The universal format for data exchange.
Why This Tool
All QIF Account Types
!Type:Bank, !Type:CCard, !Type:Cash, !Type:Invst, !Type:Oth A, !Type:Oth L — every account type Quicken exports is parsed correctly.
Split Transactions Expanded
QIF split entries (S/$/E fields) become individual CSV rows with their own category, amount, and memo. No data lost from complex multi-category transactions.
Multi-Account Files
QIF files with multiple !Account sections are parsed completely. Every transaction from every account lands in your CSV.
Date Format Detection
QIF dates are locale-dependent — MM/DD/YYYY (US) or DD/MM/YYYY (UK). Auto-detected from context so dates convert correctly to your CSV.
Investment Transactions
Buy, Sell, Div, ReinvDiv, XIn, XOut — investment action types with security name, shares, and price all mapped to CSV columns.
Categories Preserved
Quicken category hierarchies (e.g., "Auto:Fuel", "Food:Groceries") pass through intact. Transfer references ([AccountName]) are preserved too.
When to Use This
Quicken Data Migration
Export QIF from Quicken and convert to CSV for importing into Xero, Wave, FreshBooks, YNAB, or any software that doesn't read QIF natively.
Spreadsheet Analysis
Open years of Quicken transaction history in Excel for pivot tables, charts, and custom spending analysis that Quicken's built-in reports can't do.
Archive & Long-Term Storage
QIF is a legacy format with no formal specification. CSV is universal and future-proof — archive your financial history in a format that will always be readable.
QIF-to-CSV Issues & Fixes
Dates appear swapped — March 4 showing as April 3 (or vice versa)
QIF doesn't specify date locale. A date like D03/04/2026 is March 4 in the US but April 3 in the UK. Verify the first few transactions against your records. If dates are swapped, the file was exported in a different locale than expected.
"No QIF Type found" — file won't parse
The QIF file must start with a valid header like !Type:Bank or !Account. Some text editors add invisible characters (BOM) at the start of files. Open in a plain text editor and verify the first line.
Split transactions showing incorrect amounts
QIF splits use S (category), $ (amount), and E (memo) fields. If the split amounts don't sum to the transaction total (T field), some converters misalign them. Our parser validates that splits balance.
Amounts multiplied by 100 (e.g., $45.99 shows as $4,599)
This happens when the QIF was exported with a different currency/locale setting. Some European exports use comma as decimal separator. Check the original QIF file to verify the amount format.
Frequently Asked Questions
What fields does the CSV contain?
Date, Payee/Description, Amount, Category, Memo, Check Number, and Cleared Status. Split transactions are expanded so each split category gets its own row with its portion of the amount.
Can it handle QIF files with multiple accounts?
Yes. Multi-account QIF files (with multiple !Account or !Type sections) are parsed completely. All transactions from all accounts are included in the CSV output.
My QIF has split transactions — are those preserved?
Yes. Each split (S/$/E fields) becomes its own row in the CSV with the split category, amount, and memo. The parent transaction ties them together.
The dates in my QIF look wrong after converting — what happened?
QIF doesn't specify date locale. A date like 03/04/2026 could be March 4 (US) or April 3 (UK). Our converter auto-detects the format, but verify the first few dates match your expectation.
Can I import the CSV into QuickBooks?
Not directly — QuickBooks prefers QBO format for bank feeds. Use our QIF to QBO converter for that. CSV works for Excel analysis, Xero, Wave, and other tools that accept CSV import.
Does it handle investment account QIF files (!Type:Invst)?
Yes. Investment transactions include action type (Buy, Sell, Div, etc.), security name, shares, and price — all mapped to CSV columns.
MoneyThumb charges $60+ for QIF conversion. Is this free?
Yes. No transaction limits, no trial restrictions, no desktop software to install. Convert as many QIF files as you need in your browser.
What software exports QIF files?
Quicken (all versions), Microsoft Money, GnuCash, Moneydance, some banks (though QIF bank downloads are becoming rare — most banks now export OFX or CSV).
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your QIF file is deleted immediately after conversion.
Related Tools
QIF to Excel
Convert QIF (Quicken) files to formatted Excel spreadsheets. Includes Date, Description, Amount, Category, and Memo columns. Free, instant, no signup required.
Convert now →QIF to QBO
Convert QIF files to QBO for QuickBooks. The easiest way to migrate transaction data from Quicken to QuickBooks Desktop or Online. Free, no signup required.
Convert now →CSV to QIF
Convert CSV financial files to QIF for Quicken. Auto-detects columns and preserves categories if present in your data. Free, instant, no signup required.
Convert now →PDF to CSV
Extract transactions from bank statement PDFs to CSV. AI-powered, works with any bank in any language. Accurate date and amount extraction. Free, no signup.
Convert now →