ConvertCSVtoQBO

Convert IIF to CSV

Open a QuickBooks IIF file as a spreadsheet to check it before importing, compare it with your books, or move the data somewhere else.

  • Free, no sign-up
  • Your file never leaves your computer
  • Transactions and lists
Converted in your browser. Nothing is uploaded. No file handy?

What's inside an IIF file

IIF is a tab-separated text format used by QuickBooks Desktop. Header rows starting with an exclamation mark name the columns, and each transaction is a group of lines: a TRNS line for the main account, one or more SPL lines for the other side, and an ENDTRNS line to close it.

Choose "Every line" to see each TRNS and SPL line as its own row, with a transaction number tying them together. Choose "One row per transaction" for a simpler list with the split accounts in one column. If the file only holds a list, such as accounts, customers or vendors, you get that list with all its columns.

Related converters

Questions

What is an IIF file?

IIF, or Intuit Interchange Format, is the text format QuickBooks Desktop uses to import and export lists and transactions.

Can I open an IIF file in Excel directly?

Excel can open it as tab-separated text, but the header rows and transaction groups make it hard to read. Converting gives you clean columns.

Does it handle split transactions?

Yes. Every split line is kept, or summarized into one column if you choose one row per transaction.

Can I edit the CSV and import it back?

Not directly. QuickBooks needs the original IIF layout with its header rows. Use the CSV to review and check data.

Is my data safe?

Your file is read and converted inside your own browser. It is never uploaded to a server, so nobody else can see your transactions.