QIF to Excel — Convert a Quicken QIF File

What a QIF file is

QIF stands for Quicken Interchange Format. It's a line-based text format where each transaction is a small block of fields — a line for the date, a line for the amount, a line for the payee, and so on, separated by a marker. Unlike OFX or CSV, QIF has no header row and no strict column order, and it doesn't always carry a running balance. It's produced by older Quicken versions and some legacy banking exports. That loose structure is exactly why a straight Excel import often misaligns.

Why convert QIF to Excel

• You want columns — QIF's block layout isn't a table until you reshape it.
• You're migrating off Quicken and need the history somewhere neutral.
• An accountant or system wants Excel or CSV, not a 1990s text format.
• You're consolidating several accounts and need them side by side.

How to convert a QIF file to Excel

1. Use a dedicated QIF-to-CSV/Excel converter. Because QIF is irregular, a purpose-built converter handles the block-to-column mapping far more reliably than a manual import.
2. Import the QIF into GnuCash or a newer Quicken, then export CSV. Round-tripping through software that understands QIF gives you a clean table to save as Excel.
3. Reshape it in Excel Power Query. Advanced users can load the text, split on the QIF field markers, and pivot each transaction block into a row — workable, but the most effort.
4. Check whether the original source offers CSV. If the data came from a bank or tool that can re-export as CSV, that avoids QIF's quirks entirely.
5. If you have the original PDF statement, convert that. Export Bank Statement turns the PDF into a reconciliation-verified Excel file with proper columns, no reshaping required.

Where Export Bank Statement fits — honestly

Export Bank Statement does not read QIF files; its input is PDF. What it removes is the manual reshaping pain — but only when you start from a PDF statement. If your QIF came from a bank that also issued a PDF, convert the PDF here for a tidy, checked spreadsheet. If all you have is the QIF, the converters and round-trip routes above are the way.

A note on accuracy

QIF's lack of a balance line means a sloppy conversion can silently drop or duplicate a transaction and you'd never notice. When you convert a PDF with Export Bank Statement, every line is tied back to the statement's running balance, so the spreadsheet reconciles to the closing figure the bank printed. See convert bank statements to Excel without copy-paste for more on that workflow.