IIF to CSV converter
Open a QuickBooks .iif export as a spreadsheet — dates, names, memos and signed amounts in a plain CSV or Excel file.
Drop your .iif file here
IIFCSV or click to choose a file
100% private · never uploadedIntuit Interchange Format — the tab-delimited list format QuickBooks Desktop uses for bulk transaction import.
Plain comma-separated text. The universal import format for Xero, Wave, FreshBooks and QuickBooks Online.
IIF opens in a spreadsheet, and immediately makes no sense
An IIF is tab-delimited, so Excel will open it — and show you a jumble of !TRNS, !SPL and !ENDTRNS header rows interleaved with data, where every transaction spans three lines and each half appears twice with opposite signs. Filtering, summing or charting it in that shape is not practical.
This converter reads the header rows to learn the column order, keeps the TRNS lines (the transactions) and drops the SPL lines (the balancing halves), and gives you one clean row per transaction.
Column order is read from the file, not assumed
IIF column order is declared by the !TRNS header line and it genuinely varies between exporters — some put MEMO before AMOUNT, some add DOCNUM and CLASS. A converter with hard-coded positions silently produces garbage on any file that differs. We parse the !TRNS header and map by name, so a non-standard column order converts correctly.
What you get back
Date, description (the NAME and MEMO fields joined), and a signed amount — negative for money out. The balance column stays empty because IIF does not record one. Take the Excel download if you want numeric amounts for formulas, or JSON for scripting.
Nothing is uploaded
The file is read in this browser tab with JavaScript and converted on your machine. There is no upload, no queue, no server-side copy and no account to create. A transaction export carries your account number, your salary and everyone you pay — the safest converter is the one that never receives the file at all.
You can verify it: open your browser devtools, switch to the Network tab, and convert a file. Your file is not among the requests — the only traffic is an anonymous analytics ping that records that a conversion happened, never what was in it.
Starting from a PDF statement instead of a file? The PDF bank statement converter reads the statement itself and exports CSV directly, so you do not need a IIF in the middle. Both tools run in the same tab, and neither uploads anything — here is how that works.
IIF to CSV, answered
How do I open an IIF file without QuickBooks?
Convert it here. The IIF is read in your browser and returned as a CSV or Excel file that opens anywhere. No QuickBooks licence and no install.
Why does my IIF have two lines per transaction?
Double-entry. The TRNS line is the transaction, the SPL line is its balancing half with the opposite sign. We keep the TRNS lines and drop the SPL lines so each transaction appears once, which is what you want in a spreadsheet.
Does it handle list data — customers, vendors, accounts?
No. IIF can carry list records (!CUST, !VEND, !ACCNT) alongside transactions. This converter reads transaction records only and ignores the rest.
Can I convert the CSV back into an IIF afterwards?
Yes — the CSV to IIF converter takes the same columns and writes the balancing splits back in, so a round trip works.
Is there a file size limit?
No fixed one. Conversion runs on your own machine, so the limit is your available browser memory rather than an upload cap.
Every format pair we convert
The same private, in-browser conversion for each one.