OFX, QFX and QBO to CSV and Excel converter
Open the “Quicken”, “QuickBooks” or “Money” download from your bank as a spreadsheet, with one row per transaction showing the date, amount, payee and memo.
Choose your files
or drop one or more statement files here
Up to 20 files at a time. Your files stay on this device.
Options
Preview and download
Your files stay on this device: the conversion runs in your browser and nothing is uploaded. Learn how your files are handled
How to convert OFX to CSV or Excel
- Choose one or more .ofx, .qfx or .qbo files. A file with several accounts, such as checking and savings in one download, works too.
- Choose the date format, and whether you want one Amount column (with minus signs for money out) or separate Money In and Money Out columns.
- Download a CSV or an Excel workbook.
What you get
One row per transaction with Date, Amount, Payee and Memo, plus Check Number when the bank provides one. When the files hold more than one account, an Account column (for example “Checking …5678”) shows where each transaction belongs. You can tick the option to add the bank’s transaction type and ID columns. These help when you check transactions against your own records or look for duplicates.
Investment statements (holdings and trades) are not converted, only bank and credit card transactions. In the CSV, any payee or memo text that a spreadsheet would treat as a formula (text starting with = or @) gets an apostrophe added at the start. Amounts are never changed.
Where OFX files come from
Most banks let you download transactions as Quicken (QFX), QuickBooks (QBO), Microsoft Money (OFX) or Spreadsheet (CSV). The first three are all the same format, OFX (Open Financial Exchange). QFX and QBO just add a few small details for Intuit’s programs. If you already have one of those files, or your bank no longer offers CSV, this converter turns it into a spreadsheet.
A .qbo bank file is not the same as QuickBooks Online, which is also shortened to “QBO”. This converter reads bank statement files, not data exported from a QuickBooks Online company.
What’s inside an OFX file
An OFX file is plain text. After a short header, it lists each transaction between tags: <DTPOSTED> for the date, <TRNAMT> for the amount, <NAME> for the payee, <MEMO> for extra details and <FITID> for the bank’s ID for the transaction. Bank accounts and credit cards have their own sections, so one file can hold several accounts.
- OFX 1.x, the older version that many banks still use, starts with lines such as
OFXHEADER:100. Tags that hold a value often have no closing tag, so the file isn’t valid XML. - OFX 2.x is XML: it starts with
<?xml, and every tag is closed.
The converter reads both versions, and the QFX and QBO files built on them, and turns each transaction into one spreadsheet row.
Common uses
- Budget, tax or expense analysis in Excel, Google Sheets or Numbers.
- Moving your history to an app that only imports CSV.
- Combining downloads from several accounts or months into one sheet: choose all the files at once.
- Keeping a readable copy of old statements after closing an account.
Frequently asked questions
Can Excel open an OFX, QFX or QBO file directly?
Not in a useful way. Excel shows the file’s raw codes instead of a table. Convert the file here first, and Excel opens it as normal rows and columns.
Some transactions are missing. Why?
Banks usually leave pending transactions out of OFX downloads, and the file covers only the date range you chose when downloading. Download a wider date range and convert again.
Can I combine several statement files?
Yes. Choose them all together, and every transaction goes into one spreadsheet, with an Account column if they come from different accounts.
Are investment accounts supported?
Not yet. Files with investment statements can be opened, but only their bank and credit card transactions are converted. The page tells you when something was left out.
What is the difference between OFX and CSV?
OFX is a format made for bank data. Every transaction has fixed fields for its date, amount, payee and memo, plus an ID, so finance apps can import it without any setup. A CSV is a plain table that any spreadsheet opens, but each bank arranges its columns differently. Converting OFX to CSV gives you a file you can sort, filter and total in Excel or Google Sheets.
How do I open an OFX or QFX file without Quicken?
Choose it here: the preview shows the first transactions as a table straight away, and the CSV or Excel download opens in Excel, Google Sheets or Numbers. Finance apps such as GnuCash, Moneydance and Banktivity can also import OFX and QFX files. A text editor shows only the tags described above.
Is a .qbo file the same as QuickBooks Online?
No. A .qbo file is a bank statement download for QuickBooks (a Web Connect file), and that is what this converter reads. QuickBooks Online is also often called “QBO”, but data you export from QuickBooks Online itself, such as reports and lists, usually comes as an Excel file and needs no conversion.
Can I convert an OFX file to PDF?
Not directly. Convert it here to an Excel workbook, open that in Excel, Google Sheets or Numbers, and use Print to save it as a PDF. You get a readable list of transactions with their dates, amounts and payees.
Is my statement uploaded?
No. The file is read in your browser, and the spreadsheet is created on your device.