Convert IIF to CSV

Convert IIF file to CSV free online. Export QuickBooks IIF transactions, journal entries, accounts, classes, items, and list data to an Excel-ready CSV spreadsheet without QuickBooks.

QuickBooks IIF files are useful for moving data out of QuickBooks Desktop, but they are not friendly when you need to inspect a client export, clean old transactions, or prepare a spreadsheet for another accounting system. This IIF to CSV converter reads the tab-delimited IIF structure, keeps the useful QuickBooks fields, and creates a clean CSV you can open in Excel, Google Sheets, LibreOffice, Numbers, or an import-mapping workflow.

What is an IIF file?

IIF stands for Intuit Interchange Format. QuickBooks Desktop uses it to import and export accounting data such as accounts, customers, vendors, items, classes, invoices, bills, checks, deposits, journal entries, and transaction split lines. An IIF file is usually tab-delimited text with header rows such as !TRNS and !SPL followed by data rows such as TRNS, SPL, and ENDTRNS.

Why use this IIF to CSV converter

Many simple tools only flatten a few transaction fields. This converter is built for practical bookkeeping work: it reads IIF table headers, preserves transaction and split rows, can export all records or transaction rows only, supports account type, class, memo, document number, cleared status, item details, source row numbers, source file names, merged batch output, debit and credit columns, and Excel-friendly UTF-8. Those details matter when a bookkeeper needs to explain a journal entry or an accountant needs to verify a QuickBooks export before migration.

How to convert IIF to CSV

The converter gives you a readable spreadsheet without requiring QuickBooks Desktop.

IIF to CSV features

The tool focuses on practical QuickBooks data extraction, not just a plain text dump.

• Converts QuickBooks IIF files into Excel-ready CSV spreadsheets.
• Reads tab-delimited IIF header rows such as !TRNS, !SPL, !ACCNT, !INVITEM, !CUST, and other tables.
• Exports TRNS and SPL transaction rows for checks, deposits, bills, invoices, payments, and journal entries.
• Can export all IIF data rows when you need account lists, item lists, class lists, customer data, or vendor data.
• Preserves useful fields such as date, transaction type, account, name, class, amount, document number, memo, clear status, account type, item, quantity, and price.
• Supports single amount or separate debit and credit columns.
• Supports ISO, US, EU, and source date output.
• Adds IIF table and record type columns so TRNS, SPL, and list rows stay understandable.
• Adds source row number and source file columns for audit trails and batch conversion.
• Adds an extra fields column for values that do not fit the main spreadsheet columns.
• Shows a live preview with record count, transaction rows, split rows, table count, net amount, and sample rows.
• Warns about empty files, missing transaction rows, missing headers, split rows, and multi-table exports.

When IIF to CSV conversion helps

Use this converter when QuickBooks Desktop data needs to be reviewed outside QuickBooks.

• An accountant receives a QuickBooks IIF export and needs a spreadsheet for review.
• A bookkeeper needs to inspect TRNS and SPL rows before importing data.
• A small business is moving from QuickBooks Desktop to another accounting app.
• A client sends an IIF file, but you do not have QuickBooks installed on the current machine.
• You need to extract accounts, classes, items, customers, or vendors from an IIF file.
• You want a CSV archive of QuickBooks Desktop export data.
• You need to check journal entry detail and split lines before migration.
• You want to batch convert several IIF files for cleanup in Excel.

IIF to CSV versus opening IIF directly

An IIF file is structured for QuickBooks import and export, not for normal spreadsheet review. CSV gives you a familiar table with columns you can filter, sort, audit, and map into another system. A good CSV export also helps you spot bad dates, missing memos, unusual accounts, and split rows before you trust the data in a new accounting workflow.

Tips for better IIF to CSV results

These checks come from real QuickBooks cleanup and migration work.

• Keep IIF table and record type columns on when reviewing journal entries or split transactions.
• Use all-record export when the IIF contains accounts, customers, vendors, items, or classes instead of only transactions.
• Use ISO dates when the CSV will be imported into another accounting app.
• Use debit and credit columns when sharing the file with accountants who review entries by side.
• Turn on source row numbers before investigating a broken or rejected IIF import.
• Keep the extra fields column on when you are not sure which QuickBooks table the file contains.
• If Excel shows garbled characters, keep the UTF-8 marker enabled and reopen the CSV.

Turn QuickBooks IIF into a clean CSV

If you need to review, clean, migrate, or archive QuickBooks IIF data, upload the file above and create an Excel-ready CSV.

Use the preview, keep the context columns you need, and store the original IIF beside the converted CSV for audit and migration records.