IIF to Excel Converter

An IIF converted directly to an Excel workbook. Opening one in Excel by renaming it gives you a jumble of header rows and data rows mixed together; this separates them into a single table with one row per transaction.

Straight to .xlsx, with the interleaved rows untangled.

One row per transaction

Rather than the alternating TRNS, SPL and ENDTRNS lines the raw file contains.

Dates and amounts as types

So totals and sorting work without cleaning the sheet up first.

Nothing invented to fill a column

Where the file does not say, the cell is empty.

Related guides

• OFX, QFX, QBO and QIF: Which Format Does Your Software Want?
• Why QuickBooks Rejects Your QBO File
• Why Your QIF Import Lands a Month Out
• How to Convert a CSV to QBO for QuickBooks
• Bank Feeds vs Statement Conversion: When You Need Each
• Bank Statement Converter vs Manual Data Entry: A Real Comparison
• Why Your Converted Bank Statement Doesn't Balance
• The Bank Statement Date Format Problem (DD/MM vs MM/DD)