How to Convert a QuickBooks IIF File to CSV: Step-by-Step Tutorial
📄 Open the IIF to CSV 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 CSV 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.
Open the IIF to CSV 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.
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.
Review the preview to confirm your records loaded correctly — check that the expected record types are present and that row counts look right. 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 converted regardless.
Step 5: Convert to CSV
Click the Convert to CSV button in the toolbar. The converter processes all records and generates a flat CSV file containing every row from your IIF file. A spinner is shown in the right panel while conversion is in progress.
The right (CSV output) panel becomes visible as soon as conversion begins.
Step 6: Inspect the CSV Output
After conversion completes, the right panel displays the full CSV output as plain text. The status badge in the stats bar changes to CONVERTED to confirm the conversion succeeded. The first line of the CSV is the header row containing all column names, starting with TYPE. Scroll through the output panel to inspect the content and verify your data looks correct.
Step 7: Export the CSV File
Click the Export CSV button in the toolbar to download your converted file. The browser saves the file directly to your downloads folder. The output file is named to match your input — only the extension is changed to .csv. For example, transactions.iif becomes transactions.csv.
The Export CSV button is disabled until a successful conversion has completed. After downloading, you can click Reset in the toolbar to clear all state and start a new conversion with a different file. If you prefer an Excel workbook instead of a CSV file, use the IIF to Excel Converter for a native .xlsx download.