LogoHow To CSV

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

AboutQIF to CSV

Convert legacy Quicken QIF exports into CSV, mapping date, amount, payee, memo and category fields to clean columns.Category: Financial Formats
Migrating old Quicken data to spreadsheetsArchiving legacy bank exports as CSV
The QIF to CSV tool is compatible with:QuickenLegacy Bank Exports. This tool alone can help you manage and analyze your data effectively. However, a composed workflow using OFX TO CSV, IIF TO CSV may provide even more powerful data processing capabilities. Consider exploring these related tools for a comprehensive data solution.
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.

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.


Developed by HowToCSV for our valued CSV Haters worldwide.