Free IIF to Excel & CSV Accounting Ledger Converter
Convert QuickBooks IIF files into a clean Excel workbook. Each record type gets its own sheet, every TRNS/SPL transaction is checked for balance, account names and document numbers stay as text, and you can download a cleaned .iif for re-import. It all runs in your browser.
1. Add your IIF file
2. Excel options
3. File check
4. Excel preview
Quick answer: An IIF file is tab-separated text that QuickBooks Desktop uses for imports and list exports. To convert it to Excel, drop it into the tool above and download the .xlsx. Transactions, accounts, customers and vendors each get their own sheet, and every TRNS/SPL transaction is checked to make sure it adds up to zero. To open it by hand instead, use Excel's File > Open > All Files and pick Tab as the delimiter.
What Is an IIF File?
IIF stands for Intuit Interchange Format. It is a plain-text file that QuickBooks Desktop (Windows and Mac) uses to move data in and out of a company file. Each line is one record and each field is separated by a tab, so you can open an IIF file in Notepad, Excel or any spreadsheet program.
QuickBooks Desktop uses IIF files for:
- List exports and imports: the chart of accounts, customers, vendors, employees, items, classes, terms and other lists (File > Utilities > Export > Lists to IIF Files).
- Transaction imports: checks, deposits, invoices, bills, journal entries and more (File > Utilities > Import > IIF Files). QuickBooks does not export transactions to IIF, so a transaction IIF usually comes from another program, a payroll service or a bank tool.
IIF is not supported in QuickBooks Online. Intuit also notes that it does not offer technical support for creating or importing IIF files, and that an IIF import can't be undone, so check the file first.
How to Convert IIF to Excel
- Add the IIF file: Drop your .iif file into the box, choose it from your device, or paste the IIF text.
- Review the checks: The tool lists record types, transaction counts, unbalanced transactions, bad dates or amounts, and column-count problems.
- Pick the Excel options: Choose how dates and amounts are written and which sheets to include.
- Preview each sheet: Switch between the Transactions, Summary, list and IIF layout tabs to see exactly what goes into Excel.
- Download: Save an Excel (.xlsx) workbook, a CSV of the current sheet, or a cleaned .iif file ready to import back into QuickBooks Desktop.
The Excel workbook you download contains:
| Sheet | What's in it | Use it for |
|---|---|---|
| Transactions | Every TRNS and SPL line, with a transaction number, line type and all columns | Filtering by account, date or name; pivot tables |
| Transaction summary | One row per transaction: type, date, number, name, account, amount, split total, difference, status | Finding unbalanced or duplicate transactions |
| List sheets | One sheet per list type, such as Accounts, Customers, Vendors or Items | Reviewing or cleaning list data |
| IIF layout | The file exactly as QuickBooks reads it, all cells as text | Editing and saving back to .iif |
| Checks | Every problem found, with its line number | Fixing the file before import |
How to Open an IIF File in Excel
To open the file directly in Excel, without the converter:
- In Excel, go to File > Open > Browse.
- Change the file-type box from "All Excel Files" to All Files (*.*) and select the .iif file.
- In the Text Import Wizard, choose Delimited and click Next.
- Tick Tab as the delimiter and clear any other boxes.
- Select the columns that hold numbers you want to keep exactly, such as DOCNUM, ACCNUM or ZIP, and set them to Text.
- Click Finish.
In newer Excel versions you can also use Data > From Text/CSV, set Delimiter to Tab and choose Do not detect data types. Either way, all record types still share one grid, which the converter solves by giving each type its own sheet.
IIF File Structure: Headers, Records and Columns
An IIF file is built from header rows that start with ! and data rows that use the same keyword without it:
| Part | Meaning |
|---|---|
!TRNS, !SPL, !ENDTRNS | Header rows. They name the columns for the TRNS and SPL rows below them. |
TRNS | The first line of a transaction: its type, date, main account, name and total. |
SPL | Split lines: the other side of the entry, with the opposite sign. A transaction can have many. |
ENDTRNS | Closes the transaction. Every TRNS needs one. |
!ACCNT, !CUST, !VEND, !EMP, !INVITEM, !CLASS, !OTHERNAME | List headers for accounts, customers, vendors, employees, items, classes and other names. |
!HDR | Optional file header written by QuickBooks exports (product, version, date). |
The golden rule: TRNS amount + all SPL amounts = 0. In the example, −245.60 + 245.60 = 0.00. The column order can change from file to file; QuickBooks reads each value by its header, not by its position.
How IIF Data Appears in Excel
Opened directly, an IIF file looks like one long sheet. The header rows sit in column A with their column names beside them, followed by rows of data. Because TRNS and SPL rows share the grid with list rows, columns don't line up across sections: column F might be AMOUNT for transactions but EMAIL for customers.
The converter fixes this by reading each row with its own header. Transactions become a proper table with one header row, and each list gets its own sheet with the right column names. Header rows are coloured and frozen, and filters are switched on.
How to Edit IIF Data in Excel Without Breaking the Format
- Back up your QuickBooks company file. IIF imports can't be undone.
- Edit the IIF layout sheet from this tool, or the original .iif opened as tab-delimited text.
- Don't delete, move or rename header rows (the ones starting with
!). - Keep every transaction in the order TRNS → SPL lines → ENDTRNS, and keep TRNS + SPL totals at zero.
- Keep amounts plain, like
-1250.00: no currency symbols, thousands separators or brackets. - Keep dates in the format your QuickBooks uses (US files use month/day/year).
- Save with File > Save As > Text (Tab delimited) (*.txt), then rename the file from .txt to .iif. If Excel warns that some features will be lost, keep the text format.
- Drop the saved file back into this tool to check it before importing.
Don't save it as CSV. QuickBooks expects tabs, and CSV adds commas and quotation marks that break the import.
IIF to Excel: Preserving Dates, Amounts and Account Names
| Data | What goes wrong in plain Excel | What the converter does |
|---|---|---|
| Dates | 3/4/2026 may be read as 3 April or 4 March depending on your computer's region; ISO dates may stay as text | Detects month/day vs day/month order, then writes real Excel dates in the format you choose (or keeps the text) |
| Amounts | Values like 1,250.00 or ($45.00) stay as text and don't sum | Writes numbers with two decimals and negative values shown with a minus, and flags formats QuickBooks will reject |
| Document numbers | 00123 becomes 123 | Kept as text |
| Account names | Sub-accounts such as Utilities:Electric can look like times; 1-100 can turn into a date | Kept as text, exactly as typed |
| Long numbers | Account, card or tax ID numbers over 15 digits lose their last digits | Kept as text |
Why IIF Files Open as Tab-Separated Data in Excel
IIF was designed as a simple text exchange format. QuickBooks writes a tab between every field and a line break after every record, so the file stays readable in any text editor. Excel recognises the tabs and offers the Text Import Wizard, the same one used for .txt and .tsv files. Commas inside names and memos are fine, because they are not separators in IIF. That is also why converting IIF to CSV needs care: fields containing commas must be quoted, which this tool does for you.
How to Handle IIF Headers When Converting to Excel
- Several header blocks: one file can hold !ACCNT, !CUST and !TRNS headers one after another. The converter reads each data row with the header that matches its keyword, even if that header appeared much earlier.
- Different columns in TRNS and SPL: the Transactions sheet combines both header rows, so every column from either one gets its own Excel column.
- Missing headers: a data row whose keyword has no header can't be imported. It is listed as a red problem.
- Too many values: if a row has more values than its header has columns, the extra values are flagged. That usually means a stray tab inside a memo.
- !HDR rows: the file header written by QuickBooks exports is shown in the Checks sheet and kept in the IIF layout.
IIF to Excel Conversion for QuickBooks Data
Common reasons to convert QuickBooks IIF data to Excel:
- Review a transaction import from a payroll provider, POS system or bank tool before it reaches your books.
- Clean list exports, for example to fix vendor addresses or tax IDs, merge duplicate customers, or tidy account names.
- Move to another system: QuickBooks Online, Xero and most other accounting apps import Excel or CSV but not IIF.
- Audit and report: sum by account, filter by date range or find large entries with pivot tables.
Remember that IIF imports don't link transactions. An imported invoice and its payment still need to be linked in QuickBooks afterwards.
Common IIF to Excel Formatting Problems
| Problem | Cause | Fix |
|---|---|---|
| Everything is in column A | Opened with comma instead of tab as the delimiter | Reopen with Tab ticked, or use this converter |
| Leading zeros missing | Excel treats 00123 as a number | Set those columns to Text in the import wizard; the converter does this automatically |
| Dates swapped or shown as numbers | Different regional date settings | Choose the date order in the converter's options |
| Quotation marks around values after saving | Saved as CSV, or values contain tabs | Save as Text (Tab delimited); the cleaned .iif option removes stray quotes |
| Strange characters (é, ’) | Text encoding mismatch | The converter reads both UTF-8 and Windows-1252 and removes byte-order marks |
| Amounts don't add up | Amounts stored as text with $ or commas | Choose "Amounts: Numbers" and check the flagged cells |
| QuickBooks import error after editing | Header row changed, ENDTRNS missing, or transaction not balanced | Run the file through the checker and fix the red items |
How to Check Converted IIF Data Before Importing It Back to QuickBooks
Drop the edited .iif back into the tool and confirm:
- Every data row has a header: no red "no header" items.
- Every TRNS has an ENDTRNS, and no SPL lines sit outside a transaction.
- Unbalanced = 0: each transaction's TRNS and SPL amounts add up to 0.00.
- Dates and amounts are clean: no ISO dates, currency symbols, thousands separators or bracket negatives.
- Accounts exist: account names used in transactions match your chart of accounts exactly, including the colon for sub-accounts. A misspelling can create an unwanted new account.
- Counts match what you expected: number of transactions, split lines and list records.
- Back up the company file, then import with File > Utilities > Import > IIF Files, and review a few transactions in the register straight after.
The Cleaned .iif button writes a copy with Windows line endings, no byte-order mark, no stray quotation marks, plain amounts and month/day/year dates. It does not change which accounts are used or rebalance transactions; fix those yourself.
IIF to Excel Converter FAQs
What is an IIF file?
IIF (Intuit Interchange Format) is a plain-text, tab-separated file that QuickBooks Desktop uses to import and export lists such as accounts, customers, vendors and items, and to import transactions. Header rows start with an exclamation mark, for example !TRNS or !ACCNT, and name the columns for the rows below them.
How do I convert an IIF file to Excel?
Drop the .iif file into the converter above and click Download Excel (.xlsx). You get a workbook with a transactions sheet, a one-row-per-transaction summary, a sheet for each list (accounts, customers, vendors and so on), an IIF layout sheet and a checks sheet. The file is read in your browser and never uploaded.
Can I open an IIF file directly in Excel?
Yes. In Excel choose File > Open, set the file type to All Files, pick the .iif file and finish the Text Import Wizard with Tab as the delimiter. The data opens, but the !TRNS, !SPL and list headers all land in one grid, and Excel may turn account numbers, document numbers and dates into the wrong values. The converter separates each record type onto its own sheet and keeps those values as text.
Why does an IIF file open as tab-separated data?
An IIF file is a text file where each field is separated by a tab character and each record is one line. Excel treats it like any other tab-delimited text file, which is why the Text Import Wizard appears and why everything lines up in columns.
Can I edit IIF data in Excel and import it back into QuickBooks?
Yes, if you keep the format. Edit the IIF layout sheet (or the original file opened in Excel), keep header rows and the TRNS, SPL, ENDTRNS order, keep dates and amounts plain, then save as Text (Tab delimited) and rename the file to .iif. Always back up your company file first, because an IIF import cannot be undone.
Why do my TRNS and SPL amounts need to add up to zero?
Each IIF transaction is a double-entry record. The TRNS line holds one side and the SPL lines hold the other side with the opposite sign, so a balanced transaction adds up to 0.00. The checker lists every transaction where the total is not zero so you can fix it before importing.
Does QuickBooks Online support IIF files?
No. Intuit says IIF import and export are for QuickBooks Desktop. For QuickBooks Online, convert the data to Excel or CSV and use its own import tools, or use a third-party import app.
Will the converter keep leading zeros and account names?
Yes. Document numbers, account numbers, ZIP codes and names are written as text cells, so 00123 stays 00123 and an account such as Utilities:Electric keeps its colon. Only amount, quantity, price and balance columns become numbers, and dates become real Excel dates unless you choose to keep them as text.
Is my accounting data uploaded?
No. The IIF file is read and the Excel file is built by your browser. No account names, amounts or customer details are sent to iLoveTool4.
Resources and Sources
- Export, import, and edit IIF filesIntuit: menu paths, editing in Excel and backup warning.
- IIF Overview: import kit, sample files, and headersIntuit: header rows and sample IIF files.
- Tasks you can do with IIF filesIntuit: what IIF can be used for.
- Intuit Interchange Format (Wikipedia)Background on the IIF file format.
- Import or export text (.txt or .csv) filesMicrosoft Support: the Text Import Wizard and saving as tab-delimited text.
Related Tools
Last reviewed: September 2026.