OFX to Excel: convert OFX, QFX and QBO files to a spreadsheet
Open the bank file your spreadsheet cannot read. Every transaction becomes a row, with real dates and numbers, in Excel or CSV.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: runs in your browser
No file at hand?
Statements
Columns of
Detected automatically. Change anything that looks wrong and the result updates.
Transactions
Output options
How to use it
- Drop your .ofx, .qfx or .qbo files.
- Check the transactions in the preview.
- Download Excel or CSV.
What ends up in the sheet
Each STMTTRN becomes a row. DTPOSTED is the date, TRNAMT the amount, NAME and MEMO the description, FITID the reference and TRNTYPE the type. The time and time zone that some banks add to the date are ignored, so a transaction never moves to another day.
When it helps
- Reviewing or filtering transactions that your bank only exports as OFX or QFX.
- Moving out of Quicken, QuickBooks or Microsoft Money.
- Handing an accountant a spreadsheet.
Private by design
A statement shows your income, your rent and who you pay, so it should not need uploading to convert it. Here the file is read by code running on your device, and nothing is sent to a server. You can check it in your browser’s network panel.
Known limitations
- PDF statements are not read. Convert them to Excel first with the PDF tools and check the result, because PDF extraction can misread rows.
- A .qbo file is read but not written: QuickBooks Desktop requires an Intuit bank ID that cannot be validated here. Use OFX, or the 3-column CSV for QuickBooks Online.
- OFX requires a closing balance. If your source has none, the file contains the sum of the transactions, which is not your real balance.
- Investment transactions in OFX and QIF are not read. Split lines in QIF are kept as one transaction with its total.
- File size is limited by your device memory, not by any quota. The work runs on the page, so very large files can pause it for a moment.
Frequently asked questions
Is this OFX converter really free?
Yes. It is 100% free, with no usage limits, no account and no sign-up. There is no paid plan and no feature is locked.
Are my bank statements uploaded to a server?
No. Your files never leave your device: they are read and converted inside your browser. The page only downloads its own code and open-source libraries from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never the contents or names of your files.
What is the difference between OFX, QFX and QBO?
They are all the same Open Financial Exchange structure. QFX adds fields for Quicken and QBO adds fields for QuickBooks. All three are read the same way here.
How do I open an OFX file in Excel?
Excel has no import for OFX. Drop the file here and download the Excel version: it has one row per transaction and a second sheet with the account summary.
Does it check the balance?
Only partly. OFX files usually state the closing balance but not the opening one, so a full check is not possible and the page says there is no balance to check. The closing balance appears in the summary sheet.
Why are the accents wrong in my file?
The encoding declared in the OFX header is used, and UTF-8 is detected if present. If the characters still look wrong, the bank probably wrote the wrong encoding into the file.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives the contents or names of your files. You can change your choice at any time with “Cookie settings” at the bottom of the page.