Convert IIF to CSV — QuickBooks Desktop to Spreadsheet
QuickBooks Desktop exports IIF — most other software needs CSV. Convert in seconds and open in Excel, Google Sheets, or import into Xero, Wave, and FreshBooks.
Parses TRNS, SPL, and ACCNT sections. Free online — no signup.
How It Works
Upload Your IIF File
IIF exported from QuickBooks Desktop (Pro, Premier, Enterprise). Transaction lists, chart of accounts, and vendor/customer lists all supported.
Parsed to Columns
TRNS, SPL, and ACCNT rows parsed into labeled columns — date, account, name, amount, memo, doc number, and transaction type. Splits become individual rows.
Download CSV
One transaction per row with a header. Opens in Excel, Google Sheets, LibreOffice — or import directly into Xero, Wave, FreshBooks, or Sage.
What's Inside an IIF File
IIF uses tab-delimited rows with header/data pairs. Here's how a typical transaction looks.
Raw IIF File
!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT !SPL TRNSTYPE DATE ACCNT NAME AMOUNT !ENDTRNS TRNS CHECK 03/15/2026 Checking ACME Corp -450.00 SPL CHECK 03/15/2026 Office Exp ACME Corp 450.00 ENDTRNS
Tab-delimited, mixed headers and data
After Conversion to CSV
| Date | Account | Name | Amount |
|---|---|---|---|
| 03/15/2026 | Checking | ACME Corp | -450.00 |
| 03/15/2026 | Office Exp | ACME Corp | 450.00 |
Clean rows, labeled columns, ready to use
IIF Section Types We Parse
!TRNS/SPL
Transactions
Checks, deposits, transfers, journal entries
!ACCNT
Chart of Accounts
Account names, types, and descriptions
!CUST
Customers
Customer names, addresses, contacts
!VEND
Vendors
Vendor names, addresses, terms
!INVITEM
Items
Products, services, inventory items
!CLASS
Classes
Class tracking categories
Where Your CSV Works
Spreadsheets
Excel, Google Sheets, LibreOffice, Numbers
Cloud Accounting
Xero, Wave, FreshBooks, Sage, Zoho Books
Budgeting
YNAB, Monarch Money, Tiller
What is IIF?
Intuit Interchange Format
Tab-delimited text format for QuickBooks Desktop. Transactions use TRNS/SPL/ENDTRNS blocks with header rows prefixed by !. Only QuickBooks Desktop can import it.
What is CSV?
Comma-Separated Values
One row per transaction with labeled columns. Opens in any spreadsheet and imports into virtually any accounting software. The universal data exchange format.
Why This Tool
TRNS + SPL Parsing
IIF transaction blocks (TRNS, SPL, ENDTRNS) parsed into flat rows. Each split gets its own row with account, amount, and memo.
All IIF Section Types
Transactions, chart of accounts (ACCNT), customers (CUST), vendors (VEND), and item lists (INVITEM) — every section type your IIF contains is extracted.
Date & Amount Columns
DATE fields mapped to a clean date column. AMOUNT fields preserved with sign (positive/negative) for accurate debit/credit tracking in your spreadsheet.
Document References
DOCNUM (check numbers, invoice numbers) and MEMO fields carry through to dedicated CSV columns. Nothing dropped from the original IIF.
Multi-Transaction Files
IIF files with hundreds of TRNS/SPL/ENDTRNS blocks parsed completely. Every transaction, every split, one CSV.
Clean Header Row
CSV output starts with a labeled header row — Date, Account, Name, Amount, Memo, Type, Reference. Ready for filters and pivot tables.
When to Use This
QuickBooks Desktop Migration
Moving from QB Desktop to Xero, Wave, FreshBooks, or Sage? Export IIF, convert to CSV, and import into your new platform — CSV is the format they all accept.
Spreadsheet Analysis
Open years of QuickBooks Desktop data in Excel or Google Sheets. Build pivot tables by account and month, run SUMIF formulas, and create reports QB Desktop can't.
Archival & Backup
IIF only works in QuickBooks Desktop. Convert to CSV for a universal archive that's readable in any software, on any platform, decades from now.
IIF-to-CSV Issues & Fixes
CSV has mixed transaction and split rows — hard to read
IIF transactions have a TRNS row (main entry) and one or more SPL rows (splits). Both become CSV rows by design — filter by the "Row Type" column to see only TRNS or only SPL rows.
Amounts appear doubled — $450 debit showing as both -450 and +450
That's correct double-entry bookkeeping. The TRNS row shows -450 from Checking, and the SPL row shows +450 to Office Expenses. They're two sides of the same transaction.
File won't upload — "invalid IIF" error
IIF files must start with a ! header row (like !TRNS or !ACCNT). If the file was edited in a text editor, check that tabs weren't converted to spaces — IIF requires tab delimiters, not spaces.
Missing columns in CSV — no memo or reference number
Not all IIF exports include every field. If the original QuickBooks export didn't include MEMO or DOCNUM columns in the header row, those fields won't appear in the CSV.
Frequently Asked Questions
What is an IIF file?
IIF (Intuit Interchange Format) is a tab-delimited text format used exclusively by QuickBooks Desktop for importing and exporting transactions, chart of accounts, customers, and vendors. It uses TRNS/SPL/ENDTRNS blocks to represent transactions.
Can't I just open the IIF in Excel?
You can try — Excel's text import wizard will split on tabs. But you'll get raw TRNS/SPL/ENDTRNS rows mixed together, header rows with ! prefixes, and no separation between transactions and splits. Our converter flattens this into clean, labeled rows.
Does it handle split transactions?
Yes. IIF splits (SPL rows) become individual CSV rows with their own account, amount, and memo. The parent TRNS row ties them together so you can trace which splits belong to which transaction.
Will Xero accept the CSV output?
Yes. Xero's bank statement import accepts CSV with date, description, and amount columns. Same for Wave, FreshBooks, Sage, and YNAB — CSV is the universal import format they all support.
What about chart of accounts (ACCNT) data?
If your IIF contains !ACCNT sections (chart of accounts exports), those are parsed into their own rows with account name, type, and description columns.
Does it preserve the DOCNUM (check/reference number)?
Yes. The DOCNUM field from IIF maps to a reference number column in CSV. Invoice numbers, check numbers, and other document references all come through.
ProperConvert and SaasAnt also convert IIF. Why use yours?
No desktop install, no QuickBooks connection required, no file size limits. Upload the IIF file in your browser and download CSV — fully free with no transaction caps.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your IIF file is deleted immediately after conversion.
Related Tools
IIF to Excel
Convert QuickBooks Desktop IIF files to formatted Excel spreadsheets. View, edit, and share your QB Desktop data easily. Free, instant, no signup required.
Convert now →CSV to IIF
Convert CSV financial files to IIF for QuickBooks Desktop. Auto-detects columns and creates properly formatted IIF entries. Free, instant, no signup required.
Convert now →PDF to IIF
Convert bank statement PDFs to IIF for QuickBooks Desktop. AI creates properly formatted transaction entries from any bank. Free online, no signup.
Convert now →PDF to CSV
Extract transactions from bank statement PDFs to CSV. AI-powered, works with any bank in any language. Accurate date and amount extraction. Free, no signup.
Convert now →