QIF to QBO Converter QIF to QBO Converter
4.5 · 872 votes

Download IIF to CSV Converter Software for QuickBooks Desktop Exports

IIF to CSV Converter Software turns a QuickBooks Desktop export into a spreadsheet you can sort, filter and hand on. Transactions and splits, read on your own PC.

   
 Download for Free
Windows 11 / 10Free trial, no sign-up
QIF to QBO Converter Screenshot.
QuickBooks Desktop writes plain tab-delimited text. When you click Save, the export often lands on disk as .txt rather than .iif. A converter that relies on the file name rejects it without reading the contents. SoftOrbits IIF to CSV Converter Software checks the opening lines for the !TRNS header and reads the file as an IIF export with either legacy extension.

How to download and use the IIF to CSV Converter Software

Keep your export on your PC.
1

Keep your export on your PC

Download the IIF to CSV Converter tool and install it on the PC with your QuickBooks Desktop export. The program works on the file there, without sending it to anybody's server.

Drag in your export.
2

Drag in your export

Drag the export into the program. The queue accepts .iif files and reads them by their contents. Check the preview; nothing is written until you say so.

Pick CSV and write the file.
3

Pick CSV and write the file

On the Convert page, choose CSV in the output box, select a folder and run it. Open the result in Excel, Google Sheets or LibreOffice, or take it into Xero or a reconciliation workbook.

Transactions cross over. Lists stay behind..

Transactions cross over. Lists stay behind.

An IIF export can hold a chart of accounts, customers, vendors, inventory items and classes alongside transactions. Your CSV gets the postings, with dates, descriptions and amounts against accounts. The name lists and account tree stay in the IIF file. Check which data you need before downloading.

   
 Download for Free

Intuit's warning about skipping import checks

Intuit's IIF import help page advises against 'Import it for me. I'll fix it later': some information may arrive wrong or incomplete in your books. Choosing it also requires switching QuickBooks into single user. Check the export before posting it. IIF to CSV Converter Software puts dates, payees, accounts and signs in plain columns, where you can fix a mistyped account in a single cell before it reaches a posted batch.

   
 Download for Free

Intuit
Your whole book stays local.

Your whole book stays local

A bank statement covers one account for one month. Your IIF export holds the suppliers your firm pays, your bookkeeper's notes, the account tree set up back in 2011 and every figure attached to them. That is a lot to put into a web form on a site you found ten minutes ago. We keep the export on the machine you run the program on. Nothing is uploaded anywhere, and the CSV appears beside it.

   
 Download for Free

An IIF file converter that reads the contents

IIF to CSV Converter Software checks every file's contents to choose the parser. IIF and QIF have separate grammars; when a file could match either, the program reads it as QIF. For a genuine Quicken archive, open a QIF archive as a spreadsheet.

Columns found by name

Each IIF section starts with an exclamation-mark header naming its columns: DATE, ACCNT, NAME, AMOUNT, MEMO, plus any others QuickBooks included in that export. The program reads those names to find the fields. Even if your export puts the columns in an unexpected order, the values land in the right places.

Split transactions you can add up

IIF records a split twice: !TRNS holds the total, and !SPL holds the parts with their signs reversed. Add them together and you get zero. A card charge of 1,200 split three ways appears as a total of -1,200 and three parts adding up to +1,200. We write each transaction as one row with the TRNS total, leaving out the reversed SPL parts. You can run SUM() over the Amount column.

One row per transaction

!TRNS, !SPL and !ENDTRNS repeat for every transaction, often through a full year of a small company's books. The program closes each block where the file closes it, keeping neighbouring transactions separate. Your spreadsheet's row count matches the export's transaction count.

Preview before writing

The text preview shows the transaction count, the file's encoding and the opening rows. IIF exports are often edited by hand in Notepad. If yours was, check whether the count matches what you expected here, before you start building formulas in a workbook.

One IIF converter, three outputs

Choose CSV, QBO or PDF on the Convert page. The program also writes .qbo when your data needs to go back into accounting software; see convert QIF to QBO. IIF to CSV Converter reads .qif files too, so you can work through a folder of both legacy export formats with the same program.

