IIF File to Excel Converter Online: Free IIF to XLSX
Double-click an IIF and Excel stacks three kinds of row into one sheet: transaction lines, the split lines beneath them, and the ! lines labelling both. Nothing sorts, because half the rows are not transactions. This reads the records the way QuickBooks wrote them and returns one row per transaction, carrying across the account each amount posted to. Convert IIF to Excel free — parsed in this page, so nothing reaches a server.
Not the file you need?
Why Use Our IIF to Excel Converter Tool?
The split line says what the money was for
A TRNS row carries only the bank or card side of an entry, so reading it alone leaves a sheet where every row says "Amazon.com" and nothing says what was bought. The account from the split line is carried across into a Category column.
Nothing is sent anywhere
The file is read in the page itself and the workbook is built there too, so no copy of your ledger is uploaded, queued or held for deletion later. Free converters that process on a server typically keep your file for around 24 hours.
Your dates are read, not assumed
QuickBooks Desktop writes IIF dates in whatever order the exporting computer's Windows region is set to, so a file from outside the US is often day-first. The order is worked out from the dates themselves rather than guessed at.
How to convert IIF file to Excel in three steps
Drop the .iif in as it is
To convert IIF file to Excel, start with whatever QuickBooks Desktop wrote — File, Utilities, Export, Lists to IIF Files — or the export a third-party tool handed you. There is no template to fill in and nothing to rename first.
Upload the IIF
Pick the file or drop it onto the box. The browser opens it directly and pulls the transactions out of the TRNS and SPL lines — no request carries the contents anywhere.
Check the table, then take the workbook
The rows on screen are the rows in the file — every column the IIF declared, plus the Category recovered from the splits. Download it as .xlsx and it opens in Excel, Google Sheets, Numbers or LibreOffice.
What the Text Import Wizard gives you, and what this gives you
Every guide on this subject says to open the .iif in Excel and pick Tab as the delimiter. That does work, in the sense that something appears on screen. Here is the same file both ways.
Opened straight in Excel
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM !SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT !ENDTRNS TRNS 1 CHECK 15/03/2026 Checking Amazon.com -129.99 00514 SPL 2 CHECK 15/03/2026 Office Supplies Amazon.com 129.99 ENDTRNS TRNS 3 CHECK 22/03/2026 Checking City Utilities -450.00 1000000000000123 SPL 4 CHECK 22/03/2026 Electric City Utilities 300.00 SPL 5 CHECK 22/03/2026 Water City Utilities 150.00 ENDTRNS TRNS 6 DEPOSIT 28/03/2026 Checking Client Payment 2500.00 SPL 7 DEPOSIT 28/03/2026 Consulting Income Client Payment -2500.00 ENDTRNS
Three record types stacked in one sheet. The two ! lines are headers for different shapes, ENDTRNS is punctuation rather than data, and the SPL rows put an expense account in the same column as a bank account. Sorting by date mixes all of it together.
Downloaded as .xlsx
| Date | Name | Amount | Docnum | Category |
|---|---|---|---|---|
| 15/03/2026 | Amazon.com | -129.99 | 00514 | Office Supplies |
| 22/03/2026 | City Utilities | -450.00 | 1000000000000123 | split 2 ways |
| 28/03/2026 | Client Payment | 2500.00 | — | Consulting Income |
One row per transaction, one header, and a Category column carried across from each split line. Row 2 splits two ways, so its Category is deliberately left blank rather than claiming the whole 450.00 belongs to Electric.
Why an IIF will not behave like a spreadsheet
QuickBooks Online will not take an IIF at all
IIF is a Desktop format. QuickBooks Online imports CSV and XLSX and refuses IIF outright, so moving an old Desktop export into Online means converting it first — which is the same job this page does.
The expense account lives on a line most tools throw away
TRNS holds only the bank or card side of an entry. The account the money posted to — the half saying what the spending was — sits on the SPL line beneath it, and a converter reading TRNS alone loses it silently.
The window for getting data out is closing
QuickBooks Desktop 2023 passed its discontinuation date in May 2026 and the 2024 release is supported only to May 2027. Once a subscription lapses the company file is read-only for a year, then shut. A workbook needs no licence.
Excel damages cheque numbers and long references on the way in
Its own import rules turn 00514 into 514 and round anything past fifteen digits, so a reference ending 0123 comes back ending 0000. Both are kept as text here, while amounts still become real numbers.
Which records an IIF actually contains
An IIF is a container for several record types, and only some of them are transactions. This is what QuickBooks writes into one, and what each part becomes here.
| Record | What it holds | Converted | Becomes |
|---|---|---|---|
| !TRNS / TRNS | The bank or card side of an entry — date, payee, total, cheque number | One row each | |
| !SPL / SPL | The account the money posted to — what the spending actually was | Read into Category | |
| ENDTRNS | Closes a transaction block; carries no data of its own | Dropped | |
| !ACCNT, !VEND, !CUST … | List exports — chart of accounts, vendors, customers | Not a transaction file |
A split is read into Category when a transaction posts to exactly one account. Two or more is a genuine split, and a single cell cannot hold both — that row is left blank rather than credited to whichever account happened to come first. The amount on the row is the full total either way.
Who needs an IIF turned back into rows
Leaving QuickBooks Desktop
Intuit stopped selling new Pro, Premier and Mac Plus subscriptions, and IIF is what the File menu hands you on the way out. XLSX outlives both.
Sending books to an accountant
An IIF is unreadable to anyone without QuickBooks Desktop installed. A workbook opens for them in Excel, Sheets, Numbers or LibreOffice.
Checking an import first
A third-party tool generated the IIF and you would rather see the rows than trust them. Reading it as a sheet takes less time than undoing an import.
Archiving before access ends
A lapsed subscription leaves the company file read-only for a year and then closed. A spreadsheet keeps the numbers after the software stops opening.
Working out a failed import
Import IIF file into QuickBooks Desktop and it can fail on a line number with no context. Seeing the transactions as rows is how you find which one it meant.
Pivot tables and formulas
Amounts arrive as real numbers rather than text, so SUM, SUMIF and a pivot table work on the download without cleaning a column first.
Why your IIF dates may not be month-first
QuickBooks Desktop takes its date order from the exporting computer's Windows regional settings, not from a setting inside QuickBooks. Nothing in the file records which order was used, so the same eight characters mean two different days.
03/04/2026
Read as month-first
4 March 2026
What a converter assuming US settings will store — and it looks perfectly plausible, which is why this goes unnoticed until a reconciliation fails.
03/04/2026
Read as day-first
3 April 2026
What the file actually meant if it was exported from a machine set to the UK, Australia, India or most of Europe.
How the order is settled here
Every date in the file is scanned before any of them is converted. A first component above twelve can only be a day, and a second component above twelve can only be a month, so one unambiguous row settles the whole file — a single 22/04/2026 proves that 03/04/2026 beside it is 3 April. Where a file contradicts itself the weight of evidence decides. If no date in the file has a component above twelve there is nothing to prove either way, and it is read as month-first — worth a glance at the preview before you download.
Frequently Asked Questions — IIF to Excel Converter
QCan I just open IIF file in Excel instead?
QWhat is an IIF file in QuickBooks?
QHow to open IIF file without QuickBooks?
QIs there a free IIF file viewer or IIF file reader?
QWhat happens to split transactions?
QWhy is there a Category column that was not in my file?
QMy dates came out day-first — is that right?
QDo cheque numbers with leading zeros survive?
QWill SUM work on the amounts?
QCan I convert a chart of accounts or a customer list IIF?
QIs my IIF file uploaded anywhere?
QWhat is the best IIF to Excel converter?
QQuickBooks Desktop is ending — how do I keep my data?
Other Conversion Formats
Get the rows out of the IIF
Every column the file declared, one row per transaction, the split account beside each amount, and totals that add up without cleaning a cell first. Drop the .iif on the box above and the workbook is built in the page — no upload, no signup, no row cap. An IIF to Excel converter online, free, and no account needed.