What an OFX file holds, what actually opens one, and how to get the same transactions into a workbook. If you still have the original PDF statement, upload it here and export Excel or CSV directly.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
OFX is a tagged format built for finance software, so Excel shows the raw markup rather than rows. To get a workbook you either import the OFX into a program that reads it and export from there, or you convert the statement the OFX was generated from. The uploader on this page reads PDF and image statements, not OFX files, and exports Excel, CSV and OFX from them.
Double click an OFX file and Excel shows a wall of tags, not transactions. OFX is a structured finance format, so it needs converting before a spreadsheet can read it as rows and columns.
Open an OFX in Excel and you get SGML style markup down the first column, not the dated transactions you were after.
MS Money, GnuCash and Moneydance read OFX fine, but the moment you need a P&L, a budget, or a tax schedule, the work moves to a spreadsheet.
Most bookkeepers and CPAs ask for an .xlsx file they can review and formula against, not an OFX they would have to import first.
Totaling by category, charting spend by month, and reconciling all depend on the data sitting in real Excel cells.
A weak conversion drops the running balance or flips debit and credit signs, which quietly breaks every SUM in your sheet.
Retyping hundreds of transactions from an OFX into Excel wastes an afternoon and introduces errors you may never catch.
Converting from the statement rather than the OFX produces the same transactions as a formatted workbook, with correct dates, signed amounts and the balance preserved.
Delivers a real Excel workbook with a header row and clean columns, not a raw dump, so it is ready to sort and total on open.
The uploader accepts PDF and image statements, including scanned copies. It does not read OFX or QFX files, so start from the statement those files were built from.
Turns OFX date stamps into readable Excel dates so sorting and month grouping work without cleanup.
Keeps debits and credits signed correctly so your column totals and running balance stay accurate in every formula.
Consistent columns mean you can drop straight into a pivot table or SUMIF without reshaping the data first.
256-bit encryption in transit and you can delete your uploaded file at any time.
No install, no macros, no credit card to start.
Drop in the PDF or scanned statement from your bank, card or brokerage. The uploader reads PDF and image files, not OFX or QFX.
Tip: Up to 50 statements can go in at once.
The converter parses every transaction and builds a formatted .xlsx workbook with proper columns.
Tip: Prefer a plain comma file? Choose CSV output instead.
Download the workbook, open it in Excel, and start sorting, categorizing, and totaling with formulas.
Tip: Check the balance column against your statement to confirm nothing dropped.
Anyone holding an OFX file who needs the transactions in a spreadsheet for accounting, budgeting, or reporting.
Get client OFX downloads into a formatted workbook for review, tie outs, and tax schedules without importing into finance software first.
Turn an OFX export into Excel to categorize, build journal entries, and reconcile against the ledger.
Move OFX data into a workbook to pivot, chart, and total spending by category and month.
Convert a bank OFX to Excel to build expense reports and P&L summaries you can send to your accountant.
Finance software speaks OFX, but the reporting, the budgeting, and the tax prep all happen in a spreadsheet. Converting OFX to Excel unpacks the tagged file into a real workbook: one row per transaction, with the date, description, amount, and running balance laid out in columns you can sort, filter, and formula against. If you want a plain comma file instead of a formatted workbook, the OFX to CSV converter produces that same data as CSV, and if your statement is still a PDF, the bank statement to OFX converter reads it directly.
The point of the workbook is that you can reconcile and calculate in it. A correct conversion reads each OFX date stamp into a real Excel date, keeps debits and credits signed so SUM and SUMIF stay right, and carries the running balance through so you can confirm the ending figure matches the statement. The table below shows how the tagged OFX fields map to Excel columns.
| OFX field | Excel column |
|---|---|
| DTPOSTED date stamp | A real Excel date, ready to sort and group |
| NAME and MEMO | A single description column |
| TRNAMT amount | A signed amount, debits negative |
| Ledger balance | A running balance column for reconciliation |
If the file you are holding is specifically a Quicken QFX rather than a plain OFX, the QFX to Excel converter is the page for it. Many bookkeepers keep a spreadsheet as the working copy and only push the final numbers into their accounting software. If that is you, converting the statement straight into a ready to use spreadsheet saves a step. Going the other direction, if a program only accepts an account file, the CSV to OFX converter turns a spreadsheet back into OFX.
Two routes work. Import the OFX into a program that reads it, such as GnuCash or Xero, then export from that program and open the result in Excel. Or convert the PDF statement the data came from, which is what the uploader on this page does. It reads PDF and image statements, not OFX files.
OFX is a tagged data format built for finance software, so opening it in Excel shows the raw markup instead of rows. Converting it to an .xlsx workbook first unpacks those tags into ordinary columns, which is what lets you sort, filter, and total the transactions with formulas.
QFX is the Intuit variant of OFX and behaves the same way, so the same two routes apply: import it into software that reads QFX and export from there, or convert the original PDF statement. The uploader here does not read QFX files, and it does not write them either: a genuine QFX carries a bank issued INTU.BID, so it exports OFX, CSV and Excel from the statement instead.
Yes. When the OFX carries ledger balance data, the workbook includes a running balance column so you can confirm the ending figure matches your statement. That makes the sheet reconcilable rather than just a list of amounts.
Choose Excel when you want a formatted workbook with a header row that is ready for formulas and pivot tables. Choose CSV when you want a plain comma file that any tool, database, or accounting import can read. Both carry the same transactions.
Uploads here are protected by 256-bit encryption in transit and you can delete a file at any time. Before sending financial data to any online tool, confirm it encrypts uploads and lets you control deletion, and read its privacy and retention policy.
Prefer a plain CSV instead of a workbook.
Convert a PDF statement straight to OFX.
Go the other way: turn a spreadsheet into OFX.
Convert a PDF statement to Excel.
Turn an OFX or QFX file into a readable PDF report.
Get started converting bank statements to OFX.
USD
per month
per month
$294 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion with bulk upload, custom templates and reports.
USD
per month
per month
$894 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
