How to Convert a QuickBooks IIF File to Excel XLSX: Step-by-Step Tutorial
📊 Open the IIF to Excel Converter and follow along with this tutorial.
Open Tool →Steps
Step 1: Locate Your IIF File
Find your .iif file on your device. IIF files are exported from QuickBooks using the File > Utilities > Export menu. Common exports include transaction lists, chart of accounts, customer lists, and vendor lists. The converter also accepts .txt files that follow the IIF tab-delimited structure. No pre-processing is needed before loading.
Step 2: Open the Converter
Navigate to the IIF to Excel Converter at FinancialDataTools.com. The tool loads entirely in your browser — there is no software to install and no account to create. The left panel shows the source area where your IIF data will be loaded. If you would prefer a plain CSV output instead, use the IIF to CSV Converter.
Open the IIF to Excel Converter — free, private, runs in your browser.
Open Converter →Step 3: Load Your File
Click the Open button in the toolbar to open a system file picker, then select your IIF file. Alternatively, drag and drop your file directly onto the left source panel. The converter will immediately begin parsing the IIF structure — reading each !-prefixed header line and building a unified record set.
While the file is loading, a spinner is shown in the source panel. For most files this completes in under a second.
Step 4: Review the Source Preview
Once the file loads, your IIF records are displayed as a flat table in the left panel. The first column — TYPE — shows the IIF record type for each row (such as TRNS, SPL, or ACCNT). The remaining columns correspond to the field names defined in your IIF file's header lines. Fields that do not apply to a given record type appear as NULL.
Review the preview to confirm your records loaded correctly. The stats bar above the panels shows total rows and columns. For large files the preview shows the first 500 rows; the full dataset is always included in the exported workbook regardless.
Step 5: Convert to Excel
Click the Convert to Excel button in the toolbar. The converter processes all records and assembles a native Excel workbook in memory — no data is sent to any server. A spinner is shown in the right panel while the workbook is being built.
The right (output preview) panel becomes visible as soon as conversion begins.
Step 6: Check the Output Preview
After conversion completes, the right panel displays two things: a confirmation notice reading Excel workbook ready and a live HTML table preview of the workbook data. The status badge in the stats bar changes to CONVERTED.
The preview table shows up to 500 rows. If your file contains more, a notice at the bottom of the preview confirms the full dataset will be included in the downloaded file. Scroll through the preview to verify the column structure and data values look correct before downloading.
Step 7: Export the XLSX File
Click the Export XLSX button in the toolbar to download your workbook. The browser saves the file directly to your downloads folder. The output is named to match your input — only the extension is changed to .xlsx. For example, transactions.iif becomes transactions.xlsx.
The workbook contains a single sheet named IIF Data. Columns are automatically sized based on content width — up to 40 characters — so the sheet opens in a readable state without manual adjustment. Open the file in Microsoft Excel or Google Sheets to begin working with your data immediately.
The Export XLSX button is disabled until a successful conversion has completed. After downloading, click Reset in the toolbar to clear all state and start a new conversion with a different file.