Convert Excel to OFX for Quicken, GnuCash & More
Turn your Excel transaction data into OFX — the open standard accepted by GnuCash, Moneydance, Xero, Sage, and dozens of other finance tools. Using Quicken? Take the QFX of the same sheet, one click from the same upload.
XLSX and XLS supported. Auto-detects columns. Free online — no signup.
How It Works
Upload Your Excel File
XLSX or XLS with transaction data. Date, amount, and description columns auto-detected.
Converted to OFX
Columns mapped to OFX STMTTRN fields. Unique FITIDs generated for each transaction.
Download OFX
Import into GnuCash, Moneydance, Xero, Sage, or any OFX-compatible software. Quicken needs the QFX — one click, same upload.
OFX or QBO — Which Do You Need?
OFX (This Tool)
- Open standard — widest compatibility
- GnuCash, Moneydance, Banktivity
- Quicken — via the QFX download
- Xero, Sage, YNAB, AceMoney
- Use for anything except QuickBooks and Quicken \u2014 those two need QBO and QFX
QBO (QuickBooks Only)
- OFX + Intuit INTU.BID header
- QuickBooks Desktop and Online only
- Not accepted by other software
- Use Excel to QBO instead
Software That Accepts OFX
Personal Finance
Quicken (via QFX), Moneydance, AceMoney, MoneyMoney
Open Source
GnuCash, KMyMoney, HomeBank
Cloud Accounting
Xero, Sage, YNAB, Zoho Books
Columns Detected Automatically
"Date", "Trans Date", "Posted"
"Amount", "Debit/Credit", "Total"
"Description", "Payee", "Memo"
What is Excel?
Microsoft Excel Spreadsheet (XLSX/XLS)
Rows and columns of transaction data. Most finance software can't import Excel directly — it needs a structured format like OFX.
What is OFX?
Open Financial Exchange
Open standard for financial data. STMTTRN blocks with typed fields and FITIDs. Accepted by GnuCash, Moneydance, Xero, Sage, and more. Quicken is the exception — it takes only QFX, the Intuit variant of this same format.
Why This Tool
Auto Column Detection
Date, amount, and description columns detected automatically — no manual mapping.
Debit/Credit Support
Single amount column or separate debit/credit columns both handled correctly.
FITID Generation
Unique transaction IDs for deduplication. Import the same file twice without creating duplicates.
Universal Compatibility
OFX works with GnuCash, Moneydance, Xero, Sage, YNAB, and dozens more. For Quicken, one click gives you the QFX of the same sheet.
XLS + XLSX
Both modern (.xlsx) and legacy (.xls) Excel formats supported.
Transaction Types
Debits, credits, and checks mapped to correct OFX TRNTYPE values.
When to Use This
Quicken Import
Bank doesn't offer direct download? Convert your Excel statement here and take the QFX download — Quicken refuses plain OFX, and the QFX costs nothing extra.
GnuCash / Moneydance
These open-source tools accept OFX natively. Convert Excel data and import via File > Import.
Xero & Sage
Moving spreadsheet data into cloud accounting? OFX imports into Xero and Sage bank feeds.
Excel-to-OFX Issues & Fixes
Quicken won't open the .ofx file, or says it cannot verify the financial institution
Quicken does not import plain OFX, and renaming .ofx to .qfx does not fix it: what Quicken checks for is Intuit's INTU.BID institution header, which lives inside the file. Use the QFX download link under the download button — same upload, same transactions, free.
Dates swapped — month and day reversed
Ambiguous dates like 03/04/2026 may parse as MM/DD or DD/MM. Verify your spreadsheet's date format matches the output.
Amounts missing or zero after import
Remove currency symbols ($) and commas from your Amount column. OFX needs plain numbers like 1250.00.
GnuCash shows "no matching account" on import
GnuCash asks you to map the OFX account to an existing account in your chart of accounts. Select the correct bank/credit card account from the dropdown.
Frequently Asked Questions
Which software accepts OFX files?
GnuCash, Moneydance, Xero, Sage, YNAB, AceMoney, and most personal finance tools — OFX is the most widely supported financial data format. Intuit's two are the exceptions: QuickBooks needs QBO and Quicken needs QFX.
Should I use OFX, QBO or QFX?
QBO for QuickBooks (Desktop or Online), QFX for Quicken, and OFX for everything else — GnuCash, Moneydance, Xero, Sage. OFX is the open standard; QBO and QFX are Intuit's two variants of it, each carrying an institution header their app checks on import.
Do I need specific column names?
No. Date, amount, and description columns are auto-detected regardless of header naming.
Does it handle separate Debit and Credit columns?
Yes. Separate columns are detected and combined into correctly signed OFX amounts.
What about .xls files?
Both .xlsx and .xls formats supported. Same OFX output either way.
Will Quicken accept this OFX file?
No — and renaming it to .qfx will not help, because what Quicken looks for (Intuit's INTU.BID institution header) is inside the file. Without it Quicken says "unable to verify the financial institution information" and stops. Use the QFX download link under the download button instead — same upload, same transactions, and re-downloading a format is free.
ProperConvert and csv2ofx charge $40+. Is this free?
Yes. No transaction limits, no trial caps, no desktop install. Fully free in your browser.
Is my data secure?
Encrypted via TLS, processed in memory, never stored. Your file is deleted immediately after conversion.
Related Tools
Excel to QBO
Convert Excel (XLSX/XLS) files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →CSV to OFX
Convert CSV financial files to OFX for GnuCash, Moneydance, Xero, and other accounting tools. Quicken users get QFX from the same upload in one click. Free, no signup.
Convert now →PDF to OFX
Convert bank statement PDFs to OFX for GnuCash, Moneydance, Xero, and Microsoft Money. Quicken users get QFX from the same upload in one click. Free online tool.
Convert now →Excel to QIF
Convert Excel (XLSX/XLS) spreadsheets to QIF for all versions of Quicken and compatible personal finance tools. Free, instant, no signup required.
Convert now →