Why would I need to go from IIF back to CSV?

Common when you're migrating off QuickBooks Desktop, sharing data with someone who doesn't have QuickBooks, or auditing historical exports in a spreadsheet.

Where do I get an IIF file to convert?

IIF is QuickBooks Desktop's own export/import format — you'd have one if you or your accountant exported transactions from QuickBooks Desktop.

What if my IIF file has multiple accounts or a different column order?

Handled. Real QuickBooks exports can redefine the field order partway through the file (e.g. once per account section) — BalanceExtract reads each section's own header line rather than assuming one fixed layout for the whole file.

What if a row is missing a date or amount?

It's skipped, and you're told exactly how many rows were skipped and why — never silently dropped or guessed at.

Is my data uploaded anywhere?

No. The conversion runs entirely in your browser — nothing is sent to a server.

BalanceExtract

local

Format converter

Free IIF to CSV Converter: Reading QuickBooks Desktop's Export Format

Runs entirely in your browser — your file is never uploaded to a server.

100% private

Never uploaded

Instant

Runs in your browser

CSV & Excel

Real spreadsheet output

No signup

No account, no card

Convert an IIF file to CSV

Drop your file below — runs entirely in your browser, nothing is uploaded.

Drag and drop your IIF file hereor click to browse your files IIF→CSV

Only have a PDF statement? That converts too.

A IIF file means your bank gave you structured data — which most banks only do for the last few months. Beyond that you get a PDF, and a PDF won't open in Excel. BalanceExtract reads those directly: it works out the column layout from the document itself, handles scanned statements with OCR, checks that every running balance reconciles, and flags any row it isn't confident about before you export.

Same CSV output, same on-device processing, nothing uploaded.

Convert a PDF statement6 pages free, no signup, no card

How to convert IIF to CSV in 3 steps

Step 1: Drop in your IIF file

Drag the file onto the box above or click to browse. It is read in your browser — nothing is uploaded to a server, which you can confirm in the Network tab.

Step 2: Check what was found

Every transaction is read out with its date, payee, description, amount and transaction ID, along with any warnings about rows that need a look.

Step 3: Download the CSV

The CSV file saves straight to your device, ready to open in a spreadsheet or import into your accounting software.

IIF (Intuit Interchange Format) is QuickBooks Desktop's own tab-delimited transaction format — straightforward for QuickBooks to read, considerably less so to open directly in a spreadsheet. This guide covers what's actually in an IIF file and how to get a clean CSV out of one.

Quick summary

Migrating off QuickBooks Desktop or auditing old records without retyping years of transactions starts with getting a clean CSV out of the IIF export. IIF files are tab-delimited, but QuickBooks exports can redefine the column order partway through the file — once per account section — which breaks naive parsers that assume one fixed layout. This converter reads each section's own header line, extracts transaction type, reference number, and memo alongside date, description, and amount, and reports exactly how many rows were skipped and why if anything doesn't parse cleanly.

What's Inside an IIF File

Line	What It Contains
TRNS	The transaction itself — date, amount, account, and description
SPL	The offsetting split line completing the double-entry structure
ENDTRNS	A marker closing the record

Real Parsing Issues This Handles

Field order can change mid-file: a real QuickBooks export can redefine column order once per account section — treating the whole file as one fixed layout silently misreads later sections.
Missing dates or amounts: rows that can't be parsed are skipped and reported, not guessed at or silently dropped.

Frequently Asked Questions

Why would I need to go from IIF back to CSV?: Common when you're migrating off QuickBooks Desktop, sharing data with someone who doesn't have QuickBooks, or auditing historical exports in a spreadsheet.
Where do I get an IIF file to convert?: IIF is QuickBooks Desktop's own export/import format — you'd have one if you or your accountant exported transactions from QuickBooks Desktop.
What if my IIF file has multiple accounts or a different column order?: Handled. Real QuickBooks exports can redefine the field order partway through the file (e.g. once per account section) — BalanceExtract reads each section's own header line rather than assuming one fixed layout for the whole file.
What if a row is missing a date or amount?: It's skipped, and you're told exactly how many rows were skipped and why — never silently dropped or guessed at.
Is my data uploaded anywhere?: No. The conversion runs entirely in your browser — nothing is sent to a server.