QFX to CSV Converter
Open a QFX file from your bank and save its transactions as CSV or Excel, without Quicken.
Drop your bank file here or choose a file
QFX, QBO or OFX · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert QFX to CSV
- Find the QFX file QFX files come from your bank's website ("Download to Quicken" or "Web Connect"). They are usually in your Downloads folder.
- Drop it into the converter Choose the file or drag it onto the box above. QBO and OFX files work too.
- Check the transactions Every transaction is shown with its date, description and amount. If the file holds more than one account, pick the account.
- Choose CSV or Excel CSV opens in any spreadsheet app. Excel gives you real date and number cells. You can choose one amount column or separate money out and money in columns.
- Download and open it Click Download CSV file (or Excel) and open it in Excel, Google Sheets or Numbers.
How to open the file in a spreadsheet
Microsoft Excel
- Open the file Double-click the downloaded file, or choose File › Open in Excel.
- Check the columns Dates are in the first column and amounts use a minus sign for money out. The Excel download already has date and number cells.
Google Sheets
- Import the file In a new sheet, choose File › Import › Upload and pick the file.
- Choose the import settings Keep the comma separator and let Sheets convert dates and numbers.
Why convert QFX to CSV
A QFX file is made for Quicken: it carries your transactions plus account details in tagged text that is hard to read. Converting QFX to CSV or Excel lets you check transactions, share them with a bookkeeper, total them by category, or move them to another app.
What you get in the CSV
Each row is one transaction with the columns Date, Description, Amount (or Money out and Money in), Memo and Check number. Amounts use a dot for cents and a minus sign for money out, without currency symbols, so any spreadsheet reads them as numbers. Choose Excel instead to get real date and number cells.
What stays behind
A QFX file also carries the bank’s ID, your account number and type, and the ending balance. A CSV keeps only the transactions. If you need those details in the new file, convert to QBO (QuickBooks) or OFX instead; the converter fills in the account type and balance from the QFX file, and you can choose the bank for QuickBooks.
Supported banks and file layouts
QBO, QFX, OFX and QIF files from any bank
The reader handles both forms of OFX (the older SGML form used by QBO and QFX files, and the newer XML form), bank and credit card statements, and files that hold more than one account. QIF files from Quicken and other apps are read too, including Quicken's old date styles.
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Common problems and fixes
- The file won't open
- Check that it is a QFX, QBO or OFX file from a bank. Quicken's own data files (.QDF) and transfer files (.QXF) are a different format and can't be read here. If the file is from your bank, open it in the QBO file checker, which also reads QFX files and shows what is wrong.
- The file has more than one account
- The converter lists every account in the file. Choose one, download it, then choose the next.
- Accented letters look wrong in Excel
- Use the Excel download, or open the CSV with Excel's Data › From Text/CSV and choose UTF-8. The converter marks CSV files that contain accents so Excel reads them correctly.
- Some transactions are missing
- A QFX file only holds what your bank put in it. Banks often limit downloads to a few months; download a longer date range from your bank if you need more.
QFX vs CSV
| QFX | CSV | |
|---|---|---|
| Made for | Quicken (Web Connect import) | Any spreadsheet or app |
| Opens in Excel | No | Yes |
| Holds account details | Yes: account type, account number and bank ID | No, unless you add columns |
| Transaction IDs | Yes, one per transaction | Only if you add a column |
| Easy to read and edit | No: tagged text | Yes: rows and columns |
Frequently asked questions
How do I convert a QFX file to CSV?
Drop the QFX file into the converter above, check the transactions, choose CSV and click Download. The file is made in your browser.
Can I convert QFX to Excel?
Yes. Choose Excel before you download. You get an .xlsx file with real dates and numbers, ready to sort and total.
Can I open a QFX file without Quicken?
Yes. The converter shows every transaction in the file, and you can save them as CSV or Excel. You don't need Quicken.
Does it work with QBO and OFX files?
Yes. QBO and QFX files are both based on OFX, so the same converter reads all three, from any bank.
Can I open a QFX file in Excel?
Not as a table: Excel shows the tagged text. Convert it here and open the CSV or Excel file instead.
Is my file uploaded?
No. Your file is read by your own browser and never leaves your computer.
Can I turn a CSV back into QFX?
Yes, with the CSV to QFX converter.
Related tools
Last updated · EmproIT