How to Open a QFX File in Excel (Convert QFX to XLSX)
· قراءة 4 دقائق
Excel can't open a QFX file directly, because QFX is a Quicken bank download written in OFX code, not a spreadsheet. Convert it to an .xlsx workbook first: drop the file into the free QFX to Excel converter, press Excel, and open the download. It takes under a minute and the file never leaves your computer.
Below are the steps, what each column means, what we saw when we ran two test files through the converter, and how to add the running balance that QFX files leave out.
Why Excel can't open a QFX file
A QFX file is a Quicken Web Connect file. Inside it is Open Financial Exchange (OFX) markup: tags such as <STMTTRN>, <DTPOSTED> and <TRNAMT> wrapped around each transaction, plus Intuit's own sign on fields. Excel has no import filter for that format, so if you force it open (or open it in Notepad) you get one long block of tags, not rows and columns.
Most older QFX files aren't valid XML either, so the "open as XML table" trick people suggest on forums usually fails. Converting is the reliable route.
How to open a QFX file in Excel, step by step
- Get the QFX file. In online banking, open the account, choose Download or Export transactions, pick the date range and select "Quicken (.qfx)" or "Quicken Web Connect". If your bank only offers OFX or QBO, that works too.
- Open the QFX to Excel converter and drop the file in. You can drop several months at once.
- Check the preview. You'll see the number of transactions, money in, money out and the date range before you download anything.
- Press Excel. You get an .xlsx file named after your QFX file (or
transactions.xlsxwhen you merged several). - Open it in Excel or Google Sheets. Amounts arrive as numbers with two decimals, so SUM, filters and pivot tables work straight away.
Prefer CSV for another money program? Press CSV instead. Same rows, same columns.
What we got when we tried it
We built two test QFX files shaped like a checking account download: an October file with 6 transactions and a late October to early November file with 5. Two transactions, a Comcast bill and a Starbucks charge, were in both files. That's exactly what happens when monthly downloads overlap by a few days.
We dropped both files in together. The result:
| What the converter showed | Value |
|---|---|
| Transactions | 9 (11 in, 2 repeats removed) |
| Money in | 4,761.10 |
| Money out | 3,389.81 |
| Dates | 2026-10-01 to 2026-11-06 |
| Check number | 1043 in the Reference column |
The repeats were dropped because each transaction in a QFX file has a bank transaction ID (the FITID tag). When the same ID shows up twice, it's kept once. That's the part that saves the most time: copying monthly statements into one sheet by hand is where duplicate rows creep in.
One honest quirk: our check had the payee "CHECK" and the memo "CHECK 1043", and the Description column showed "CHECK CHECK 1043", because the converter joins payee and memo. Banks fill those two fields in different ways, so expect some descriptions to read a little clumsy. A quick Find and Replace in Excel tidies them.
What each column in the Excel file means
| Column | Comes from | Notes |
|---|---|---|
| Date | DTPOSTED (posted date) | Sorted oldest first |
| Description | NAME (payee) + MEMO | Joined into one cell |
| Reference | CHECKNUM or REFNUM | Empty for card and ACH lines |
| Money out | Negative TRNAMT | Shown as a positive number |
| Money in | Positive TRNAMT | |
| Amount | TRNAMT, signed | Use this one for totals |
| Balance | Not in the file | Left empty on purpose |
How to add a running balance in Excel
A QFX file only carries the closing ledger balance, not a balance after each transaction, which is why the Balance column is empty. You can rebuild it in two minutes:
- Find the closing balance. It's on your bank statement, or in the QFX file itself next to
<LEDGERBAL>and<BALAMT>if you open it in Notepad. - Type it in the Balance cell of the last row (say G10).
- In G9 enter
=G10-F10and fill it upward to row 2.
Each row now shows the balance after that transaction. If the first row lines up with the opening balance on your statement, nothing is missing. If it doesn't, a download gap is the usual reason: check that your date ranges touch.
Common problems and fixes
- "Not an OFX file" error. The download is probably a PDF statement or an HTML error page saved with a .qfx name. Open it in Notepad: a real QFX file starts with
OFXHEADERor<?xml. For PDF statements, use the bank statement to Excel tool instead. - Dates look like numbers. Format the column as Date in Excel (Home, Number format, Short Date).
- You need the data in QuickBooks, not Excel. Press QBO in the same tool, or read our guide on converting OFX to QBO for the Intuit bank ID and import steps.
- You started from a QBO file. The same converter reads it; see QBO to CSV and Excel for the details.
Is it safe to convert bank files online?
It depends on the tool. Many converters upload your file to a server. This one reads the QFX file in your browser, and nothing is sent to our servers, so account numbers and payees stay on your device. Still, treat the finished spreadsheet like any bank statement and don't email it around unprotected.
Moving off Quicken for good? Convert every year you need in one go while you still have access to the downloads, and keep the original QFX files in a folder next to the workbook. You'll want them if a number ever needs checking.
Frequently asked questions
Can Excel open a QFX file directly?
No. Excel has no import filter for QFX, which is Quicken's version of OFX. Convert the file to .xlsx or .csv first, then open that in Excel.
Can I open a QFX file in Google Sheets?
Not directly. Convert the QFX file to CSV or Excel, then use File, Import in Google Sheets. The columns and number formats come across as they are.
What is the difference between QFX, OFX and QBO?
All three are Open Financial Exchange files with the same transaction tags. QFX adds Intuit fields for Quicken, and QBO adds an Intuit bank ID for QuickBooks Web Connect. One converter can read all three.
Why are some transactions missing after I merged files?
They were probably repeats. Each transaction has a bank ID (FITID), and a transaction found in two overlapping downloads is kept only once. Compare the count with your statement if you are unsure.
Can I turn the Excel file back into a QFX or QBO file?
Yes. Save the sheet as CSV and use the CSV to QBO converter, which writes a QuickBooks or Quicken file with the account details you enter.