Convert IIF to CSV or Excel

How to convert an IIF file to CSV

1. Get the IIF. From QuickBooks Desktop: File → Utilities → Export → Lists to IIF Files (lists only), or reuse an .IIF you already built for import, a file from Review now after a failed import, or one written by a converter. Intuit's own import help covers the format; our sample IIF file shows a working bank file.
2. Upload it above. Each TRNS / SPL / ENDTRNS block becomes one row. The TRNS amount keeps its sign; bank and credit card types are told apart from TRNSTYPE.
3. Check the preview. Spending should show as negative. If day and month look swapped, choose a day-first date format there.
4. Download the Clean CSV. It opens straight in Excel, Numbers or Google Sheets. For a workbook, use File → Save As → Excel Workbook (.xlsx) in Excel.

From IIF rows to spreadsheet columns

A split purchase in our sample QuickBooks Desktop IIF (made-up data):

!TRNS	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO
!SPL	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO
!ENDTRNS
TRNS	CHECK	09/03/2026	Business Checking		-86.43		POS PURCHASE OFFICE DEPOT #1123
SPL	CHECK	09/03/2026	Office Expenses		50.00		
SPL	CHECK	09/03/2026	Postage		36.43		
ENDTRNS

is this row in the CSV:

Date,Description,Amount,Balance,Category
2026-09-03,POS PURCHASE OFFICE DEPOT #1123,-86.43,,Split: Office Expenses 50.00; Postage 36.43

The sample file's 31 rows come to 11 Sales, 12 Office Expenses, 2 Payroll, 2 Utilities, 2 Contract Labor, 1 Rent and 1 split, ready for a pivot table by Category.

Which IIF files work

• Transaction IIFs with !TRNS / !SPL / !ENDTRNS headers and matching data rows. Column order can vary; we read the header names.
• Bank types (CHECK, DEPOSIT, …) and card types (CREDIT CARD, CCARD REFUND). Card files keep charges negative and refunds positive when signed that way.
• Files with several accounts (different TRNS ACCNT values): one tab and one CSV per account, plus a combined CSV whose first column is the Account.
• List-only IIFs (accounts, customers, vendors with no TRNS rows) are refused with a message — there's nothing to put in a transaction CSV.
• Free up to 100 transactions per file; files up to 20,000 transactions.

Common problems

Other conversions

• Have an MT940 (.sta) statement from a European bank? The MT940 to CSV converter reads :61:/:86: bookings and checks each statement against its opening and closing balance.
• Have a camt.053 (ISO 20022 XML) statement? The CAMT.053 to CSV converter reads those bank-to-customer XML files and checks each statement against its booked opening and closing balances.
• Want the Excel walkthrough instead? The IIF to Excel converter downloads the same Clean CSV with Excel-first steps (open in Excel, Save As .xlsx).
• Just need to open or view the .IIF? How to open an .IIF file covers QuickBooks Desktop (Windows and Mac), Excel's Text Import Wizard and opening it without QuickBooks.
• Need a QuickBooks Web Connect .qbo (Online or a supported Desktop version)? The IIF to QBO converter writes Web Connect from the same IIF.
• Need a Quicken .qif for Windows File Import? The IIF to QIF converter writes a bank or card QIF from the same IIF.
• Going back into QuickBooks Desktop? Check the file with the IIF file checker, or see IIF import errors. To build an IIF from a spreadsheet, use CSV to IIF.
• Have a Quicken .qif instead? The QIF to CSV converter keeps Quicken categories the same way.
• Have an .ofx, .qfx or .qbo? Use OFX / QFX to CSV or .QBO to CSV.
• Only have PDF statements? The bank statement PDF to CSV converter checks every statement against its balances.
• Not sure which file you have? See QBO vs IIF vs QIF and the sample IIF file guide.