Convert QFX and OFX files to CSV or Excel

Can Excel open a QFX file?

Not usefully. A QFX file is your bank’s transactions written as tagged text for money software, not a table, so Excel shows tags or one long column. Convert it first: drop it above and you get one row per transaction.

If you have Quicken, you don’t need a converter: import the QFX into Quicken and export from there. This tool is for everyone else, and for files from a bank or broker whose only download is QFX or OFX.

What’s in the spreadsheet

Columns appear only when your file has something to put in them. In Excel, the first sheet sums up each account and every account gets its own sheet; a CSV has an Account column instead.

How the balance is checked

QFX and OFX files carry the account’s balance on the day you downloaded them, but nothing uses it. This tool does:

• A balance on every row. Starting from the closing balance in the file, it works back through each transaction, so you can compare any row with your statement. The opening balance it ends up at is shown too.
• Months that join up. Drop in several files from the same account and it checks that each file’s balance, plus the transactions after it, equals the next file’s balance. If they don’t, it tells you by how much, which usually means transactions are missing.
• Repeats left out. Files that overlap by a few days don’t double up: a transaction with the same bank ID is kept once, and you’re told how many.

One honest limit: these files don’t carry a balance for each row, the way a printed statement does. So with a single file, the balance column is worked out from the closing balance rather than checked against the bank’s own figure on each line. Compare the opening balance with your statement to be sure nothing is missing.

Will it work with my file?

• QFX, OFX and QBO. They’re the same format: QFX is the version Quicken uses, and a QBO is the version QuickBooks Desktop uses (a bank download file, not your QuickBooks company data). Old (OFX 1) and new (OFX 2) files both work.
• QIF from Quicken, Microsoft Money, Banktivity, GnuCash and others. Dates written like 1/5’24 work, day-first or month-first order is worked out from the whole file, split transactions can come out as one row or one row per split, and transfers between accounts are marked.
• Credit cards. Purchases come out negative and payments positive, the same as a bank account. If your card’s file is the other way round, tick “Swap money in and out on credit cards”.
• Several accounts in one file, like a download of everything at one bank: each account is kept apart.
• Investment accounts: money moved in and out of the account is read. Buys, sells and dividends are counted and listed as not included.
• Only have PDF statements? This tool reads bank download files. For PDFs, use the bank statement converter, which checks every row against the balance printed on the statement.

Open it in Excel or Google Sheets

Not sure what you downloaded? See what a QFX file is and how to open it, including the difference between viewing transactions and importing them into Quicken.

• Excel file: open it. Dates are real dates and amounts are numbers, so sorting, filters and SUM work straight away.
• CSV in Excel: double-click it, or for full control use Data → From Text/CSV and choose UTF-8, which keeps names with accents readable.
• Google Sheets: File → Import → Upload, then pick either file.

Is it safe to use?

The converter is a script that runs in your browser. Your file is opened from your computer and turned into a spreadsheet there. It isn’t uploaded, there’s no account, and nobody here can see it.

You can check this yourself: once this page has loaded, turn off your Wi-Fi and convert a file. It still works, because nothing needs to be sent anywhere. Or open your browser’s developer tools, go to the Network tab, and watch while you convert.

When the numbers look wrong

• Fewer transactions than you expected. Banks often default to the last 30 or 90 days. Look at the dates shown for each account, then download a wider range from your bank.
• The files don’t join up. A month is missing between them, or one file was cut short. Download the missing dates and add that file.
• Money in and out the wrong way round on a credit card: tick the swap option.
• Dates look shuffled in a QIF: set QIF dates to month first or day first under More options.
• Payee in the memo column: some banks put the detail there. Both columns are kept, so nothing is lost.