How to open an .IIF file (QuickBooks Desktop, Excel or no QuickBooks)

An .IIF file is an Intuit Interchange Format file: plain, tab-separated text that QuickBooks Desktop imports lists and transactions from. It isn't a QuickBooks company file and it isn't a spreadsheet, even though Excel can show it in columns. This guide covers every way to open one: in QuickBooks Desktop (Windows and Mac), in Excel or Google Sheets, in a text editor, and what to do when you're on QuickBooks Online or have no QuickBooks at all.

1. What an .IIF file is (and isn't)

Intuit describes .IIF files as ASCII text, TSV (tab-separated value) files that QuickBooks Desktop uses to import or export lists or transactions. Rows that start with ! are headers naming the columns; the rows under them are data. You'll meet two kinds:

The sample IIF file guide takes a transaction IIF apart field by field, and QBO vs IIF vs QIF compares the three formats.

2. Open in QuickBooks Desktop for Windows

"Opening" an IIF in QuickBooks means importing it into the company file that's open, and an import can't be undone. Intuit's steps:

1. Back up the company file. Intuit is explicit about this, because an import has no undo.
2. Sign in to the company file as the admin. If you're in multi-user mode, choose File → Switch to Single-user Mode.
3. Choose File → Utilities → Import → IIF Files (labelled Import IIF in Intuit's current help), select the .iif and click Open.
4. Click OK to confirm. Then check the register: the right account, the right dates, and the number and total of transactions you expected.

Three things to know. First, every account named in the file must already exist with exactly that name; Intuit warns that an account it doesn't find is created as a new bank account. Second, IIF import does only limited error checking, so a wrong file can import incorrectly with no error, and Intuit doesn't offer technical support for IIF import. In QuickBooks Desktop 2019 and later, the Improved IIF Import tool reports a "File not imported" message and writes the failed rows to a new .iif; IIF import errors walks through it. Third, IIF is a local import, so it still works on Desktop 2023 and older after Intuit ended online banking (and Web Connect) for those versions on May 31, 2026.

Not sure the file is right? Drop it on the free IIF file checker before you import; it reads the headers, the tabs between columns, dates, amounts and whether each transaction adds up to zero, in your browser.

3. Open in QuickBooks Desktop for Mac

Intuit's help for QuickBooks Desktop for Mac: sign in as the admin, go to File → Import → From IIF Files and choose the file. Exporting lists is File → Export → Lists to IIF File. The same rules apply: back up first, make sure the account names match, and check the register afterwards.

4. QuickBooks Online

QuickBooks Online doesn't import IIF files; IIF is a QuickBooks Desktop format. If you have bank or card transactions in an .iif and need them in QuickBooks Online, convert the file first: IIF to QBO writes a .qbo Web Connect file for Bank transactions → Link account ▾ → Upload from file, or IIF to CSV writes a CSV for the same upload screen. Lists (customers, vendors, accounts) have their own CSV and Excel imports in QuickBooks Online.

5. Open in Excel

Unlike a .qbo or .ofx, an IIF does open in Excel in readable columns, because it is tab-separated. Intuit even recommends a spreadsheet for reading its sample files. Intuit's steps:

1. In Excel, choose File → Open and browse to the file.
2. Change the file type dropdown to All Files (Excel hides .iif otherwise).
3. Select the .iif and click Open. In the Text Import Wizard click Next, Next and Finish.

Intuit's bulk-edit steps also use right-click → Open With → Excel. What you get is the file as written: three header rows, then a TRNS row, one or more SPL rows and an ENDTRNS row for each transaction. In the sample:

!TRNS	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO
!SPL	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO
!ENDTRNS
TRNS	CHECK	09/01/2026	Business Checking		-6420.18		ACH DEBIT GUSTO PAYROLL 0912
SPL	CHECK	09/01/2026	Payroll		6420.18		
ENDTRNS

That's fine for checking or editing, but it isn't a list you can sort, total or pivot: each transaction is spread over three or more rows and every SPL amount has the opposite sign. For that, see the next section.

If you edit and save: choose File → Save, answer Yes to keep the text format, and when Excel asks again on exit choose Don't Save, so the file stays tab-separated. If Excel only offers Text (Tab delimited) (*.txt), save that and rename the extension back to .iif. Intuit also notes Excel drops leading zeros (format those cells as Custom), and Excel can rewrite dates and long numbers. Sample IIF file lists the edits that break an import.

6. Google Sheets, Numbers and a clean list

For a spreadsheet you can actually work with, one row per transaction with the date, description, signed amount and the SPL account as a category, convert the file instead of opening it raw:

1. Upload the .iif to IIF to CSV (or IIF to Excel, the same file with Excel-first steps). The preview lists every transaction before you download.
2. Download the Clean CSV and open it in Excel, Google Sheets (File → Import → Upload) or Numbers.

The sample's first block above becomes this row:

Date,Description,Amount,Balance,Category
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18,,Payroll

Dates come out year first, the TRNS amount keeps its sign (money out is negative), a split becomes Split: Office Expenses 50.00; Postage 36.43, and Balance is empty because an IIF holds no balances. The whole sample comes out as 31 rows: 11 deposits totalling 29,597.43 and 20 payments totalling 28,575.27. A list-only IIF (customers, vendors, accounts) has no transactions to convert; open that one in Excel instead.

Google Sheets and Numbers may not recognise the .iif extension. To look at the raw file there, save a copy with a .txt or .tsv extension and import it with Tab as the separator; don't import the renamed copy back into QuickBooks.

7. Read it in a text editor

An IIF is plain text, so Notepad on Windows or TextEdit on a Mac opens it (right-click → Open With). The columns won't line up, because they're separated by single tab characters, but it's the quickest way to answer "what's in this file?":

• The first characters: !TRNS means transactions; !HDR, !ACCNT, !CUST or !VEND mean a list export.
• The ACCNT on each TRNS line: the bank or card account it will post to (Business Checking in the sample).
• The DATE column: US QuickBooks expects month first, like 09/01/2026.
• One ENDTRNS after every transaction. The sample has 97 lines: 3 headers, 31 TRNS, 32 SPL (one transaction is split) and 31 ENDTRNS.

Don't edit it in Word, and be careful in any editor that turns tabs into spaces: a tab is the column separator.

8. Open without QuickBooks

You don't need QuickBooks to see what's in an IIF. From most to least useful:

• Convert to CSV in the browser (IIF to CSV) and open it in Excel, Google Sheets or Numbers. Works on Windows, Mac and Chromebook; nothing to install.
• Open it in Excel as above, to see the raw TRNS and SPL rows.
• Move it to other software. Utilly isn't aware of other bookkeeping apps that import IIF directly, so convert it: IIF to QBO for QuickBooks Online and Web Connect, IIF to QIF for Quicken for Windows, or CSV for almost anything else.
• Read the text in Notepad or TextEdit.

Utilly doesn't ship a separate "IIF viewer"; the converter preview, which lists every transaction before you download, is the closest thing.

9. IIF to PDF

There's no direct ".iif to PDF" step, because an IIF has no page layout. Convert it to CSV, open it in Excel or Google Sheets, then use File → Print → Save as PDF (Windows: Microsoft Print to PDF; Mac: the PDF button in the print dialog; Sheets: File → Download → PDF). The result is a list of transactions, not a copy of anyone's bank statement.

10. Why it won't open

11. Convert your own .iif

Have the .iif and just want the transactions somewhere useful? Pick the output. Only have PDF statements? Start from the PDF instead.

Utilly isn't affiliated with Intuit or QuickBooks. Menu names change between versions; the paths above are from Intuit's help pages, checked November 9, 2026. Sources: Intuit, Export, import, and edit IIF files (Windows and Mac import and export steps, Excel steps, back up first, leading zeros, no technical support); Intuit, IIF Overview: import kit, sample files, and headers (ASCII TSV, limited error checking, missing accounts created as bank accounts, a spreadsheet recommended for reading); Intuit, Tasks you can do with IIF files (Open With → Excel). The sample file is fictional.

FAQ

Related guides

• Free sample IIF file for QuickBooks Desktop (bank and credit card)
• QuickBooks Desktop IIF import errors (File not imported, Review now, and how to fix them)
• How to open a .QBO file (QuickBooks Desktop, Online, Excel or no QuickBooks)
• QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need
• How to import bank transactions into QuickBooks Desktop after bank feeds stopped (2026)
• How to open an OFX, QFX or QIF file (Excel, Quicken, text)

Related tools

• Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
• Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.