What a QFX file holds, what actually opens one, and how to get the same transactions into a workbook. If you still have the original PDF statement, upload it here and export a formatted .xlsx ready for formulas and pivot tables.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
QFX is Quicken Web Connect data wrapped in OFX tags, built for finance software rather than for Excel, which is why opening one shows markup instead of rows. Two routes get you to a workbook: import the QFX into a program that reads it, such as Quicken, and export from there, or convert the PDF statement the download was built from. The uploader on this page reads PDF and image statements, not QFX or OFX files, and exports Excel, CSV and OFX from them.
Excel expects rows and columns. A QFX is Quicken Web Connect data wrapped in OFX tags, so opening it directly shows markup instead of transactions.
Open a QFX in Excel and the first column fills with tags such as STMTTRN and DTPOSTED rather than dated transactions.
Quicken reads QFX fine, but budgets, P&L summaries, and tax schedules all get built in Excel.
The text import wizard has no delimiter to work with, so it splits the file into nonsense instead of transactions.
Grouping by month or charting spend only works if the date stamps become genuine Excel dates, not text.
If a conversion flips debits and credits, every total and running balance in the sheet is quietly wrong.
Retyping a year of transactions from a Quicken file into a workbook is a lost afternoon and a source of errors.
Converting from the statement rather than the QFX gives you the same transactions in a formatted workbook, with real Excel dates, signed amounts, and the balance carried through.
Produces a real Excel file with a header row and clean columns, ready to sort and total the moment it opens.
The uploader accepts PDF and image statements, including scanned copies. It does not read QFX or OFX files, so start from the statement the Quicken download was built from.
Turns OFX date stamps into genuine Excel dates so sorting, filtering, and month grouping work without cleanup.
Keeps debits negative and credits positive so SUM, SUMIF, and your reconciliation come out correct.
Consistent columns across every row mean you can build a pivot table without reshaping anything first.
256-bit encryption in transit and you can delete your uploaded file at any time.
Start from the PDF statement the QFX download covers. No install and no macros.
Drop in the PDF or scanned statement from the same account and period the QFX covers. The uploader reads PDF and image files, not QFX or OFX.
Tip: Up to 50 statements can go in at once.
Every transaction is parsed into a formatted .xlsx workbook with proper date, description, amount, and balance columns.
Tip: Need a plain comma file? Pick CSV output instead.
Download the workbook, open it in Excel, and start categorizing, pivoting, and totaling.
Tip: Tie the balance column back to your statement before you report from it.
Quicken users and their accountants who need the transactions in a workbook they can calculate in.
Turn a client QFX download into a formatted workbook for review and tax schedules without opening Quicken.
Convert QFX to Excel to categorize, build journal entries, and reconcile against the ledger in one sheet.
Pivot Quicken transactions by category and month to see where the money actually went.
Build expense reports and P&L summaries from Quicken data your accountant can work with directly.
QFX is what Quicken Web Connect downloads look like: OFX data with an Intuit identifier attached. Quicken imports it happily, and nothing else does, which is why the reporting work stalls. Getting to a workbook takes one of two routes. You can import the QFX into Quicken and export a register report, then reformat it in Excel. Or you can convert the PDF statement covering the same account and period, which is the original record the QFX was generated from and usually the quicker path. The uploader above takes that second route: it reads PDF and image statements, not QFX or OFX files. If you want a plain comma file rather than a formatted workbook, the QFX to CSV converter covers the same ground, and for an unbranded OFX file the OFX to Excel converter is the right page.
A conversion is only useful if the sheet reconciles to the statement. That means real Excel dates rather than text, amounts signed so debits reduce the balance, a description built from both the payee and memo fields, and the running balance carried through where the QFX provides it. The table below shows the mapping.
| QFX field | Excel column |
|---|---|
| DTPOSTED date stamp | A real Excel date, sortable and groupable |
| NAME and MEMO | A single description column |
| TRNAMT amount | A signed amount, debits negative |
| TRNTYPE | Transaction type, where the file provides it |
| Ledger balance | A running balance column for reconciliation |
Choose the .xlsx workbook when a person is going to read and work in the file, because the header row, column widths, and date formatting are already set. Choose CSV when a program is going to read it, since almost every accounting tool, database, and import mapper accepts a comma file. The transactions are identical either way. If the source is still a PDF statement rather than a QFX, the PDF bank statement to Excel converter skips a step.
Two routes work. Import the QFX into a program that reads it, such as Quicken, then export a register report and open that in Excel. Or convert the PDF statement the QFX download covers, which is what the uploader above does. It reads PDF and image statements, not QFX files, and writes a formatted .xlsx workbook.
A QFX holds tagged OFX data built for finance software, so Excel displays the raw markup instead of rows. Converting it to a workbook first unpacks those tags into ordinary columns, which is what makes formulas and pivot tables possible.
No. Excel has no importer for the QFX format and the text import wizard has no delimiter to work with, so it produces nonsense. The file has to be converted to .xlsx or CSV first, after which it opens like any other spreadsheet.
QFX is Intuit's branded variant of OFX, used by Quicken Web Connect, and carries an Intuit identifier that plain OFX lacks. The underlying structure is the same, so a converter that handles OFX generally handles QFX as well.
Yes, when the QFX carries ledger balance data the workbook includes a running balance column. That lets you check the ending figure against your statement, which turns the sheet into something you can reconcile rather than just read.
Uploads here are protected by 256-bit encryption in transit and you can delete a file at any time. Before sending financial data to any online tool, confirm it encrypts uploads and lets you control deletion, and review its privacy and retention policy.
What is inside a QFX file, field by field.
Prefer a plain comma file to a workbook.
Same job for a plain OFX file.
Get a PDF statement into Quicken the way that works.
Import any statement into Quicken.
Turn an OFX or QFX file into a readable PDF report.
Get started converting bank statements to OFX.
USD
per month
per month
$294 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion with bulk upload, custom templates and reports.
USD
per month
per month
$894 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
