About QBOtoExcel

QBOtoExcel turns the transaction files your bank, card and accounting programs hand you into spreadsheets you can sort and total, and turns a spreadsheet back into a Quicken file. It is built and run by one person, and every conversion happens in your browser.

What this site does

Four statement formats come out as a table: QBO, OFX, QFX and QIF, each as an Excel workbook or a plain CSV with one row per transaction. One converter goes the other way, turning a spreadsheet of transactions into a Quicken .qif file, matching the columns you choose. There are seven converters in all, and each is a page of its own rather than one box that has to guess what you gave it.

Why it exists

A statement file is a record of what happened, written for a program to read rather than for a person to look at. Whether you want to sort a year of spending, total it by category, or check a month against the balance your bank shows, the first step is a table. That step is usually a paid download or an upload to somebody else's server. This site does that one step, in the browser, for free.

How it works

The conversion happens on your device. The file is read in the browser, the rows are built there, and the download is made from data that never left your machine. There is no upload step and no account, so there is no copy of your file on a server. What the site does collect is limited to what keeps it running, and the privacy page sets that out in full.

What it does not do

It is not accounting software, and it is not a backup of your books. It does not write entries into a ledger, reconcile an account, or connect to your bank. It also does not guess. A value it cannot read is never invented, and the two directions handle that differently: a QIF to Excel conversion carries an unreadable date or amount into the sheet as the text the file held, while a CSV to QIF conversion leaves that row out and reports how many it dropped.

How these pages are written

Every claim on this site is checked against the code that does the work. The column names, the file shapes, the limits, the wording of what a converter will and will not do: each one was verified before it was written, and corrected when it turned out to be wrong. If a page says a converter reports the rows it could not read, that converter really reports them.

What it costs

Converting a file is free, with no account and no limit per file. A Pro plan is planned for batch conversion, early access to new features and priority support. It is not available yet, and the pricing page will say so when it is.

Contact

Questions, bug reports and data-handling questions are all welcome.

Contact Support