xlsRowvert
File converters · IIF → Excel

IIF to Excel converter

Open a QuickBooks Desktop IIF export as an Excel workbook: one row per transaction with real dates and amounts, the account, the name, the memo and the split accounts.

  • ✓ Free, no account, no email
  • ✓ Converted in memory and never stored
  • ✓ Reads files from any bank or finance app
Convert .iif fileFree · no account
Drop your .iif file hereor click to browse · up to 5 MB · processed in memory, never stored
Reads QBO, OFX, QFX, QIF, CSV and IIF files. Writes CSV, Excel, QBO, QFX, OFX, QIF and PDF.

When you need to convert IIF to Excel

  • You need to review or audit an IIF export in Excel.
  • You're migrating from QuickBooks Desktop and want a readable copy of the transactions.

How to convert IIF to Excel

  1. Drop your .iif file on the converter (up to 5 MB).
  2. Check that "Convert to" says Excel, and pick the date order if your dates are ambiguous.
  3. Click Convert: the Excel file downloads straight away. Nothing is stored.
  4. Open or import it: Excel, Google Sheets, Numbers, LibreOffice — Open the .xlsx. The Transactions sheet has a frozen header and filters; the File info sheet lists the account, period, totals and ending balance.

What happens to your data

  • Transactions sheet: Date, Description, Amount, Debit, Credit, Memo, Check number, Type, Account and Split account, with totals.
  • Dates such as 7/16/2026 become real Excel dates.
  • A File info sheet with the period, number of transactions, money in and money out.

Importing the Excel file

Excel, Google Sheets, Numbers, LibreOffice
Open the .xlsx. The Transactions sheet has a frozen header and filters; the File info sheet lists the account, period, totals and ending balance.

What is a IIF file?

IIF is QuickBooks Desktop's tab-separated import/export format. Transactions are written as a TRNS line (date, account, name, amount, memo, document number) followed by SPL lines for the other side of the entry and an ENDTRNS line. QuickBooks Online doesn't read IIF.

What is an Excel export?

An Excel workbook with typed columns: real date cells, numbers with two decimals, separate Debit and Credit columns and a totals row, so SUM, filters and pivot tables work straight away.

IIF to Excel: questions

Does it convert IIF lists like customers or items?

No, only transactions (TRNS/SPL). Lists are skipped.

Is the file stored?

No. It's processed in memory and sent straight back to your browser.

Is the IIF to Excel converter free?

Yes. Format-to-format conversions are free and need no account. Files are converted in memory and never stored. Converting PDF bank statements is a separate tool with a free daily allowance.

Only have a PDF statement? Convert a PDF bank statement to Excel — digital or scanned, any bank.

Other converters: QBO to Excel · OFX to Excel · QFX to Excel · QIF to Excel · IIF to CSV · All file converters