Convert IIF to CSV | IIF to Spreadsheet

🥦

Convert Complete

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

1

Export from Banking

File → Utilities → Export → Lists to IIF Files

2

Upload and Configure

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

3

Preview and Download

Review converted data, download Csv-ready file

4

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.

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

Input IIF Transaction Block

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
Output CSV Row aggregated rows per input

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.

Banking → Csv Data Ecosystem

All available data flows from Banking to Csv

Banking IIF QuickBooks Transactions Intuit Interchange Format for QuickBooks Desktop (tab-delimited)
→
Csv IIF Bank Export (CSV) All IIF transaction fields exported as separate CSV columns for spreadsheet analysis
DATE → Date TRNSTYPE → Type ACCNT → Account
QuickBooks Desktop data migration, banking analysis, custom reporting Current tool
Banking OFX/QFX/QBO Bank Transactions Bank and credit card transactions in Open Financial Exchange format
→
Csv OFX Bank Export (CSV) All OFX transaction fields exported as separate CSV columns for spreadsheet analysis
DTPOSTED → Date TRNTYPE → Type TRNAMT → Amount
Banking data analysis, reconciliation, custom reporting
Banking OFX/QFX/QBO Bank Transactions Bank and credit card transactions in Open Financial Exchange format
→
Csv OFX Bank Export (CSV) All OFX transaction fields exported as separate CSV columns for spreadsheet analysis
DTPOSTED → Date TRNTYPE → Type TRNAMT → Amount
Banking data analysis, reconciliation, custom reporting
Banking QIF Bank Transactions Quicken Interchange Format transactions for bank and credit card accounts
→
Csv QIF Bank Export (CSV) All QIF transaction fields exported as separate CSV columns for spreadsheet analysis
D → Date T → Amount P → Payee
Banking data analysis, Quicken data migration, custom reporting

Learn More:

vs MoneyThumb vs Big Red Consulting vs ProperSoft Export Transactions Guide