CSV to QIF Converter

Why convert a CSV to QIF?

QIF — Quicken Interchange Format — is Quicken's legacy plain-text format, and some software never moved on from it. Intuit discontinued QIF imports in favour of QFX in the mid-2000s, but many older and other apps still read and write QIF, and for those apps a modern bank CSV is unusable until it is reshaped.

This converter does that reshaping: your spreadsheet rows become QIF records, so data you downloaded today can enter a tool whose import menu has not changed in years.

What the conversion does

Each CSV row — one row per transaction — becomes one QIF record carrying its date, description and amount, with records separated by the ^ lines the QIF format uses. Amounts are copied exactly, with no currency conversion.

QIF is a deliberately simple format: no bank identity, no transaction IDs, no closing balance. The converter adds none of those, because the source CSV does not carry them and inventing them would corrupt the record. What goes in as transactions comes out as transactions.

Format notes and where the QIF goes next

Choose QIF only when the receiving app actually asks for it. Current Quicken versions import QFX instead — the CSV to QFX converter covers that route — and QuickBooks takes QBO via the CSV to QBO converter. QIF is the legacy door, still the only door some apps have.

To move data back out of QIF later, the QIF to CSV converter returns it to a spreadsheet, and the QIF to QBO converter brings legacy Quicken data forward into QuickBooks.