What IIF export file format does this tool accept?

This tool accepts IIF File (QuickBooks Desktop) files. Export from IIF and upload the Desktop) file directly.

Can I convert IIF CSV to CSV?

Yes, this tool converts IIF File (QuickBooks Desktop) exports directly to CSV Spreadsheet format compatible with CSV.

How do I import IIF file (quickbooks to CSV?

Export your file (quickbooks from IIF, upload the CSV file to this converter, then import the converted file to CSV.

Convert IIF to CSV | IIF to Spreadsheet

🥦

CSV Spreadsheet Format

valid rows

Extract all transaction fields from QuickBooks Desktop IIF files into a clean CSV spreadsheet. Account, Class, and all other fields stay in their own columns. Your data never leaves your browser.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample IIF

Valid IIF file with sample transactions

Sample IIF File

How to Convert IIF to CSV

Export from Banking

File → Utilities → Export → Lists to IIF Files

Upload and Configure

Upload IIF QuickBooks Transactions CSV and choose IIF Bank Export (CSV) format

Preview and Download

Review converted data, download Csv-ready file

Open in spreadsheet

Open the CSV file in Excel, Google Sheets, or any spreadsheet application

Output is in CSV Spreadsheet format — ready to import directly, no manual reformatting needed.

How People Use IIF to CSV

Two of my clients needed their QuickBooks Desktop transaction history in spreadsheet form for an audit. I exported the IIF files and converted them to CSV with all nine fields separated into columns. The Account and Class columns stayed intact, which made the auditor's review straightforward.

I needed to view my IIF transactions in a spreadsheet but opening the file directly in Excel gave me garbled TRNS and SPL markers. Converting the IIF to CSV extracted only the transaction rows with clean columns for Date, Amount, and Payee. Finally readable data.

Our construction company tracks expenses by class in QuickBooks Desktop. When I converted the IIF export to CSV, the class tracking column was preserved perfectly. I used the spreadsheet to build pivot tables for job costing analysis that QuickBooks reports couldn't handle.

IIF to CSV Conversion Questions

What columns does the CSV output include?

The CSV includes 9 columns: Date, Type, Account, Amount, Payee, Memo, Document Number, Class, and Cleared.

What IIF transaction types are supported?

All IIF transaction types are supported including CHECK, DEPOSIT, GENERAL JOURNAL, INVOICE, BILL, CREDIT MEMO, and more. The type is preserved in the Type column.

Is my financial data safe?

All conversion happens entirely in your browser. Your IIF file is never uploaded to our servers.

Why Use the IIF to CSV Converter?

All Fields Separated

Account, Class, Payee, and Memo each get their own column for flexible analysis

Account Names Preserved

QuickBooks Desktop account names are kept in their own column for reconciliation

Class Tracking Kept

QuickBooks class assignments are preserved in a dedicated column

Document Numbers

Check numbers, invoice numbers, and other document references are preserved

Browser-Based Security

All processing happens in your browser - your financial data never leaves your computer

Clean Extraction

Extracts only transaction rows (TRNS) - skips split lines and headers for clean output

Why Convert IIF to CSV?

IIF Files Are QuickBooks Desktop Only

IIF (Intuit Interchange Format) is a proprietary QuickBooks Desktop format: - QuickBooks-only: IIF files are designed exclusively for QuickBooks Desktop - Tab-delimited: Special headers and tabs confuse standard CSV readers - Complex structure: TRNS/SPL/ENDTRNS blocks are hard to parse manually Converting to CSV extracts your transaction data into a clean spreadsheet format.

What This Tool Does

We extract every field from your IIF file into separate CSV columns with all 9 fields separated: Date, Type, Account, Amount, Payee, Memo, Document Number, Class, and Cleared. Every field gets its own column for maximum spreadsheet flexibility.

Field Mapping

How Banking Iif fields map to Csv Bank Export

Banking Iif	Source Value		Csv Bank Export	Target Value	Note
`DATE`	`01/18/2025`	→	`Date`	`01/18/2025`	IIF date (MM/DD/YYYY) → MM/DD/YYYY
`TRNSTYPE`	`CHECK`	→	`Type`	`CHECK`	Transaction type (CHECK, DEPOSIT, etc.)
`ACCNT`	`Checking`	→	`Account`	`Checking`	Account name from QuickBooks Desktop
`AMOUNT`	`-150.50`	→	`Amount`	`-150.50`	Signed amount (negative for expenses, positive for income)
`NAME`	`Amazon.com`	→	`Payee`	`Amazon.com`	Payee/vendor/customer name (kept separate)
`MEMO`	`Office supplies order`	→	`Memo`	`Office supplies order`	Transaction memo (kept separate)
`DOCNUM`	`1234`	→	`Document Number`	`1234`	Check or invoice number
`CLASS`	`Operations`	→	`Class`	`Operations`	QuickBooks class tracking
`CLEAR`	`N`	→	`Cleared`	`N`	Cleared status (Y/N)

Your IIF to CSV Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

Data Transformation

Multiple IIF rows (TRNS + SPL) become one CSV row with all fields separated

Tab-delimited TRNS header + SPL splits

Key columns: TRNS row (header), SPL row(s) (splits), ENDTRNS (delimiter)

N:1 — Multiple input rows aggregate to one output row

Spreadsheet row with all fields in separate columns

Date Extract date from TRNS row

Type Transaction type in separate column

Account Account name in separate column

Amount Extract amount from TRNS row

Payee Payee name in separate column

Memo Memo in separate column

Amounts must be numeric; dates must be valid

Common IIF Bank Export (CSV) Import Errors

Issues you might encounter when importing IIF QuickBooks Transactions data to IIF Bank Export (CSV) - and how we solve them

Invalid IIF File

File is not a valid tab-delimited IIF format

CSV file with commas or corrupted IIF

Valid IIF file from QuickBooks Desktop

Ensure you're exporting IIF format from QuickBooks Desktop

Go to QuickBooks Desktop -> File -> Utilities -> Export -> Lists to IIF Files

Missing !TRNS Header

IIF file doesn't contain required !TRNS header row

IIF without !TRNS line

!TRNS TRNSTYPE DATE ACCNT ...

IIF files must start with header rows (!TRNS, !SPL, !ENDTRNS)

Re-export from QuickBooks Desktop ensuring IIF format is selected

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

The CSV includes 9 columns: Date, Type, Account, Amount, Payee, Memo, Document Number, Class, and Cleared.

This tool extracts only the TRNS (transaction header) rows, which contain the primary transaction data. SPL (split) rows are skipped since they represent the double-entry counterpart.

This tool is designed for IIF transaction files (those with !TRNS headers). List files (customers, vendors, items) use different headers and are not currently supported.

All IIF transaction types are supported including CHECK, DEPOSIT, GENERAL JOURNAL, INVOICE, BILL, CREDIT MEMO, and more. The type is preserved in the Type column.

All conversion happens entirely in your browser. Your IIF file is never uploaded to our servers.