Logo

QIF to CSV

Universal Format Converter

Convert between CSV, TSV, JSON, and Excel. Supports multiple files, primary data, and batch operations.

Select a data source to begin conversion

No data loaded

Upload files or use primary data to start converting

About QIF to CSV

Convert legacy Quicken QIF exports into CSV, mapping date, amount, payee, memo and category fields to clean columns.

QIF predates OFX and is still what many older banks, legacy accounting archives, and pre-2005 Quicken files use for their transaction exports. Each record is a stack of single-letter-coded lines (D for date, T for amount, P for payee, and so on) terminated by a caret, which is not something a spreadsheet can open directly.

This tool walks the record structure line by line, mapping each code to a named column, and correctly separates the file-level "!Type" header from the actual transaction records — a detail that trips up naive line-splitting approaches.

It works equally well on a single account export or a batch of old archived QIF files you're finally migrating off of.

Because the parsing runs entirely client-side, you can process years of historical financial data without uploading it anywhere.

Category: Financial Formats

Common Use Cases

  • Migrating old Quicken data to spreadsheets
  • Archiving legacy bank exports as CSV

Key Features

  • Reads single-letter QIF codes (D, T, P, M, L, N) line by line
  • Separates the file-level "!Type" header from actual transaction records
  • Handles single accounts or batches of archived QIF files
  • Parses entirely in-browser, so old financial history stays local

The QIF to CSV tool is compatible with: Quicken, Legacy Bank Exports.

Use this to pull years of old QIF archives into CSV, then cross-reference against a modern OFX_TO_CSV export or push cleaned records into IIF_TO_CSV if the destination is QuickBooks.

Frequently Asked Questions

Is QIF still used by modern banks?

Rarely for new exports, but it's still common in legacy archives and pre-2005 Quicken files that need migrating.

What fields does it extract?

Date, amount, payee, memo, category, number and cleared status, mapped from QIF's single-letter line codes.

Aimed at anyone finally migrating off pre-2005 Quicken or clearing out a legacy bank export archive.

Read the related guide →