IIF to CSV Converter — Free online
IIF is tab-delimited and looks like it should open in a spreadsheet, and then does not — because it interleaves several kinds of row, each with its own set of columns declared above it. This reads that structure properly and gives you one clean table.
Not the file you need?
- Want an .xlsx you can sort and add up: IIF to Excel Converter
- Moving to GnuCash, MYOB or older Quicken: IIF to QIF Converter
QuickBooks Desktop's own format, opened as a spreadsheet.
The "!" lines read as the definitions they are
An IIF declares its columns inline, and the order differs between files. Mapping by name rather than by position is why a file from one QuickBooks version does not come out scrambled.
Transactions and splits not double-counted
The bank side and the category side of a transaction are the same money with opposite signs. Adding both would double every figure in the file.
Document number and memo kept
The document number becomes the Reference — or the transaction type, where it is blank — and the memo is joined to the name rather than dropped.