QIF to QBO Converter
QIF to QBO ConverterDownload the IIF to CSV Converter, drop in the export QuickBooks Desktop gave you, even the one sitting there as a .txt, and read your transactions as a spreadsheet.
 Download

Who needs IIF to CSV Converter Tool

For admins on QuickBooks Desktop

You keep the company file, the workstations and the backups. IIF is the format that still moves the data in and out of Desktop when the bank feed has gone quiet, and CSV is what the rest of the office can actually open.

For bookkeepers with a Desktop client base

Clients on Desktop send exports, not access. Reading them as columns is how you check a period before it is posted, and how you build the summary the client asked for without typing anything twice. When the same books pay suppliers by paper, QuickBooks check printing software prints the checks from a QuickBooks Desktop voucher run.

For consultants running a migration

Moving off Desktop can leave you with mixed exports: IIF from Desktop, .qif from an older system and .qbo files from the bank without a reader to hand. You can convert a QBO file to CSV too, bringing the whole pile into one format before it goes into the new system.

QIF to QBO Converter
QIF to QBO Converter
Price
from $ 29.99
Version
1.3
File Size
9 Mb
Last updated on
23/09/26
System Requirements
  • Windows 11/10/8.1/8/7 (32/64 bit)
  • Intel i3, AMD Ryzen 5 or above
  • 4 GB of RAM or above
  • NVIDIA® GeForce® series 8 and 8M, Intel® HD Graphics 2000, Quadro FX 4800, Quadro FX 5600, AMD Radeon™ R600, Mobility Radeon™ HD 4330, Mobility FirePro™ series, Radeon™ R5 M230 or higher graphics card with up-to-date drivers
  • 1280 × 768 screen resolution, 32-bit color
  • 1 GB of free hard disk space or above

Frequently Asked Questions

Install the program, drag in your export, set CSV as the output format and run it. The trial writes out the first 20 transactions, so you can check the columns and amounts using your own data.

Intuit Interchange Format is tab-delimited text used almost exclusively by QuickBooks Desktop. Its sections let one file hold transactions, accounts and name lists together. Each section's header starts with an exclamation mark and names the columns that follow. For a field-by-field walkthrough, see what an IIF file is. The .qbo Web Connect file your bank sends is a separate format with a different job.

Excel opens the text file as raw sections: headers with exclamation marks, split rows with reversed signs, and one long column if it misses the tab delimiter. Convert to CSV to get dated rows and an Amount column. Editing the IIF by hand and saving it back can corrupt the file; use the CSV for your spreadsheet work.

You can use a machine that has never had QuickBooks installed. The program reads the export as text, including files kept after a subscription lapsed or Desktop was removed from the workstation.

In QuickBooks Desktop, use File, Utilities, Import, IIF Files. Intuit rebuilt the import tool in QuickBooks Desktop 2019; the newer version runs in multi user mode. Converting to CSV reads the exported data, while this menu imports it into QuickBooks.

The program converts from IIF and QIF to CSV, QBO and PDF. To bring data back into QuickBooks Desktop, start with a table and use the route that builds a .qbo from a spreadsheet. QuickBooks accepts that format on import.

In QuickBooks Desktop, open the File menu and choose Utilities, Export. Bring the resulting tab-delimited text file into the program. For the opposite direction, a separate converter can write an IIF file from a bank CSV.

Related finance converters

QBO to PDF converter
QFX to PDF converter
PDF to CSV converter
Batch printing software
VCF to CSV converter
CSV to PDF converter
ICS to CSV converter
CSV to VCF converter
Check printing software

Rate IIF to CSV Converter

  • Windows 7
  • Windows 8
  • Windows 10
  • Windows 11
Author: SoftOrbits (English)
4.5
Avg. rating: 4.5 from 872 votes
Good
 Download for Free

Risk-free download

progressive-webapps/apis/offline-first Created with Sketch.
100% offline
Your files never leave your PC
Safe & secure download
Directly from the official website
No sign-up required
No account or email to get started
Trusted since 2006
Desktop software for Windows