QIF to CSV - Quicken File Converter

Convert Quicken QIF files to CSV. Extract transaction data from legacy Quicken exports. Private browser-based conversion, no uploads.

QIF Input

Paste QIF data or load sample

CSV Output

QIF Format Guide

Supported Fields:

!Type: - Account type (Bank, CCard, Cash, Oth A, Oth L)
D - Date (M/D/Y or M/D'YY format)
T - Transaction amount (negative for payments)
P - Payee or description
M - Memo
C - Cleared status (*, c, X, or blank)
N - Check number or reference
L - Category (with optional subcategories using colons)
S - Split category
E - Split memo
$ - Split amount
^ - End of transaction marker

Note: Dates are normalized to YYYY-MM-DD format in CSV output.

MT940 to CSV Converter - SWIFT Bank Stat…

NACHA to CSV Converter - ACH File Parser

ISO 20022 to CSV Converter - Parse Finan…

CAMT.053 to CSV Converter - SEPA Stateme…

OFX to CSV Converter - Open Bank Stateme…

View all Finance converters →

Frequently Asked Questions

QIF (Quicken Interchange Format) is a text-based file format developed by Intuit for exporting and importing financial data from Quicken. It uses single-letter codes to represent transaction fields, with each transaction separated by a caret (^) symbol. Despite being replaced by OFX in newer software, QIF remains widely used for legacy data migration.

Quicken introduced QIF in the 1990s as an open format for data portability. It became the de facto standard for personal finance software interoperability. While Intuit transitioned to OFX (Open Financial Exchange) in the early 2000s, QIF files remain common in legacy Quicken exports, backup archives, and older financial software installations.

QIF files contain fields marked by single letters: D (date), T (amount), P (payee/description), M (memo), C (cleared status), N (check/reference number), L (category), S (split category), E (split memo), and $ (split amount). Not all fields appear in every transaction. This converter extracts all available fields into corresponding CSV columns.

QIF files typically use M/D/Y or M/D'YY formats (e.g., 3/15/2024 or 3/15'24) in US locales, though some international versions use D/M/Y. This converter automatically detects common date formats and normalizes them to YYYY-MM-DD in the CSV output for better compatibility with spreadsheet software and databases.

QIF uses the L field for categories, with subcategories separated by colons (e.g., 'Expenses:Utilities:Electric'). The converter preserves the full category path in the CSV Category column. For split transactions (multiple categories), each split appears as additional columns (Split Category 1, Split Amount 1, etc.) to maintain complete transaction detail.

Split transactions divide a single payment across multiple categories. In QIF, they use S (split category), E (split memo), and $ (split amount) fields. For example, a grocery purchase might split between 'Food' and 'Household Supplies'. This converter creates additional CSV columns for each split, ensuring all categorization data is preserved.

QIF is a simple text format with single-letter codes, while OFX is XML-based and more structured. OFX includes institution-specific identifiers, transaction IDs, and balance information that QIF lacks. However, QIF is more human-readable and easier to edit manually. For legacy Quicken data (pre-2005), QIF is often the only available export format.

Yes, all conversion happens entirely in your browser using JavaScript. Your QIF file never leaves your device or gets uploaded to any server. No data is stored, logged, or transmitted. You can even use this tool offline after the page loads. For sensitive financial records, this client-side processing ensures complete privacy.

Absolutely. This is one of the primary use cases. Many users have decades of financial data in old Quicken versions that can only export to QIF. Converting to CSV allows import into Excel, Google Sheets, modern accounting software, or databases. The normalized date format and structured columns make the data immediately usable for analysis or transfer to platforms like YNAB or Mint alternatives.

Yes, the CSV output is optimized for Excel and Google Sheets analysis. Dates are in YYYY-MM-DD format for sorting, amounts are numeric for sum/average calculations, and categories are text strings for pivot tables. You can easily create charts, calculate monthly spending, track payees, or perform reconciliation. The structured format makes it simple to apply filters, formulas, and conditional formatting.

QIF Input

CSV Output

QIF Format Guide

Related Tools