QFX Format

Free Excel to QFX Converter Online — XLSX to Quicken QFX

A QFX is an ordinary financial file with an ID card stapled to the front. Quicken reads that card before a single transaction, which is why it takes a QFX, refuses the same data as a plain OFX, and will not look at a spreadsheet at all. Your rows come out of the workbook and go back with the card attached. Drop in the .xls or .xlsx as it came — it is read on your own machine and never uploaded.

Bank-grade security - Files processed securely and deleted immediately
Trouble converting a file? Tell us — we fix issues fast. Report it

Not the file you need?

Exported as CSV instead?
The same .qfx from a plain-text export
Statement arrived as a PDF?
Straight to .qfx, no spreadsheet in between
Need the categories kept?
A QIF has a field for them; a QFX has none
GnuCash, Xero or Sage?
Those read plain OFX and need no Intuit header

Why Use Our Excel to QFX Converter Tool?

It writes the part Quicken checks

A QFX carries an Intuit institution ID, and that ID is what Quicken looks at before opening the file — which is why the same rows saved as a plain OFX get refused. It is written for you, with the file's two identity fields set to agree.

Your columns, not somebody's template

Most converters hand you a blank sheet with Date, Payee and Amount across the top and ask you to move your data into it. Nothing here needs rearranging — your columns are identified whatever they are called and whatever order they sit in.

The trial ends where a real statement starts

The established paid add-in stops its trial at 100 transactions, about one busy month — far enough to prove it works, not far enough to finish a year. Up to 50,000 rows go through here at once, as often as you like.

How to convert Excel to QFX in three steps

1

Bring the workbook as it is

No template, no prescribed headings, no Save As to CSV first. Converting xlsx to QFX and xls to QFX are the same job here, and most alternatives open by asking you to move your data into their layout.

2

Upload the spreadsheet

Drag the workbook on, or click to browse. It is read here on your own machine, and the tab holding the transactions is the one used — a cover page in front of it changes nothing.

3

Set the account, pick your bank, take the file

A QFX must declare what a spreadsheet never records: the account kind, its number, its currency, and the institution ID Quicken checks. Pick your bank and the transactions arrive under your own name rather than a placeholder.

What your spreadsheet needs

Three columns, in any order, under any headings. Everything else on the sheet is read if it is there and ignored if it is not.

Required

A date
Any format — 13/05/2025, May 13 2025, or the serial number 45790
An amount
One signed column, or separate debit and credit columns
A description
Whatever your bank called it; nothing is rewritten

Used if present

A running balance
The last row becomes the closing balance inside the QFX
A cheque or reference number
Carried through to the transaction
A memo or notes column
Kept alongside the description, not instead of it

Why Quicken turns a converted file away

Quicken will not read a spreadsheet, and CSV is no way round it

Quicken imports QIF, QFX and QDF — that is the list. An .xlsx is refused, and so is the .csv most people try next, because Quicken's only CSV import is for security prices rather than transactions. The advice to "just save it as CSV" is a dead end.

A plain OFX is refused though the data is identical

OFX and QFX hold the same rows in the same layout, and the difference is a single tag. A plain .ofx from a general-purpose converter is turned away with nothing wrong in it — the tag itself is shown further down.

Converted files that all claim to be the same bank

Quicken shows the institution from the ID inside the file, so a converter writing one fixed ID makes every file you convert look like the same account. The list here runs to nearly 7,000, split so a credit card is only offered IDs the importer accepts on a card.

QIF looks simpler and often is not

Quicken for Mac reads a QIF only while creating a new file, never into an existing account, and QIF carries no transaction identifiers, so re-importing an overlapping month duplicates every row. What QIF has and QFX has not is a category field.

QFX, QIF or OFX — which one does Quicken take?

All three hold the same transactions. Which one your copy of Quicken will actually open, and what survives the trip, is what separates them.

What you get
QFX
this page
QIF
OFX
Quicken opens itYesYesNo
Into an account you already haveYesWindows only—
On Quicken for MacYesNew file onlyNo
Spots rows you already importedYesNoYes
Carries your categoriesNoYesNo
Read by GnuCash, Xero, SageNoYesYes

Quicken for Mac reads a QIF only while creating a new file, never into an existing account. If your sheet has a category column worth keeping, that is the one real reason to choose the Excel to QIF converter instead.

Who needs a QFX out of a spreadsheet

Leaving QuickBooks

Exporting from the old program hands you a spreadsheet, and Quicken will not read one. The workbook you already have is the file this takes.

Banks that only send Excel

Many banks offer a spreadsheet download and no QFX option at all. Converting afterwards is the only route in, and the bank need not add anything.

A register you keep yourself

Cash books, petty cash sheets and rental ledgers have no download to fall back on. Whatever columns you keep them in are read as they stand.

Quicken on a Mac

Quicken for Mac reads a QIF only while creating a new file, so QIF is closed off for an account that already exists. QFX stays open.

Locked-down work machines

The paid alternative is an Excel add-in, and an installer is exactly what a managed laptop refuses. Nothing is installed here.

Back-filling old months

Statements older than your bank still serves usually survive as spreadsheets. Those convert like a current one, long after the download link expired.

The line that decides whether Quicken opens the file

A QFX is an OFX with one extra tag. Quicken reads that tag before anything else, which is why the same transactions saved as a plain OFX are turned away.

A plain OFX — refused

