QFX to Excel Converter Online (CSV for Excel)

Why Excel?

Excel won't open a Quicken .qfx as a spreadsheet. A QFX is OFX underneath with Intuit bank tags Quicken checks, so opening it in Excel shows markup or one long column. Utilly reads each transaction and writes a CSV laid out for Excel, the same columns as our QFX to CSV download.

How to convert Quicken QFX to Excel

Get the Quicken Web Connect download. On your bank or card site pick Quicken / Quicken Web Connect and save the .qfx. A plain .ofx or QuickBooks .qbo works the same way here.
Drop it in the upload above. Posted date, signed amount and payee are read from each STMTTRN. Checking/savings files are told apart from credit card ones.
Review the preview. Spending should show as negative. When a bank truncated the payee at 32 characters, switch Description to the Memo column if the full text lives there.
Download the CSV and open it in Excel (File → Open, or double-click). Dates and amounts come through as real dates and numbers. Use File → Save As → Excel Workbook if you want a .xlsx.

Quicken QFX vs OFX vs QBO

"QFX to Excel" is usually typed by someone holding a Quicken Web Connect file. The three extensions are one format family with different Intuit wrappers:

You have	What to do
A bank-issued `.qfx` (Quicken Web Connect)	Drop it in the upload above. Intuit bank tags stay in the file for Quicken; we ignore them and turn each transaction into a spreadsheet row.
A plain `.ofx` bank download	Works here too. Prefer OFX-first Excel steps? Use the OFX / QFX to Excel converter — same Clean CSV.
A QuickBooks `.qbo` Web Connect file	Works here. The .QBO to Excel page also explains why "QBO" is not the same as QuickBooks Online the product.

From QFX tags to Excel columns

A Quicken .qfx is OFX text plus Intuit's bank ID. One payroll debit from our sample download:

<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18
<FITID>20260901E26D1A27070800<NAME>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>

lands in the Excel CSV as:

Date,Description,Amount,Balance
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18,

QFX field	Excel CSV column
DTPOSTED	Date as YYYY-MM-DD (time of day dropped) so Excel sorts and filters correctly.
TRNAMT	Amount as a signed plain number: deposits positive, withdrawals negative. No $ or thousands commas.
NAME (MEMO when NAME is empty)	Description; OFX entities such as `&` become a plain `&`.
LEDGERBAL	Copied onto the last row when the bank ships a usable ledger balance; otherwise left blank.
FITID, INTU.BID, BANKID, ACCTID	Omitted — useful for Quicken duplicate checks, not for a spreadsheet.

Which QFX files work

Checking, savings and credit card Quicken Web Connect downloads, including plain OFX and QuickBooks .qbo files produced by other converters.
Multi-account files: one preview tab and one CSV per account, plus a combined CSV whose first column is Account.
Investment / brokerage Web Connect downloads are refused.
Payees stored with HTML entities unescape into the sheet; UTF-8 and Windows-1252 accented names stay readable.
Free up to 100 transactions per file; hard cap 20,000.

Common problems

Problem	Fix
Double-click launches Quicken or "unable to verify the Financial Institution"	That's an import attempt against Intuit's bank list. Save the .qfx, then upload it here — Utilly never talks to Intuit.
Excel shows raw <STMTTRN> or <OFX> tags	You opened the .qfx. Open the converted .csv (Data → From Text/CSV, comma delimiter).
Dates look like text, or day and month swapped	Import with Data → From Text/CSV and set the Date column type. Our dates are year-first (YYYY-MM-DD).
Card payments show as charges	Choose Credit card as the account type in the preview; tick Flip signs if they are still backwards.
"No transactions found in that OFX/QFX/QBO file"	Empty date range, or an investment file. Re-download with a wider range.
Balance column is empty	Expected when the QFX has no usable LEDGERBAL. Add a running-balance formula in Excel, or reconcile against the statement.

Other conversions

Just need a Clean CSV (scripts, Wave, Zoho, FreshBooks): the QFX to CSV converter downloads the same file with CSV-first steps.
Prefer OFX-first Excel steps? The OFX / QFX to Excel converter is the same Clean CSV with OFX framing.
Have a Quicken .qif? The QIF to Excel converter keeps Quicken categories in a Category column.
Have a QuickBooks Web Connect .qbo? The .QBO to Excel converter explains .qbo files and the QuickBooks Online mix-up.
Have a QuickBooks Desktop .iif? The IIF to Excel converter keeps the SPL account as Category.
Need QuickBooks Web Connect instead? QFX to QBO (or OFX / QFX to QBO).
Need Desktop IIF instead? QFX to IIF (or OFX / QFX to IIF).
Need Quicken Classic QIF instead? QFX to QIF (or OFX / QFX to QIF).
Need a plain OFX for FreeAgent or Sage? QFX to OFX.
Only have PDF statements? The bank statement PDF to Excel converter checks each statement against its balances first.
Just need to open or view the .QFX? How to open a .QFX file covers Quicken for Windows and Mac, iPhone, QuickBooks, Excel and opening it without Quicken.
Just need to open or view the file? See how to open an OFX or QIF file for Excel, Quicken, QuickBooks and plain-text editor paths.

Pricing

Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.

FAQ

Questions

Is it free?

Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.

Do I get an .xlsx file?

You get a CSV laid out for Excel: Date, Description, Amount and Balance, one transaction per row. Excel opens it directly with real dates and numbers; use File → Save As → Excel Workbook to keep it as .xlsx.

Is a QFX file different from OFX?

Underneath, no — QFX is Quicken's Web Connect wrapper around OFX, with Intuit bank tags Quicken checks when you import. The transactions (date, amount, payee) are the same. This page frames the Quicken .qfx download; the OFX / QFX to Excel converter is the same product with OFX-first steps.

Does it work with a credit card QFX?

Yes. Card downloads are detected. Charges and fees come out negative; payments and credits positive. You can also choose Credit card as the account type in the preview.

Will the Balance column be filled in?

Yes when the QFX carries a ledger balance we can use. Otherwise the Balance cells are blank and you reconcile against your statement.

My bank's QFX has checking and savings in one file. Will that work?

Yes. Each account gets its own tab and its own CSV, named with the account type and last 4 digits. You can also download every account in one CSV with an Account column. One credit covers the whole file.

Can I convert a .QBO the same way?

Yes. They are the same format underneath. The .QBO to Excel converter takes .qbo files with QuickBooks-first steps, and this page accepts .qfx, .ofx and .qbo alike.

Convert QFX to Excel

Why Excel?

How to convert Quicken QFX to Excel

Quicken QFX vs OFX vs QBO

From QFX tags to Excel columns

Which QFX files work

Common problems

Other conversions

Pricing

Questions

Other converters

Convert CSV to QBO for QuickBooks

Convert Excel (.xlsx) to QBO for QuickBooks

Convert CSV to IIF for QuickBooks Desktop

Convert Excel to IIF for QuickBooks Desktop

Convert OFX or QFX to IIF

Convert a .QBO file to IIF

More bookkeeping tools

Receipts & invoices to CSV

Bank reconciliation checker

QuickBooks reconciliation discrepancy finder