OFX to CSV Converter: Turn OFX, QFX and QBO Bank Files into a Spreadsheet
Drop the OFX, QFX or QBO file your bank gave you and get a CSV with one row per transaction — date, description, amount, type, memo, check number and FITID — ready to open in Excel or Google Sheets. Free, no signup.
Free · No signup · Runs in your browser. Your file is read on this device and is never uploaded to BankSheet.
How to convert an OFX file to CSV
Download the OFX, QFX or QBO file
In online banking, download the transactions in Money/OFX, Quicken (QFX) or QuickBooks Web Connect (QBO) format.
Drop the file here
The file is read on this device. Bank and credit card statements are found automatically, including files with more than one account.
Pick the amount columns and date format
Keep one signed Amount column, or split it into Debit and Credit. Write dates as YYYY-MM-DD, MM/DD/YYYY or DD/MM/YYYY.
Download the CSV
Open it in Excel, Google Sheets or Numbers, or reshape it for QuickBooks or Xero with the free formatter.
What an OFX, QFX or QBO file contains
OFX (Open Financial Exchange) is the file format banks use for Money, Quicken and QuickBooks downloads. Version 1.x files are SGML, with a plain-text header such as OFXHEADER:100; version 2.x files are XML. Both are read here.
Each transaction is an STMTTRN record with a type (TRNTYPE), posting date (DTPOSTED), signed amount (TRNAMT), the bank's unique transaction ID (FITID) and usually a payee NAME and MEMO. The converter writes each of those to its own CSV column, plus the check number, reference number, account and currency.
QFX to CSV and QBO to CSV
QFX (Quicken) and QBO (QuickBooks Web Connect) files are OFX with extra Intuit tags such as INTU.BID. The transactions sit in the same STMTTRN records, so the same converter reads them. You do not need Quicken or QuickBooks installed.
Open an OFX file in Excel
Convert the file here, download the CSV and open it in Excel. Amounts are written as plain numbers with two decimals and dates in the single format you choose, so Excel can sort, filter and total them.
Signs, dates and FITIDs
Amounts keep the sign written in the file. If you choose separate Debit and Credit columns, negative amounts go to Debit and zero or positive amounts go to Credit.
The date is the calendar date written at the start of DTPOSTED (or DTUSER when there is no posting date). The time and time zone that may follow are ignored, so a date never shifts by a day.
FITID is the bank's ID for each transaction. Two rows with the same FITID are the same transaction downloaded twice — handy when you merge files with the duplicate finder.
Works with these files
The converter reads:
- .ofx, .qfx and .qbo files, OFX 1.x (SGML) and 2.x (XML), up to 10 MB.
- Bank account (STMTRS) and credit card (CCSTMTRS) statements, with an Account column when a file holds several accounts.
- Windows-1252 (CHARSET:1252) and UTF-8 files, with & style entities decoded.
- Investment statements are reported and skipped.
Frequently asked questions
How do I convert an OFX file to CSV?
Drop the .ofx file on this page, choose one signed Amount column or separate Debit and Credit columns, pick a date format and download the CSV. Nothing is uploaded.
Can I convert a QFX or QBO file to CSV?
Yes. QFX and QBO files are OFX with Intuit-specific tags, and their transactions are read the same way as a plain OFX file.
How do I open an OFX file in Excel?
Convert it to CSV here and open the CSV in Excel. Each transaction becomes a row with date, description, amount, type, memo, check number, reference, FITID, account and currency columns.
Can it convert CSV to OFX, QFX or QBO?
No. This tool only reads OFX, QFX and QBO files and writes CSV. BankSheet (getbanksheet.com) does not create OFX, QFX or QBO files.
Why are some amounts negative?
The CSV keeps the sign written in the file's TRNAMT field. Choose “Separate Debit and Credit” to get unsigned amounts in two columns instead.
Can it read a PDF bank statement?
No, it reads OFX, QFX and QBO files. For a text-based PDF statement, BankSheet (getbanksheet.com) extracts the transactions, checks opening to closing and exports CSV or Excel. The first 10 pages are free.
Do you see or store my bank data?
No. The file is read by JavaScript in this page and the result is built on your device. Nothing from the file is sent to a server. We only record that the tool was used, with a rough row-count range and the outcome (for example pass or fail), never dates, descriptions, amounts, or balances.
More free bank statement tools
- Bank statement balance checker — Drop a bank CSV and see the exact row where the running balance stops adding up, plus likely missing or duplicate transactions.
- Bank CSV to QuickBooks & Xero format — Turn any bank CSV export into the QuickBooks Online 3- or 4-column layout or the Xero bank statement template, with dates and signs fixed.
- Duplicate transaction finder — Find duplicate transactions in a bank CSV, or merge overlapping exports and download one clean file without the double-counted rows.
- All free tools