Convert a QFX File to CSV
QFX is a variant of OFX that some banks offer under a label aimed at desktop finance programs. If you no longer use that kind of program, or simply want the raw list of transactions, a CSV is the easiest format to keep, share or archive.
Your file is never uploaded. The OFX, QFX and QBO converter runs in your browser and makes no network requests while it works. Always review the rows before you use them.
Steps
- Download the QFX export for the period you need from your online banking.
- Open the OFX to CSV tool. QFX files are accepted as they are, with no renaming.
- Check that the account and the date range in the summary match what you requested.
- Leave the format on CSV and press Download.
- Keep the original QFX alongside the CSV in case you need to import it somewhere later.
Good to know
QFX versus OFX
Apart from a few extra identification tags near the top, a QFX file follows the same structure as OFX. The tool ignores those extra tags and reads the transaction list the same way.
Text encoding
The CSV is written as UTF-8, so names with accents or symbols in the payee field survive the conversion. If an older program shows odd characters, choose UTF-8 when importing the CSV.
Keeping the FITID
The FITID column is the identifier your bank attached to each transaction. Keep it if you plan to merge several exports, because matching FITIDs reveal rows that appear twice.
Questions
Do I need the program the file was meant for?
No. The conversion only reads the text inside the file, so no finance software is needed.
Will a QFX from a card account work?
Yes. Credit card statement downloads are supported as well as checking and savings accounts.
What about rows with a missing date?
Rows without a date or amount are skipped, and the status line tells you how many were left out.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.