Convert IIF to Excel — Formatted & Pivot-Ready
Turn QuickBooks Desktop IIF exports into formatted Excel workbooks — typed dates, real numbers, and clean columns for pivot tables, formulas, and sharing with your accountant.
Works with all QuickBooks Desktop IIF exports. 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 exports all supported.
Typed & Formatted
Dates become real Excel dates, amounts become numbers, accounts and memos stay as text. TRNS/SPL blocks flattened into sortable rows with a labeled header.
Download XLSX
Formatted workbook ready for pivot tables, SUMIF, and charts. Opens in Excel, Google Sheets, LibreOffice, or Numbers.
What Happens When You Open IIF in Excel
Excel's text import splits on tabs, but you still get a mess of mixed row types.
Raw IIF in Excel (Text Import)
!TRNS TRNSTYPE DATE ACCNT !SPL TRNSTYPE DATE ACCNT !ENDTRNS TRNS CHECK 03/15/26 Checking SPL CHECK 03/15/26 Office Exp ENDTRNS TRNS DEPOSIT 03/16/26 Checking SPL DEPOSIT 03/16/26 Income ENDTRNS
! headers, ENDTRNS rows, text dates — unusable
After Conversion to XLSX
| Date | Account | Name | Amount |
|---|---|---|---|
| 03/15/2026 | Checking | ACME Corp | -450.00 |
| 03/15/2026 | Office Exp | ACME Corp | 450.00 |
| 03/16/2026 | Checking | Deposit | 1,250.00 |
Typed columns, sortable, pivot-ready
Excel or CSV — Which Do You Need?
Excel XLSX (This Tool)
- Typed dates and amounts — formulas work
- Pivot tables, charts, SUMIF, VLOOKUP
- Best for analysis and sharing
- Opens in Excel, Sheets, LibreOffice
CSV (Plain Text)
- Everything stored as text strings
- Max compatibility for software import
- Best for data migration to Xero, Wave, etc.
- Use IIF to CSV instead
What You Can Do With the XLSX
Sort & Filter
Filter by account, date range, or transaction type. Sort by amount to find largest expenses.
Pivot Tables
Summarize spending by account and month. Drag and drop to build reports QB Desktop can't.
Formulas
SUMIF by account, VLOOKUP across sheets, conditional formatting for outliers.
What is IIF?
Intuit Interchange Format
Tab-delimited text for QuickBooks Desktop. TRNS/SPL/ENDTRNS blocks with ! header rows. Only QB Desktop can import it — Excel shows raw mixed rows if you try to open it directly.
What is XLSX?
Microsoft Excel Open XML Spreadsheet
Formatted workbook with typed cells — dates sort chronologically, amounts are summable, text stays text. Pivot tables, charts, and formulas work immediately.
Why This Tool
Typed Date Cells
IIF dates become real Excel dates. Sort by date, filter by month — no manual parsing.
Amounts as Numbers
SUM, SUMIF, and pivot tables work immediately. No "number stored as text" warnings.
TRNS + SPL Flattened
Transaction blocks parsed into flat rows. Filter by Row Type to see TRNS or SPL separately.
All IIF Sections
Transactions, chart of accounts, customers, vendors, items, and classes all extracted.
Document References
Check numbers, invoice numbers, and memos carry through to dedicated columns.
Clean Header Row
Date, Type, Account, Name, Amount, Memo, Reference — ready for filters and VLOOKUP.
When to Use This
Share With Your Accountant
Not everyone has QuickBooks Desktop. Convert IIF to XLSX and send a spreadsheet anyone can open.
Custom Reports & Analysis
Pivot tables by account and month, SUMIF formulas, and charts QB Desktop's reports can't produce.
QB Desktop Sunset Archive
QB Desktop 2023 loses support May 2026. Export IIF to Excel now as a universal archive.
IIF-to-Excel Issues & Fixes
Dates appear as text instead of real Excel dates
IIF date formats vary (MM/DD/YY vs MM/DD/YYYY) depending on your QB Desktop settings. Our converter normalizes these to proper Excel date cells. If you opened the IIF manually in Excel, dates stay as text strings.
TRNS and SPL rows mixed together — can't tell them apart
Each row has a "Row Type" column (TRNS or SPL). Use Excel's filter to show only TRNS rows for a clean transaction list, or only SPL rows to analyze account-level splits.
Amounts look doubled — $500 and -$500 for the same transaction
Correct double-entry behavior. The TRNS row shows the debit (-500 from Checking), and the SPL row shows the credit (+500 to Rent Expense). Filter to TRNS-only for a single-entry view.
File won't upload — "invalid IIF" error
IIF files must start with a ! header row (like !TRNS or !ACCNT). If the file was edited, check that tabs weren't converted to spaces — IIF requires tab delimiters.
Frequently Asked Questions
Can't I just open the IIF file in Excel?
You can use Excel's text import wizard (File > Open, select Tab as delimiter). But you'll get raw TRNS/SPL/ENDTRNS rows mixed together, ! header rows, and no typed columns — dates and amounts are all plain text. Our converter produces a clean, formatted workbook with proper data types.
Why Excel instead of CSV?
CSV stores everything as text strings. Excel (XLSX) has typed cells — dates you can sort chronologically, amounts you can SUM and pivot on, and text that stays text. No "number stored as text" warnings, no date reformatting needed.
Does it handle split transactions?
Yes. IIF splits (SPL rows) become individual Excel rows with their own account, amount, and memo. A Row Type column lets you filter TRNS rows from SPL rows.
Can I share this with my accountant?
Yes — that's one of the main use cases. Not everyone has QuickBooks Desktop. Convert IIF to XLSX and send a formatted spreadsheet anyone can open.
Does it parse chart of accounts (ACCNT) exports?
Yes. If your IIF contains !ACCNT sections, account names, types, and descriptions are extracted into their own sheet or rows.
QuickBooks Desktop is being discontinued. Can I archive my data this way?
Yes. Export IIF from QB Desktop, convert to Excel, and you have a universal archive. XLSX files are readable in any spreadsheet software — no QuickBooks needed to access your data in the future.
Transaction Pro and ProperConvert also do this. Why use yours?
No desktop install, no QuickBooks connection required, no 10-transaction trial limit. Upload in your browser and download XLSX — fully free with no 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 CSV
Convert QuickBooks Desktop IIF files to CSV for spreadsheets and analysis. Extracts all transaction fields and account data. Free, instant, no signup required.
Convert now →PDF to Excel
Turn bank statement PDFs into formatted Excel spreadsheets. Keeps all columns, headers, and transaction details. Any bank, any language. Free, no signup.
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 →CSV to Excel
Convert CSV files to formatted Excel (XLSX) spreadsheets with proper columns and headers. Opens in Excel and Google Sheets. Free, instant, no signup required.
Convert now →