IIF to Excel Converter — Free online
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.
Not the file you need?
- Want a plain CSV: IIF to CSV Converter
- The other way, a workbook to IIF: Excel to IIF Converter
- Have a workbook to turn into a QIF: Excel to QIF Converter
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 Excel can use
Money out and money in are numbers in their own columns, so totals work as soon as it opens, and dates are Excel dates wherever every date in the file could be read.
Nothing invented to fill a column
Where the file does not say, the cell is empty.