Free online IIF to XLS converter

QuickBooks Desktop exports accounting records as IIF, but spreadsheet-based reporting, reconciliation, and older business systems may require an Excel workbook. Converting a copy to XLS makes the tabular data easier to filter and share while preserving the original IIF for possible QuickBooks imports.

What the IIF format is

IIF means Intuit Interchange Format. In accounting software, it is a plain-text, tab-delimited format used mainly by QuickBooks Desktop to import and export accounts, customers, vendors, items, invoices, bills, checks, payments, and journal entries.

An IIF file is not a spreadsheet and does not contain a complete QuickBooks company database. Transaction exports commonly use technical record markers such as !TRNS, !SPL, and !ENDTRNS. A single invoice, bill, or journal entry can therefore occupy several rows: one transaction header followed by one or more split lines. The usual extension is .iif.

What the XLS format is

XLS is Microsoft Excel's legacy binary workbook format, used by Excel 97–2003 and still accepted by some older accounting and business applications. It stores worksheets with cells, formatting, formulas, filters, sorting, and basic charts, making the imported records easier to inspect than raw tab-delimited text.

An XLS worksheet supports a maximum of 65,536 rows and 256 columns. Use XLSX instead when the receiving program supports it, especially for large exports or workbooks that need newer Excel features.

Convert IIF with Microsoft Excel

1. Make a backup copy of the .iif file. Do not alter the only copy if it may later be imported into QuickBooks.
2. Open Excel and select Data → From Text/CSV. In older Excel versions, use Data → From Text or open the file through File → Open with text files enabled.
3. Select the IIF file. If Excel does not display the .iif extension, rename the copy to filename.txt. Renaming only changes the filename extension; it does not perform the conversion.
4. In the import dialog, choose Tab as the delimiter and disable comma, semicolon, and other delimiters unless the preview shows that the file uses them. Select the source encoding, such as UTF-8 or the applicable Windows code page.
5. Set account numbers, customer or vendor IDs, transaction IDs, ZIP codes, and other identifier columns to Text. This preserves leading zeroes and prevents long values from being displayed in scientific notation. Check date, currency, debit, and credit columns before loading.
6. Load the data into a worksheet. Select File → Save As, choose Excel 97-2003 Workbook (*.xls), and accept Excel's compatibility warning.
7. Reopen the saved workbook and compare representative dates, amounts, names, row counts, and key totals with the source export.

Convert IIF with LibreOffice Calc

1. Open a copy of the IIF file in Calc. If the .iif extension is not recognized, rename the copy to filename.txt.
2. In the Text Import dialog, select the correct character encoding and choose Separated by: Tab. Clear comma and semicolon separators unless the preview confirms they are required.
3. Assign identifier columns the Text type and inspect date and amount columns in the preview. Confirm that each tab-separated field appears in its own column.
4. Choose File → Save As, select Excel 97-2003 (*.xls), and confirm the format warning.
5. Reopen the XLS file and check the imported values before sharing or using it for reconciliation.

Excel and Calc import the IIF as tabular text; neither application reconstructs QuickBooks transaction objects or relationships during this process.

Convert the file on 101convert.com

You can convert the file for free on 101convert.com without installing software. Upload the IIF file, select XLS as the output format, start the conversion, and download the resulting workbook. Keep the original IIF and verify the output after downloading.

Because IIF files can contain customer addresses, tax information, account details, and transaction amounts, use local Excel or Calc for confidential records when possible. If an online conversion is used, check the service's file-retention and deletion terms before uploading.

Quality and compatibility checks

Conversion changes tab-delimited records into spreadsheet cells; it does not validate bookkeeping, create a normalized report, or produce a QuickBooks company file. Technical rows such as !TRNS and !SPL may remain visible in one worksheet rather than becoming separate invoice, account, and payment tables.

One accounting transaction can contain several IIF rows, so sorting or totaling individual rows without accounting for the TRNS/SPL structure can produce incorrect results. Compare transaction counts, debit and credit totals, and selected balances with QuickBooks or the source report.

Inspect dates, negative-value conventions, currency symbols, blank fields, duplicate records, character encoding, long numbers, and values beginning with zero. Spreadsheet import can reinterpret dates and numbers, round displayed precision, or change text encoding. If the workbook exceeds the XLS row or column limits, split the data or save it as XLSX.

If the destination is QuickBooks, do not use the XLS file as a replacement for IIF. Preserve the original IIF for QuickBooks-compatible import workflows, and treat the XLS file as a review, reporting, or data-exchange copy.