Export QuickBooks IIF to CSV: Step-by-Step Guide

Why Convert IIF to CSV?

You might have old IIF files from QuickBooks Desktop backups, or you need to analyze your transaction data in Excel or Google Sheets. IIF files are tab-delimited text, but converting them to proper CSV makes them easier to work with.

How to Use the IIF to CSV Converter

1. Locate your IIF file — these are usually exported from QuickBooks Desktop via File > Utilities > Export.
2. Upload it to our IIF to CSV tool.
3. Download the CSV — each TRNS row becomes a CSV row.
4. Open in Excel or Google Sheets.

IIF File Structure

IIF files contain multiple record types. The converter focuses on TRNS records (transactions):

!TRNS  TRNTYPE  DATE     ACCNT     AMOUNT   MEMO
TRNS   CHECK    1/5/2026  Checking  -250.00  Office supplies
ENDTRNS

What Gets Exported

The CSV will contain:

• Transaction type (CHECK, DEPOSIT, etc.)
• Date
• Account name
• Amount
• Memo/description

Using the CSV Data

Once in CSV format, you can:

• Create pivot tables for expense analysis
• Filter by account or date range
• Import into other accounting systems
• Create charts and visualizations in Google Sheets