QIF to CSV
Convert Quicken Interchange Format files to CSV
QIF input
Paste data, upload a file or load the sample, then click Convert. Your data is not uploaded or stored.
CSV output
Details
Transaction preview
About QIF to CSV Converter
Our free QIF to CSV converter transforms Quicken Interchange Format files into clean, structured CSV data in seconds. QIF is one of the oldest and most widely used personal finance data formats, originally created by Intuit for Quicken software. Despite being largely replaced by OFX for bank downloads, QIF remains widely used for exporting and archiving transaction data from Quicken, QuickBooks, Microsoft Money, and other financial applications.
This converter parses all standard QIF record fields including dates (D), amounts (T), payees (P), categories (L), memos (M), cleared status (C), check numbers (N), addresses (A) and split lines (S, E, $). Dates are read in the month/day or day/month order the file uses, and amounts in international number formats including European comma decimals.
Nothing is kept after you close the page. Your personal financial data is not uploaded or stored. Move years of Quicken or Microsoft Money history into Excel, Google Sheets, or a new budgeting app, or hand an accountant a CSV of last year's transactions for a tax return.
Key Features
- Complete QIF Parsing: Extracts the standard fields: Date (D), Amount (T), Payee (P), Category (L), Memo (M), Cleared (C), Check Number (N), Address (A)
- Split Transaction Support: Each split line (category, memo and amount) gets its own row under its transaction
- Flexible Date Handling: Reads US (MM/DD/YYYY), European (DD/MM/YYYY, DD.MM.YYYY) and Quicken apostrophe dates (1/15'23), with one order for the whole file
- International Amount Parsing: Supports US (1,234.56), European (1.234,56), and other number format conventions
- Multiple Account Types: Recognizes Bank, CCard, Cash, Oth A, Oth L and Invst registers and skips category and class lists
- Auto-Convert on Upload: Automatically parses and converts QIF files immediately when uploaded for fastest results
- Detailed Warnings: Reports missing dates, missing amounts, and other data quality issues for each transaction
- Transaction Statistics: Displays transactions, accounts and turnover (the total of amounts without sign)
- RFC 4180 Compliant CSV: Generates properly escaped CSV output with quoted fields for special characters
- One-Click Export: Download the CSV file or copy to clipboard instantly
How to Convert QIF to CSV
- Upload or paste your QIF data: Click Upload File to select a .qif file from your computer, or paste the raw QIF content directly into the input area.
- Review the input: Verify your QIF data appears correctly with the !Type header and transaction records. Use the Sample button to test with example data.
- Click Convert to CSV: Press the conversion button to parse all QIF records and generate a structured CSV with all transaction details.
- Review warnings: Check any warnings about missing dates, amounts, or other field issues to ensure data accuracy.
- Check the statistics: Review the transaction count, account count and turnover below the output.
- Download or copy the result: Save the CSV file using the Download button or transfer it to your clipboard with Copy.
Use Cases
- Quicken Data Migration: Export transactions from Quicken as QIF and convert to CSV for importing into a new financial platform.
- Tax Preparation: Convert yearly QIF exports into CSV for sorting and categorizing transactions during tax filing season.
- Expense Analysis: Transform QIF transaction data into CSV for spending analysis in Excel or Google Sheets.
- Accounting Software Import: Convert QIF files to CSV format compatible with QuickBooks Online, Xero, Wave, or other accounting tools.
- Financial Record Archiving: Convert old Quicken QIF backup files into universal CSV format for long-term archival.
- Budget Planning: Extract categorized transaction data from QIF files for budget creation and tracking in spreadsheet tools.
- Multi-Platform Sync: Bridge QIF-only financial software with modern apps that accept CSV import for transaction history transfer.
- Financial Advisor Reporting: Convert client QIF data into CSV for portfolio analysis, spending reports, and financial planning.
Frequently Asked Questions
What is a QIF file?
QIF (Quicken Interchange Format) is a plain-text data format created by Intuit for exporting and importing financial transaction data. Each transaction is represented by single-letter field codes (D for date, T for amount, P for payee, etc.) separated by caret (^) delimiters between records.
Which QIF account types are supported?
The tool supports all standard QIF account types including Bank, CCard (Credit Card), Cash, Oth A (Other Assets), Oth L (Other Liabilities), and Investment accounts.
Can I convert QIF files from old versions of Quicken?
Usually, yes. QIF has changed little across Quicken versions; fields this tool does not read, such as investment prices and quantities, are left out of the CSV.
What if my QIF file has no !Type header?
The converter will display a warning but still attempt to parse the transaction records. As long as the data follows the standard QIF field codes (D, T, P, L, M, etc.) with caret separators, it should convert successfully.
Tips & Best Practices
- Export from Quicken correctly: When exporting from Quicken, choose the QIF format and select all accounts you want to include for a complete export.
- Check date formats: QIF files from different regions may use different date formats. The converter handles most formats automatically, but verify dates in the output.
- Review category data: QIF categories (L field) often contain subcategories separated by colons (e.g., Utilities:Electric). These are preserved in the CSV output.
- Handle split transactions: Split transactions include several category and amount lines in one record. Each split appears as its own row under the transaction, with its category, memo and amount.
- Try the sample data first: Load the built-in sample QIF to see the output format before converting your own financial data.
- Keep your original QIF files: Always maintain a backup of original QIF exports, as they may contain formatting details not fully captured in CSV conversion.