How to Open OFX File and Convert It to Excel or CSV
An OFX file is a bank or credit card statement in Open Financial Exchange format, downloaded from your bank's website for budgeting and accounting apps. You can import it into QuickBooks Online, GnuCash, Moneydance or YNAB, but not into Quicken for Windows, which needs QFX. To just read it, the free viewer below shows every transaction, balance and account detail in your browser and converts the file to Excel or CSV, without uploading your bank data anywhere.
Choose what you need
Open OFX File Online: View Transactions & Convert to Excel (Free)
Drop an .ofx file below. The viewer reads the bank or credit card statement (or investment statement) and shows the institution, account, statement period, balances and every transaction, then exports them to Excel, CSV or a QuickBooks Online-ready CSV. It also checks for duplicate or missing transaction IDs, the most common reason imports skip transactions.
Good to know: your statement is processed on this device; account numbers are masked on screen.
🔒 Nothing is uploaded — your bank data never leaves this deviceOn this page
What is an OFX file?
OFX (Open Financial Exchange) is a standard text format for financial data, created in 1997 by CheckFree, Intuit and Microsoft. When you choose "Download transactions" on your bank's website and pick OFX, Money or "Microsoft Money" format, you get an .ofx file with the account number, the statement period, the ending balance and every transaction with its date, amount, payee and a unique transaction ID.
Versions 1.x use an SGML style (tags without closing tags); versions 2.x are proper XML. Both are plain text, so a text editor shows them, but the raw tags are hard to read. Quicken's QFX and QuickBooks' QBO files are the same format with an extra Intuit bank ID.
| Full name | Open Financial Exchange |
|---|---|
| Versions | 1.0.2–1.6 (SGML), 2.0–2.3 (XML) |
| Contains | Bank, credit card and investment statements |
| Variants | .qfx (Quicken), .qbo (QuickBooks Web Connect) |
| Related | .qif (older Quicken), .csv (spreadsheet export) |
How to open an OFX file: quick answer
| What you want | Use |
|---|---|
| Read the transactions | The viewer above (any device) |
| Get it into Excel or Google Sheets | Viewer above > Download Excel or CSV |
| QuickBooks Online | Bank transactions > Upload from file (OFX accepted) |
| GnuCash (free) | File > Import > Import OFX/QFX transactions |
| Moneydance, YNAB, Banktivity | Their file import option |
| Quicken for Windows | Not supported: download QFX from your bank instead |
Open an OFX file in Excel or Google Sheets
Excel can't read OFX's tag format directly, and opening the file as text gives you a single column of tags. The quickest way:
- Drop the .ofx into the viewer at the top of this page.
- Check the summary: account, period, number of transactions and money in and out.
- Click Download Excel (.xlsx) for a spreadsheet, or Download CSV for Google Sheets, Numbers or any import tool.
Amounts are negative for money out and positive for money in, so you can sum, filter and build pivot tables right away.
Import OFX into QuickBooks, GnuCash and budgeting apps
QuickBooks Online
- Go to Transactions > Bank transactions (or Accounting > Bank transactions).
- Choose the account, then Link account > Upload from file (or Upload transactions if the account isn't connected).
- Select the .ofx file, pick the QuickBooks account and review the transactions before accepting them.
QuickBooks Online suggests QBO files but also accepts QFX, OFX and CSV. Intuit lists a limit of 350 KB and about 1,000 transactions per upload; split long periods into smaller downloads.
GnuCash and other apps
In GnuCash use File > Import > Import OFX/QFX transactions and match the account. Moneydance, Banktivity and YNAB also import OFX from their File or import menus. If an app only takes CSV, convert the file with the viewer above.
OFX and Quicken
Quicken for Windows imports Web Connect files (.qfx) but not plain .ofx files. QFX downloads are offered by banks that partner with Quicken, and they include an Intuit bank ID. If your bank only offers OFX:
- Look for a Quicken or Web Connect option in the bank's download page; that's the QFX file.
- Use Quicken's own bank connection (Express Web Connect / Direct Connect) instead of files.
- As a last resort, export a CSV with the viewer above and enter or import it as your Quicken version allows.
What's inside an OFX file
| Tag | Meaning |
|---|---|
<FI><ORG> / <FID> | Bank name and its OFX institution ID |
<BANKACCTFROM> | Routing number (BANKID), account number (ACCTID) and type |
<DTSTART> / <DTEND> | Statement period |
<STMTTRN> | One transaction: TRNTYPE, DTPOSTED, TRNAMT, FITID, NAME, MEMO |
<FITID> | The bank's unique ID for the transaction, used to avoid duplicates |
<LEDGERBAL> | Ending balance and its date |
<INVSTMTRS> | Investment statement: trades, dividends and positions |
An OFX file contains your account number and spending history. Don't upload it to unknown "free converter" websites; the viewer on this page processes it entirely on your device.
OFX problems and fixes
Transactions are missing after import
Importers skip transactions whose FITID was already imported. If your bank reuses IDs, they're treated as duplicates. The viewer flags repeated or missing FITIDs.
"The file is not valid" or nothing happens
The download may have been cut off (the viewer checks for the closing </OFX> tag), or the bank sent an error page saved as .ofx. Download it again with a shorter date range.
Dates or amounts look wrong
Some banks put the time zone in the date (for example [-5:EST]) or use commas as decimal separators. The viewer reads both; if an app misreads them, import the CSV instead.
Upload fails in QuickBooks Online
The file is probably over the size or line limit. Download a shorter period, or upload the CSV from the viewer.
Sources and technical references
- OFX Work Group and specification — Financial Data Exchange
- Manually upload transactions into QuickBooks Online (formats and limits) — Intuit
- How do I import data into Quicken for Windows? (OFX not supported) — Quicken
- Importing transactions from files (OFX/QFX, QIF, CSV) — GnuCash Manual
- Open Financial Exchange — Wikipedia
Frequently asked questions
How do I open an OFX file?
Drop it into the free viewer on this page to see the transactions and balances, or import it into a finance app that supports OFX, such as QuickBooks Online, GnuCash, Moneydance or YNAB. Quicken for Windows doesn't import plain OFX; it needs the bank's QFX download.
How do I convert OFX to Excel?
Open the file in the viewer on this page and click Download Excel (.xlsx) or Download CSV. Each transaction becomes a row with date, description, amount, type, memo and transaction ID. Nothing is uploaded.
Can Excel open OFX files directly?
Not usefully. Excel shows the raw OFX tags in one column. Convert the file to .xlsx or CSV first with the viewer on this page, then open that in Excel or Google Sheets.
Can I import an OFX file into Quicken?
Quicken for Windows doesn't import OFX files. Download the Quicken (QFX, Web Connect) option from your bank instead, or connect the account directly in Quicken.
How do I import OFX into QuickBooks Online?
Go to Bank transactions, choose the account, then Link account > Upload from file and select the OFX. Files must be 350 KB or smaller; download shorter date ranges if needed.
Why are some transactions missing after importing?
Finance apps skip transactions whose ID (FITID) they've already imported. If a bank repeats IDs, real transactions are treated as duplicates. The viewer on this page flags repeated or missing IDs.
Is it safe to use an online OFX converter?
Only if it doesn't upload your file. OFX files contain account numbers and your spending history. The converter on this page runs entirely in your browser.
What's the difference between OFX, QFX and QBO?
They're the same OFX format. QFX adds an Intuit bank ID for Quicken and QBO adds one for QuickBooks. OFX works with most finance apps except Quicken for Windows.
Last updated .