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