QIF to QBO Converter QIF to QBO Converter

Download QIF to CSV Converter for Windows

QIF to CSV Converter turns a Quicken QIF archive into a spreadsheet you can sort and sum. Fixed English column header, one row per transaction, a split written as one row carrying its total.

   
 Download for Free
QIF to QBO Converter Screenshot.
A line in a QIF file written in 1998 reads D3/4/26. That is March 4 or it is April 3, and the year could be 1926 as easily as 2026. The Quicken Interchange Format never pinned down the order of month and day. Leading zeroes may be skipped, and the year is legal as four digits, as two, or in the apostrophe form where '6 means 2006. SoftOrbits QIF to CSV Converter parses the whole archive before it writes anything, so the reading it settled on is visible while the spreadsheet still does not exist, and not two hours later, once Excel has sorted on it.

How to download and use the QIF to CSV Converter

Open the old file.

1. Open the old file

1. Open the old file

Download the QIF to CSV Converter and drop the .qif file onto the window. Every file is probed by content, so an .iif that is really a QIF export still opens as what it really is.

Read the preview before anything is written.

2. Read the preview before anything is written

2. Read the preview before anything is written

The preview shows what the parser made of the file. QIF is supposed to be plain ANSI text, and a file somebody re-saved as UTF-8 is exactly the sort of thing worth catching at this point.

Pick CSV and write it.

3. Pick CSV and write it

3. Pick CSV and write it

Switch the output format box on the Convert page to CSV and run the job. The same program also writes QIF to QBO for QuickBooks import, so one archive can go to a spreadsheet today and into accounting software next month.

A format with no upgrade path.

A format with no upgrade path

QIF did not lose to a newer version of itself. The industry moved to OFX instead, and OFX then changed dialect halfway through its own life. Versions 1.0 to 1.6 are SGML, the later ones are XML, and the current one is 2.3. Nobody ever came back to offer your old file an upgrade, and there is no company left to ask. What remains is the spreadsheet, the one destination that does not depend on a vendor still shipping a reader.

   
 Download for Free

The other option is typing it in again

Catch-up work is where this bites. A client hands over years of history in one old file, and every row in it is a line somebody would otherwise re-key by hand, evening after evening, with the sort order to fix afterwards. That is not a rounding cost, it is the whole job. QIF to CSV Converter turns the same archive into a table in one pass.

   
 Download for Free

The other option is typing it in again.
Old years, back in the tools you already use.

Old years, back in the tools you already use

Once the archive is a CSV it is simply a table. Excel, Google Sheets and LibreOffice all open it. From there you sort the whole run back into order. Pivot on any column. Chase one payee through all of it, or line an old period up against a statement you finally found in a drawer. Until it is a CSV, that archive cannot be checked against anything. A table can be, row by row. None of that helps when the archive has to be read rather than sorted, which is the moment to print a QIF export as a paginated report.

   
 Download for Free

What your spreadsheet gets

The header is a contract

The column header is fixed English in every locale, and it does not shrink when a field happens to be empty. This matters more than it sounds. Converters that quietly drop columns with no data give you a different header from one file to the next, and every Excel formula and import map keyed to a column name breaks without saying a word. Point a workbook at these names in January and it still finds them in June.

A split stays one transaction

A split is written as a single row, with Amount carrying the total of the transaction and no extra line items beside it. Expanding every split into its own line item looks tidier at first glance and then doubles your total, because the parent row and its pieces both fall under the same SUM. QIF to CSV Converter will not make that trade for you.

Two readings of the same date

Nothing in the QIF specification says whether the month or the day comes first, and both writers and readers have picked their own answer for decades. So 03/04/2026 inside a QIF file is genuinely two different dates. Taken the wrong way round, it never throws an error. It just sorts.

Shares are not money

An investment record carries either an amount or a quantity, never both in the same field. A share split or a ShrsIn moves units, not money, and pouring those units into the Amount column would give you total that is arithmetically perfect and financially nonsense.

Several accounts, one file

Old exports carry often more than one account, marked by !Account headers, with !Type:Bank, !Type:CCard or !Type:Invst saying what kind of account each one is. Each one stays told apart in the output rather than collapsing into a single undifferentiated pile of rows.

What the parser saw, before you write

Before a single byte goes to disk the preview reports the number of transactions recognized, the encoding it detected and a sample of the parsed rows as they will appear. Encoding is not a detail here. Quicken itself will not read a QIF saved as UTF-8 correctly. A file that has been through a modern text editor is worth a second look.

QIF to QBO Converter
QIF to QBO ConverterDownload the QIF to CSV Converter, open the file nothing else will read, and check the preview before the spreadsheet exists.
 Download

Who needs QIF to CSV Converter Tool

For catch-up and cleanup work

You take on books that were left alone for years, and the history arrives in whatever the client had at the time: an old QIF export from a program nobody sells anymore, often a folder of statements next to it. The QIF side becomes a table here; for the paper side there is PDF statements into CSV.

For the owner of the archive

You still have the file. You no longer have the program, and nobody is going to sell you a license for something that stopped shipping years ago. A QIF file converter gets those years back without reinstalling anything from that era.

For a bookkeeper inheriting history

A new client brings the past along with them. Before you can reconcile a single month you need the old transactions in a shape your working file accepts, with the totals still adding up to exactly what they added up to before. The client usually wants a copy of the same period too, and there the answer is to turn a CSV into a document you can hand over.

QIF to QBO Converter

QIF to QBO Converter

Languages
File Size

9 Mb

Version

1.0

Last updated on

25/06/26

$ 29.99

🖥️ 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

Short answer: open the .qif file, choose CSV as the output format, write it. Long answer: the records are parsed into one normalized set of transactions first, and only then written out as a table. That is why splits and investment entries come out sensible instead of line by line. The trial writes the first 20 transactions, so an old file can be judged on its own contents rather than on a sample document.

QIF is a transaction format built from one-letter record codes, a caret between records and a header line that declares the account type. CSV is a table and knows nothing about transactions at all. The interesting part of the conversion is therefore what happens to the structure QIF has and CSV does not. Chiefly split transactions. They stay one row instead of being scattered across extra rows.

A plain text export from Quicken and the other personal finance programs of that generation, where every line begins with a code letter for date, amount, payee, memo or category. Quicken published the format, then moved on, and the files outlived both. There is a longer definition of what a QIF file is if you want the field codes spelled out.

Excel will open it, and that is the trap. The file arrives as plain text, one tall column of raw records. No columns, no dates it recognizes, nothing to total. Renaming .qif to .csv does not help either, because there are no commas in the file to split anything on.

Convert to CSV and open the CSV. There is no .xlsx step needed in between, and there is a reason not to want one. A workbook can be built on a comma-separated table with stable header. On a binary spreadsheet regenerated every month it cannot.

No. Nothing in the conversion needs Quicken present, nor a Quicken license, nor an account anywhere. That matters, because most people still holding QIF files no longer have the program that produced them. And by Quicken 2006 the QIF import route was already closed for checking, savings and credit card accounts anyway.

That message means the file carries no !Type header line, so nothing in it declares what kind of account these records belong to. Usually a fragment was copied out of a larger export, or a text editor saved only part of the file. The records are still read, as bank records, and the note just says the file never declared its type; exporting the original again puts the header back.

Rate QIF to QBO Converter

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

Risk-free download

14-day money-back guarantee
Full refund, no questions asked
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