IIF to CSV Converter

Turn a QuickBooks IIF file into CSV tables

Free, no signup. Runs entirely in your browser — files stay on this device.

Your fileIIF

Drop your file here or browse from your device

Accepts IIF. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.

Read in this browser tab · 0 bytes uploaded

IIF to CSV at a glance

InputA .iif file exported from or written for QuickBooks Desktop
TransactionsTRNS and SPL lines become rows, with Transaction (1, 2, 3 …) and Line (TRNS or SPL) columns added; ENDTRNS lines are dropped
ListsEach list block (ACCNT, CUST, VEND, INVITEM and others) becomes its own table
ColumnsExactly the columns the file's ! header lines name, in their order
ValuesCopied as written; quotes QuickBooks puts around a value are removed

Convert a QuickBooks IIF (Intuit Interchange Format) file into CSV. IIF files are tab-separated text in blocks: a header line starting with ! names the columns, and the lines after it hold the records.

Transactions become one table: every TRNS line and its SPL split lines are rows, numbered so you can see which lines belong together. Lists in the same file, such as accounts, customers, vendors and items, each become their own table that you can choose and download.

Everything runs in your browser. The IIF file is not uploaded.

How to Convert IIF to CSV

  1. Drop the .iif file here or paste its contents
  2. Choose the table to download if the file holds more than one
  3. Pick the delimiter and encoding for the CSV
  4. Download the CSV and open it in Excel or Google Sheets

Features

  • Reads every block in the file: transactions and lists
  • Keeps split lines with their parent transaction, numbered
  • One table per list type, chosen from a menu
  • Columns taken from the file's own header lines
  • Comma, semicolon or tab output and a choice of encodings
  • Runs entirely in your browser, no upload or signup

Use Cases

  • Read an IIF export from QuickBooks Desktop in a spreadsheet
  • Check an IIF file someone sent you before importing it
  • Pull a chart of accounts, customer or vendor list out of an IIF file
  • Move transactions from an IIF file into another accounting tool that imports CSV

Frequently Asked Questions

How do I convert an IIF file to CSV?

Drop the .iif file on this page. Its transactions or lists appear as a table straight away. If the file holds several kinds of record, pick one under Table, then click Download.

What are TRNS, SPL and ENDTRNS?

In an IIF file a transaction is a TRNS line (the first side, such as the bank account), one or more SPL lines (the other sides, such as expense accounts) and an ENDTRNS line closing it. The CSV keeps TRNS and SPL lines as rows and adds a Transaction number so the lines of one transaction stay together.

Can I open an IIF file in Excel directly?

Excel can open it as tab-separated text, but every block's header and data lines are mixed together in one sheet. This converter separates the blocks into proper tables with one header row each.

Is my IIF file uploaded?

No. The file is read and converted in your browser. Nothing is sent to a server.