<SONRS>
  <LANGUAGE>ENG
  <FI>
    <ORG>YourConverter
  </FI>
</SONRS>

Nothing wrong with the transactions. Quicken simply never gets to them.

What this writes instead

<SONRS>
  <LANGUAGE>ENG
  <FI>
    <ORG>BSCai
    <FID>3000
  </FI>
  <INTU.BID>3000
</SONRS>

Pick your bank and that number becomes yours. Nearly 7,000 institutions, split so a credit card is only offered the ones the importer accepts on a card.

Frequently Asked Questions — Excel to QFX Converter

QHow do I convert an Excel file to QFX?

Upload the workbook, answer a few short questions about the account, and download the .qfx — under a minute, in the panel above. There is no column-mapping grid in between. The same upload serves everyone arriving by a different route: convert excel to qfx file, convert xls to qfx, convert excel to quicken qfx, create qfx file from excel.

QCan Quicken import Excel files directly?

No. Quicken accepts QIF, QFX and QDF, and a spreadsheet is none of those — there is no menu option for one, in any current version on either platform. That is why people end up looking for a converter: the export produced a workbook and the destination cannot read one.

QWhy will Quicken not take my CSV either?

Because Quicken's CSV import is for security prices, not transactions. It updates what an investment is worth and will not accept a list of dated payments however the columns are arranged, which is why support tells people QIF, QFX or QDF is the only route in.

QWhat is a QFX file?

A QFX is a financial-exchange file carrying an Intuit institution ID, which is the piece Quicken checks before opening anything. Strip that ID out and what remains is an ordinary OFX — same rows, same structure. A bank's "download for Quicken" link gives you a QFX; this makes one from a spreadsheet.

QWhich columns does my spreadsheet need?

A date, an amount and a description — listed in full above, with what else gets used if your sheet has it. Nothing needs a particular order or heading, because the columns are identified from your sheet rather than matched against expected names.

QDo I need to download or install anything?

No. It runs in the browser tab you already have open, on any operating system. Searches for an "excel to qfx converter free download" are usually looking for the paid Excel add-in, which means Excel for Windows only and an installer a managed laptop will refuse.

QDoes my spreadsheet get uploaded?

No. The workbook is opened and read inside your browser, on your own computer, and the file itself never leaves your machine. The .qfx is built the same way and saved straight to your downloads folder. Nothing you type into the account fields is stored either.

QWhich bank will the converted file say it came from?

Whichever you pick from the institution list before downloading. Quicken shows the institution from the ID inside the file, so that choice is the name beside your imported transactions. The list holds nearly 7,000 and is split by account family, so a card is only offered IDs the importer accepts. Leave it and you get a generic entry, which imports fine.

QShould I use QFX or QIF?

QFX in almost every case; QIF only when your sheet holds categories worth keeping, because that is the one field QFX has no room for. The comparison above sets the two side by side row by row.

QMy dates show as numbers like 45870. Is that a problem?

Not here. Excel keeps a date as a count of days since 1900 and only shows 13/05/2025 because the cell is formatted to; read the raw value and you get the number underneath. Those are turned back into real dates before the QFX is written. It is the commonest way a converted statement comes out wrong.

QDo I have to tidy the spreadsheet up first?

No. A cover tab, a summary sheet, a logo, merged heading rows, a totals row underneath — none of it needs deleting, because the sheet holding the transactions is located rather than assumed and the table is found rather than expected at cell A1. Up to 50,000 rows in one pass.

QHow do I import QFX into Quicken?

File → Import → Web Connect File, or open the .qfx with Quicken running, then choose the account. QFX is the Quicken Web Connect format, which is why the menu says that rather than the extension. Transactions land in Downloaded Transactions, so nothing is committed until you accept them.

QHow do I import Excel into Quicken?

You convert it first — that is the whole of it. The short answer to how to import Excel into Quicken is that there is no Excel import to use, so the workbook becomes a QFX and that goes in through File → Import. Advice to convert Excel to Quicken by saving as CSV instead is wrong for transactions.

QWhat if my statement is a PDF or a CSV rather than a workbook?

Both have a page of their own. A PDF goes through the PDF to QFX converter, which reads it directly and skips the spreadsheet stage — worth doing even if you were about to export one. Plain text goes through the CSV to QFX converter. Tools that convert Excel to OFX serve GnuCash, Xero and Sage, which want no Intuit header.

QWhat is the best Excel to QFX converter?

Check the output before the price: several tools advertised for this job write a plain OFX, which Quicken refuses, so the file is useless before you compare anything else. Big Red Consulting's add-in is the established paid choice at $79 the first year and $69 after, but it is Excel for Windows only and its trial stops at 100 transactions. ProperSoft's ProperConvert is around $57. Most free web tools are a bare upload box with no way to state the account type, which the format requires.

Other Conversion Formats

PDF to QIF Converter

Convert to QIF

CSV to QIF Converter

Convert to QIF

CSV to QBO Converter

Convert to QBO

CSV to OFX Converter

Convert to OFX

CSV to QFX Converter

Convert to QFX

CSV to IIF Converter

Convert to IIF

Make the file Quicken will open

One upload stands between the workbook on your desktop and a file Quicken opens without argument. Send it as it is, answer the questions about the account, and the .qfx comes back with the header Quicken checks already written in — an Excel to QFX converter online free to use, with no trial cap at transaction 101.