Guide · Bank download files
What is a QFX file?
A QFX file is a bank transaction download used to import account activity into Quicken through Web Connect. It contains structured data—dates, amounts, descriptions and account details—not a statement laid out like a PDF.
Sources checked October 28, 2026
Just want to read it? Open it in our free QFX to CSV or Excel converter. No Quicken or account needed; the file stays in your browser. To add the transactions to Quicken instead, use its file import menu.
Check the letters: .qfx is a bank download. .qxf is a different
format for transferring data between Quicken files. Renaming one does not turn it into the other.
Only have a bank statement PDF? Use our bank statement to Excel converter: start free or see how it works. It converts only bank and credit card statements, with every amount checked against the bank’s balances. It does not create QFX files.
What’s inside a QFX file?
QFX is based on OFX (Open Financial Exchange), with additional information used by Quicken. A bank or credit card download typically includes the account, currency, transaction list and a balance. Each transaction has labeled fields. Here’s one from our made-up Northwind sample:
<DTPOSTED>20260322Posted on March 22, 2026<TRNAMT>-48.60$48.60 spent<NAME>SHELL OIL 5521The transaction description<FITID>N-0322-1The bank’s transaction ID—not a check numberThat is an excerpt, not a complete import file. Dates can also include a time and time zone. A negative amount normally means money out; a positive amount means money in. On credit cards, purchases are negative and payments or refunds are positive.
Download the sample QFX to try the viewer. It contains fictional data and bank identifiers; it is not a Quicken import template.
How to open a QFX file without Quicken
- Open the free converter and choose your QFX file.
- Check the account, dates and transaction preview. Choose Excel or CSV.
- Download the result. Open the Excel file directly, or import the CSV into your spreadsheet.
The QFX file, as your bank sends it
<STMTTRN> <TRNTYPE>CHECK <DTPOSTED>20260305 <TRNAMT>-1650.00 <FITID>N-0305-1 <CHECKNUM>1001 <NAME>RENT - GREENVIEW APTS </STMTTRN> <STMTTRN> <TRNTYPE>POS <DTPOSTED>20260322 <TRNAMT>-48.60 …
The spreadsheet the free converter makes from it
Main columns shown. The download also keeps the memo, type, check number and the bank’s transaction ID where the file has them, and can split amounts into money in and money out.
Excel does not turn QFX tags into a transaction table just by opening the file. Convert it first;
changing .qfx to .csv or .xlsx does not convert the contents.
In Google Sheets, use File → Import → Upload with the converted file.
To inspect the raw data, open a copy with a plain-text editor such as Notepad. Don’t save edits over the original. Older files use SGML-style tags; not every QFX file is strict XML.
Our tool reads bank and credit card transactions and the cash side of investment accounts. Investment buys, sells and dividends are listed as not included. Keep the bank’s original download and statement: a converted spreadsheet is a working copy, not the original bank document.
How to import a QFX file into Quicken
These steps are for Quicken Classic. First, back up your Quicken data file. If you need a fresh download, sign in to your bank’s website, open the account’s transactions, choose the dates and look for Quicken, QFX or Web Connect under Download or Export.
- Windows: choose File → File Import → Web Connect (.QFX) File, then select the download.
- Mac: choose File → Import → Bank or Brokerage File (OFX, QFX), then select the download.
When prompted, link to the correct existing account, or create a new one only if needed. Review the transactions and balance afterward. Avoid overlapping dates where possible, and check for duplicates before accepting or adding transactions.
A local file does not mean an offline import. Quicken says Web Connect needs online validation, a supported version and an active subscription. The bank must still support Web Connect for the import to be authorized. Viewing the data in a spreadsheet is a separate job and does not require that authorization.
QFX, QXF, OFX and QBO: which is which?
| File | What it’s for |
|---|---|
| QFX | Bank transaction downloads for Quicken Web Connect. Based on OFX, with extra Quicken information. |
| QXF | Transferring eligible account data between Quicken files. Not the bank-download format. |
| OFX | Open Financial Exchange data used by financial applications. Quicken Windows does not accept it through its QFX import; the Mac menu lists both OFX and QFX. |
| QBO | A QuickBooks Web Connect file, also based on OFX. Not the same thing as the QuickBooks Online service, often shortened to “QBO”. |
Similar contents do not make the files interchangeable. If your destination is QuickBooks Online rather than Quicken, follow the QuickBooks Online import guide.
If the QFX file won’t import
| What happens | What to check first |
|---|---|
| Double-clicking does nothing, or opens the wrong app | Try the import menu inside Quicken. The file may be fine; its default app may be wrong. |
| Quicken cannot verify the financial institution | Check current Web Connect support with the bank, your subscription and software version. A download button alone does not prove import is still supported. |
| No new transactions appear | Check the destination account, selected dates and whether the transactions are already there. Inspect the file’s contents before trying another import. |
| The file is empty or missing transactions | Download again with the right account and dates. If the bank’s file is still incomplete, ask the bank for a corrected download. |
Don’t change bank identifiers or disconnect accounts as a first fix. Save the exact error and follow Quicken’s Web Connect troubleshooting. Quicken also says it does not provide support for QFX files made by third-party converters.
If transactions import but the balance is wrong, compare the account with the bank statement rather than repeatedly importing the same period.
Questions
Can I open a QFX file for free?
Yes. Use our free browser tool to view bank and credit card transactions and download CSV or Excel, without an account. A plain-text editor can show the raw tags. Neither method imports the data into Quicken.
Is a QFX file the same as a bank statement PDF?
No. A QFX file carries structured account and transaction data for a selected date range. A PDF preserves the statement’s layout and notices. Keep the original statement; the transaction download may cover a different period.
Can I rename QFX to PDF or CSV?
Renaming changes the filename, not the format. Convert the transactions to CSV or Excel for a usable table. For the bank’s original PDF statement, download it from the bank’s statements section.
What’s the difference between OFX and QFX?
QFX is OFX with extra information Quicken uses to check the bank supports Web Connect. The transactions inside look much the same. Quicken for Windows imports QFX but not OFX; Quicken for Mac lists both.
Why won’t Quicken open my QFX file?
Double-clicking may open the wrong app, so use Quicken’s own import menu first. If Quicken still refuses, the usual reasons are that the bank no longer supports Web Connect, or your Quicken version or subscription doesn’t. Note the exact error and check with Quicken and the bank. The file can still be readable in a spreadsheet when Quicken won’t import it.
Can I convert a CSV to QFX for Quicken?
You often don’t need to. Quicken Classic for Windows imports bank transactions from a CSV in its own column layout (File → File Import → Banking Transactions → From (.CSV) File), and Quicken for Mac imports a Mint-style CSV into a new account. Unlike a QFX, a CSV import doesn’t check for duplicates. We don’t make QFX files.
Can I import an Excel spreadsheet into Quicken?
Not as an Excel file: Quicken says it can’t import .xls files. Save the sheet as CSV in the column order Quicken asks for, then use its CSV import.
Can I convert a QFX file to QBO?
Renaming won’t work: a QBO file carries QuickBooks’ own bank information. If you use QuickBooks Online, you may not need one, since its upload accepts bank files and CSVs; see the QuickBooks Online import guide. We don’t make QBO files.
Sources
Quicken’s Windows import help, Mac import help, Web Connect troubleshooting, Windows CSV import, Mac CSV import and QXF transfer documentation. Checked October 28, 2026. Menus and bank support can change.
Open your QFX file in a spreadsheet
Our free converter turns QFX, OFX, QBO and QIF downloads into Excel or CSV, right in your browser. Nothing is uploaded.
No sign-up for the file converter · PDF statements: 20 free pages every month