IIF to CSV Converter

Why convert an IIF to CSV?

IIF — Intuit Interchange Format — is QuickBooks Desktop's own import format, and it shows. An IIF file is tab-separated text built around TRNS and SPL double-entry lines: correct for Desktop's importer, painful for a human to read, and unreadable to almost any other software.

Converting it to CSV flattens those paired entry lines into the shape everything else understands — one row per transaction with its date, description and amount — ready for review in a spreadsheet, a migration out of Desktop, or a hand-off to someone without QuickBooks.

What the conversion does

The converter reads the transactions recorded in the IIF and writes them out as plain spreadsheet rows. Dates, descriptions and amounts are carried over exactly as the file records them, with no currency conversion.

The double-entry structure stays behind, deliberately: a CSV has no debits-and-credits pairing to express it in, so the output is the transaction list itself — the part you review, total and migrate — in a form any spreadsheet or importer can open.

Format notes and where the CSV goes next

Going back the other way is a different tool with a different job: the CSV to IIF converter builds Desktop-ready TRNS and SPL lines from a spreadsheet, including the account names the import needs. And the QBO to IIF converter brings QuickBooks Web Connect data into the same Desktop format.

For a formatted workbook instead of plain text, the IIF to Excel converter lays the same IIF data out as a spreadsheet file. Whichever wrapping you choose, the rows underneath are the transactions from your file.