Convert OFX to Excel — Formatted, Typed & Pivot-Ready
Turn your bank's OFX download into a formatted Excel workbook with typed dates, proper amounts, and clean columns — ready for pivot tables, VLOOKUP, and analysis.
Works with OFX and QFX files from any bank. Dates and amounts properly typed. Free online — no signup.
How It Works
Upload Your OFX File
OFX or QFX file from your bank. Both OFX 1.x (SGML) and OFX 2.x (XML) auto-detected — no need to know which version your bank uses.
Data Typed & Formatted
Dates become real Excel dates, amounts become numbers (not text), descriptions are trimmed. Every cell has the right data type from the start.
Download XLSX
Formatted workbook with header row, typed columns, and clean data. Opens in Excel, Google Sheets, LibreOffice, or Numbers — pivot-ready immediately.
Why You Can't Just Open OFX in Excel
Excel doesn't understand OFX format. Here's what happens when you try.
SGML Files Won't Parse
OFX 1.x uses SGML, not XML. Excel's XML importer rejects these entirely. Most US bank downloads are OFX 1.x.
Dozens of Junk Columns
XML import creates columns for every tag — bank headers, metadata, account IDs. You'd delete 30+ columns manually.
Dates as Raw Strings
OFX dates look like 20260315120000. Excel imports these as text — no sorting, no date formulas, no filtering by month.
Amounts as Text
Transaction amounts import as text strings. SUM returns 0, pivot tables won't aggregate, and "number stored as text" warnings appear everywhere.
Excel or CSV — Which Format Do You Need?
Excel XLSX (This Tool)
- Dates and amounts properly typed
- Pivot tables, charts, formulas work immediately
- Best for analysis and reporting
- Clean column headers, formatted cells
- Opens in Excel, Sheets, LibreOffice
CSV (Plain Text)
- Everything stored as text strings
- Maximum software compatibility
- Best for importing into other tools
- May need manual reformatting in Excel
- Use OFX to CSV instead
What is OFX?
Open Financial Exchange
Banking industry standard for financial data exchange. OFX 1.x uses SGML, OFX 2.x uses XML. Each transaction is a STMTTRN block with date, amount, payee, and a unique FITID. Not human-readable — designed for software, not spreadsheets.
What is XLSX?
Microsoft Excel Open XML Spreadsheet
A real spreadsheet with typed cells — dates are Excel dates, amounts are numbers, text stays text. Formulas, pivot tables, charts, and filters work immediately. Opens in Excel, Google Sheets, LibreOffice, and Numbers.
Why This Tool
Typed Date Cells
OFX stores dates as YYYYMMDDHHMMSS strings. Our XLSX output has proper Excel dates — sortable, filterable, and formula-compatible. No manual date parsing.
Amounts as Numbers
Transaction amounts are real numbers in Excel, not text. SUM, AVERAGE, SUMIF, and pivot table calculations work immediately without "number stored as text" warnings.
OFX 1.x & 2.x Handled
Most US banks still export SGML-based OFX 1.x (no closing tags). We parse both SGML and XML versions automatically — no errors, no manual selection.
QFX Files Included
QFX is Intuit's branded OFX for Quicken. Same internal structure, different extension. Upload .ofx or .qfx — both produce clean XLSX output.
Clean Header Row
Column headers named clearly: Date, Description, Amount, Type, Reference, Check Number. No cryptic OFX tag names like DTPOSTED or TRNAMT in your spreadsheet.
Pivot-Ready Output
With typed dates and amounts, you can immediately create pivot tables to analyze spending by month, category, or payee. No data cleanup step needed.
When to Use This
Transaction Analysis
Build pivot tables, charts, and SUMIF formulas from your bank transactions. Filter by date range, sort by amount, find the largest expenses — all in Excel.
Multi-Account Consolidation
Download OFX from each bank account, convert to XLSX, and combine into one workbook with tabs per account for unified cash flow analysis.
Bookkeeper Data Prep
Accountants and bookkeepers reviewing client bank data before importing into QuickBooks, Xero, or Sage. Excel is the staging area for cleanup and categorization.
What You Can Do With the XLSX
Sort & Filter
Filter by date range, sort by amount, find specific payees. Auto-filter on every column header.
Pivot Tables & Charts
Spending by month, category breakdowns, income vs expenses — one-click pivot table from properly typed data.
Formulas & VLOOKUP
SUM, SUMIF, AVERAGE, VLOOKUP, INDEX-MATCH — all work because amounts are real numbers, not text strings.
OFX-to-Excel Issues & Fixes
OFX file won't upload — "unsupported format" error
Verify the file extension is .ofx or .qfx (not .qbo — that's a different format). Some banks rename the download. Check the file in a text editor: it should start with OFXHEADER or <?xml and contain <STMTTRN> tags.
Spreadsheet has fewer transactions than my bank shows
Banks default to 30 or 90 days when exporting OFX. Log into your bank portal and select a wider date range before downloading. The OFX file includes DTSTART/DTEND tags showing the exact period covered.
Description column has truncated payee names
Some banks truncate the NAME field to 32 characters in OFX exports. The full description may be in the MEMO field — check the Memo column in your spreadsheet for additional detail.
I need to combine OFX files from multiple accounts
Convert each OFX file separately to XLSX. Then copy-paste all transactions into one workbook, or use a new tab per account. Add an "Account" column to track which bank each transaction came from.
Frequently Asked Questions
Can't I just open an OFX file in Excel directly?
No. Excel doesn't understand OFX format. If you try, you'll get either raw XML/SGML tags spread across dozens of columns, or Excel will refuse to open it entirely. OFX 1.x (SGML) files won't even parse as XML.
Why Excel instead of CSV?
CSV stores everything as text — dates, amounts, IDs are all strings. Excel (XLSX) has typed cells: dates you can sort chronologically, amounts you can SUM, and text that stays text. No reformatting needed after opening.
Does it handle both OFX and QFX files?
Yes. QFX is Intuit's branded OFX for Quicken — identical internal format, different file extension. Upload either .ofx or .qfx.
What columns are in the spreadsheet?
Date, Description, Amount, Transaction Type (DEBIT/CREDIT/POS/ATM), Reference ID (FITID), and Check Number (when present). All extracted from the OFX transaction records.
Can I build pivot tables from the output?
Yes. Dates and amounts are properly typed, so Excel pivot tables, charts, SUMIF, and VLOOKUP formulas work immediately. No "dates stored as text" issues.
My OFX file is from 2019 — will old files work?
Yes. The OFX format hasn't changed significantly since version 1.0. Files from any year parse correctly.
ofxconverter.com limits me to 1 file/day without registration. Is this really unlimited?
Yes. No daily limits, no registration, no file count restrictions. Convert as many files as you need.
Can I open the XLSX in Google Sheets?
Yes. Upload to Google Drive and open, or use File > Import in Google Sheets. XLSX is natively supported.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your OFX file is deleted immediately after conversion.
Related Tools
OFX to CSV
Convert OFX (Open Financial Exchange) files to CSV for spreadsheets and analysis. Extracts dates, amounts, and descriptions. Free, instant, no signup required.
Convert now →OFX to QBO
Convert OFX files to QBO for QuickBooks Desktop and Online. Ensures smooth import when QuickBooks prefers QBO over OFX. Free, instant, no signup required.
Convert now →PDF to Excel
Turn bank statement PDFs into formatted Excel spreadsheets. Keeps all columns, headers, and transaction details. Any bank, any language. Free, no signup.
Convert now →CSV to Excel
Convert CSV files to formatted Excel (XLSX) spreadsheets with proper columns and headers. Opens in Excel and Google Sheets. Free, instant, no signup required.
Convert now →