How to Convert a CSV File to QuickBooks IIF: Step-by-Step Tutorial
📄 Open the CSV to IIF Converter and follow along with this tutorial.
Open Tool →Steps
Step 1: Prepare Your CSV File
Open your CSV file in a text editor or spreadsheet application and confirm it has a header row as the first line. The column names in this header row will become the field names in the IIF output. For best results with QuickBooks import, use the standard IIF field names for your target record type — for example, TRNSTYPE, DATE, ACCNT, and AMOUNT for transaction records.
The converter accepts .csv, .tsv, and .txt files. The delimiter (comma or tab) is detected automatically.
Step 2: Open the Converter
Navigate to the CSV to IIF 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 CSV data will be loaded.
Open the CSV to IIF 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 CSV file. Alternatively, drag and drop your file directly onto the left source panel. The converter will immediately begin parsing the file using the detected delimiter.
While the file is loading, a spinner is shown in the source panel. For most files this completes in under a second.
Step 4: Select the IIF Record Type
Use the Record type dropdown in the toolbar to select the IIF record type that matches your data. This setting determines which type label appears at the start of every data line and in the IIF header definition line. The available options are:
- TRNS — transactions (most common for bank and journal imports)
- SPL — split lines within a transaction block
- ACCNT — chart of accounts
- CUST — customer list
- VEND — vendor list
- EMP — employee list
- INVITEM — inventory items
- CLASS — class list
- OTHER — any other record type
You can change the record type at any time before clicking Convert — it does not affect the source preview.
Step 5: Review the Source Preview
Once the file loads, your CSV data is displayed as a table in the left panel. Column headers appear in the first row and will become IIF field names. Numeric values are highlighted in blue. Null or empty values are shown as NULL in muted italic style.
Check that the expected columns 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 6: Convert to IIF
Click the Convert to IIF button in the toolbar. The converter processes all rows from your CSV file and generates the IIF output using the selected record type. A spinner is shown in the right panel while conversion is in progress.
The right (IIF output) panel becomes visible as soon as conversion begins.
Step 7: Review the IIF Output
After conversion completes, the right panel displays the IIF output as plain text. The status badge in the stats bar changes to CONVERTED. The first line of the output is the IIF header definition (for example, !TRNS<tab>DATE<tab>ACCNT…), followed by one data line per CSV row, and closed with !ENDTRNS and ENDTRNS markers.
Scroll through the output panel to verify the structure looks correct before downloading.
Step 8: Export and Import into QuickBooks
Click the Export IIF button in the toolbar to download your converted file. The browser saves it directly to your downloads folder. The output is named to match your input — only the extension is changed to .iif. For example, transactions.csv becomes transactions.iif.
To import the file into QuickBooks, use File > Utilities > Import > IIF Files and select your downloaded file. After importing, click Reset in the toolbar to clear all state and start a new conversion if needed.