QIF to CSV Converter

QIF stands for Quicken Interchange Format. It is one of the oldest electronic financial data formats still in use today. Intuit created QIF in the early 1990s as the native export format for Quicken, their personal finance software that dominated the market throughout the 1990s and 2000s.

QIF was the standard way to move financial data between banks, Quicken, Microsoft Money, and other personal finance tools before OFX was developed. Millions of users exported decades of financial history in QIF format, and many of those archives still exist on old hard drives, backup CDs, and legacy systems.

Although Intuit officially deprecated QIF in favor of QFX (Quicken Web Connect) in 2005, the format remains widely used. Many banks still offer QIF downloads, especially for personal banking accounts. Legacy Quicken installations (Quicken 98 through Quicken 2015) store data in QIF format. And thousands of financial tools and scripts still produce QIF output.

The format itself is remarkably simple. Each line starts with a single-character prefix that indicates the field type, and transactions are separated by a caret (^) symbol. This simplicity is both its strength (easy to parse) and its limitation (no support for investment accounts, split transactions, or multi-currency data in the basic banking type).

A QIF file is a plain-text file with a specific structure. The first line declares the account type, typically !Type:Bank for checking and savings accounts. Each transaction is a block of prefixed lines ending with a caret (^) delimiter.

Here are the QIF line prefixes:

D — Date in MM/DD/YYYY format (e.g., D01/15/2026 means January 15, 2026)

T — Transaction amount as a signed number (e.g., T-450.00 is a debit of $450, T3200.00 is a credit of $3,200)

P — Payee name or description (e.g., POffice Supplies Co)

M — Memo or additional notes (e.g., MBulk paper and toner order)

L — Category for budgeting (e.g., LOffice Expenses)

A — Address line (used in check-writing contexts)

^ — Record separator that marks the end of one transaction

A typical QIF transaction looks like this: D01/15/2026 followed by T-450.00, POffice Supplies Co, MBulk paper order, and ^ on separate lines.

FinanceConvert parses each of these prefixed lines, extracts the relevant data, converts dates to ISO format, splits the signed amount into separate Debit and Credit columns, and outputs a clean CSV row for each transaction.

The most common reason to convert QIF to CSV is data migration. Here are the scenarios accountants and individuals face:

Migrating from Quicken to cloud accounting — if you are moving from Quicken Desktop to QuickBooks Online, Xero, or Wave, these platforms accept CSV imports but not QIF. Converting QIF to CSV is the bridge between your legacy data and your new system.

Recovering historical financial data — many people have years of financial history locked in QIF files from old Quicken installations. Converting to CSV makes this data accessible in any modern spreadsheet application.

Consolidating data from multiple sources — when you receive transaction data in different formats (QIF from personal accounts, OFX from business accounts, CSV from credit cards), converting everything to CSV creates a uniform format for analysis.

Tax preparation — tax preparers need structured transaction data they can sort, filter, and categorize. QIF files cannot be opened in Excel, but the converted CSV can be immediately used for tax categorization.

Forensic accounting — investigators reviewing historical financial records may receive QIF exports from legacy systems. Converting to CSV enables analysis with modern data tools.

Moving from Microsoft Money — Microsoft Money was discontinued in 2009 but exported data in QIF format. Millions of users still have Money exports that need to be converted for modern use.

Step 1: Locate your QIF file. It may be in your Quicken data folder, an old backup, or downloaded from your bank. QIF files typically have the .qif extension.

Step 2: Open the QIF to CSV converter on this page and drop your .qif file into the upload zone.

Step 3: FinanceConvert parses the QIF record blocks. Each transaction is extracted by reading the D (date), T (amount), P (payee), M (memo), L (category), and A (address) lines between ^ delimiters.

Step 4: The parser converts dates from MM/DD/YYYY to ISO YYYY-MM-DD format, splits the signed T amount into separate Debit and Credit columns, and concatenates Memo, Category, and Address into a combined Memo field separated by pipes.

Step 5: Download your CSV file. The output contains columns for Date, Description, Memo, Debit, Credit, Balance, Amount, Currency, and FITID. Open it in Excel, Google Sheets, or import it into your accounting software.

Note: QIF files do not contain running balance information, so the Balance column will be empty in the CSV output. If you need balance data, you can compute a running total in Excel using a simple SUM formula.