Free converter · OFX/QFX → Excel

Convert OFX or QFX to Excel

Convert an OFX or QFX bank or card download to a CSV that opens in Excel: Date, Description, Amount and Balance, one row per transaction. Free up to 100 transactions.

Free up to 100 rowsColumns detected automaticallyFiles deleted after 1 hour
Processed in memory, never stored
No file handy? See the result on a fictional one first:

Only have a PDF statement? Use the PDF statement converter.

Why Excel?

Excel won't open an OFX or QFX file as a spreadsheet. Banks that still offer OFX/QFX (or Quicken QFX) downloads leave you with a file you can't review, filter or hand to an accountant without converting it. Utilly reads the transactions and writes a CSV laid out for Excel, the same columns as our PDF-to-Excel download.

How to convert OFX or QFX to Excel

  1. Download the OFX or QFX file from your bank or card issuer for the dates you need (a Web Connect .qbo file works too).
  2. Upload it above. We read each transaction's posted date, amount and payee, and tell bank files from credit card files.
  3. Check the preview. Money out should be negative. If your file puts the useful text in the memo, pick the Memo column as the Description.
  4. 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.

What carries over from the OFX file

One transaction in the OFX or QFX file:

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

becomes this row in the CSV (opened in Excel):

Date,Description,Amount,Balance
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18,
In the OFX / QFXIn the Excel CSV
DTPOSTED (posted date)Date column, written YYYY-MM-DD. The time and time zone are dropped.
TRNAMT (amount)Amount column, signed as in the file, two decimals: negative for money out.
NAME (or MEMO when NAME is empty)Description. Encoded characters are decoded first, so H&amp;M comes through as H&M.
LEDGERBAL (ending balance)Balance on the last row when the file carries a usable ledger balance. Otherwise left blank.
Credit card statement block (CCSTMTRS)Same four columns. Charges negative, payments and credits positive.
FITID (transaction ID)Not in the CSV. Spreadsheets have no field for them.

Which files work

  • OFX 1.x (SGML) and OFX 2.x (XML) files, Quicken QFX files and QuickBooks Web Connect .qbo files.
  • Bank and credit card statement downloads. Investment (brokerage) downloads aren't supported.
  • Downloads with several accounts in one file: each account is read and downloaded on its own, with its type and last 4 digits in the file name, plus one combined CSV with an Account column.
  • Encoded characters are decoded, so H&amp;M in the file becomes H&M in Excel, and accented payees in UTF-8 or Windows-1252 files come through intact.
  • Free up to 100 transactions, and up to 20,000 per file.

Common problems

ProblemFix
Excel opens the file as one long columnUse Data → From Text/CSV (or File → Open) and set the delimiter to comma. Don't paste the file contents into a cell.
Dates look like text, or day and month are swappedImport with Data → From Text/CSV and set the Date column's data type. Our dates are year-first (YYYY-MM-DD), so they sort correctly as dates or as text.
Card payments show as chargesChoose Credit card as the account type, check the signs in the preview and tick Flip signs if they're backwards.
Balance column is emptyThe OFX file didn't carry a usable ledger balance. Reconcile against your statement, or add a running balance with a formula once the sheet is open.
"No transactions found in that OFX/QFX/QBO file"The download has no transactions for that date range, or it's an investment file. Download the bank or card account again with a wider date range.

Other conversions

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.

Can I convert a QFX file to Excel?

Yes. QFX is Quicken's version of OFX. Upload the .qfx here, or use the Quicken-framed QFX to Excel converter — same Clean CSV either way.

Does it work with credit card OFX files?

Yes. A credit card download is 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 OFX or QFX file carries a ledger balance we can use, or when a Balance column in another upload matches every row. Otherwise the Balance cells are blank and you reconcile against your statement.

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

Yes. We read each account separately. Each one gets its own tab in the preview and its own CSV, named after 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.

Other converters

More bookkeeping tools