knackbench.

Convert QIF to CSV or Excel

Open a QIF file as a spreadsheet, with dates, payees, categories and amounts in clean columns. Combine several files into one. Everything happens on this device.

  • Your file stays on this device
  • Works with Wi-Fi off. Check it yourself
  • Free, with no sign-up

  1. 1 Choose your QIF file

    Drop bank files here, or choose files

    QIF files from Quicken, Microsoft Money, GnuCash or your bank. Add several to combine them.

    Your files are read inside this browser tab. Nothing is uploaded.

When a QIF to CSV conversion helps

  • Moving to new software. Quicken, Microsoft Money and many older programs export QIF, but plenty of newer apps only import CSV.
  • Opening an old archive. If you kept years of QIF exports, a spreadsheet makes them readable without the original program.
  • Checking before an import. See exactly what a QIF file holds, and total it, before it goes into your books.
  • Sharing with an accountant who works in Excel or Google Sheets.

What the converter reads

  • Bank, credit card, cash, asset and liability registers.
  • Files with several accounts. Each account is listed in step 2, and you can add an Account column to keep them apart.
  • Dates in the styles QIF files use, including Quicken's 1/5'26 for years after 1999, and both month-first and day-first files. The order is worked out from the dates themselves.
  • Payee, memo, check number and category.
  • Split transactions, which come out as one row with the full amount. The individual split lines are not listed.

Investment registers (!Type:Invst) are skipped, because their buys, sells and share prices do not fit a simple list of payments.

How to convert QIF to CSV

  1. Export a QIF file from your software, or find the one you downloaded from your bank.
  2. Drop it into step 1. Add more files at once to combine them.
  3. In step 2, choose the date style, one or two amount columns, and the extra columns you want, such as Category.
  4. Check the totals in step 3, then download an Excel file or a CSV.

Combining files without duplicates

QIF transactions have no IDs, so the tool spots repeats another way. When two files share a transaction with the same account, date, amount and payee, it is listed once. Genuinely repeated purchases inside one file are all kept. If your files overlap, glance at the boundary dates in the preview.

Questions

Is my file uploaded?

No. The QIF file is read in this browser tab and the spreadsheet is built on your device.

Does it work with Microsoft Money QIF exports?

It reads any QIF file that follows the usual layout, whichever program wrote it. If a file will not open, check that it starts with a line such as !Type:Bank or !Account.

What goes in the Category column?

Whatever the file's category line says, such as Utilities or Auto:Fuel. Transfers usually appear as an account name in square brackets, such as [Savings]. The column only appears when the file has categories.

Can I go the other way?

Yes. The CSV to QIF converter turns a spreadsheet into a QIF file.

Does it open QFX, OFX and QBO files too?

Yes. The same tool reads them, or use the QFX, OFX and QBO to CSV converter.

Check for yourself that nothing is uploaded

  1. Open this page, then turn off Wi-Fi or switch on airplane mode.
  2. Drop your file into the tool and convert it. It still works, because the conversion runs in your browser, not on a server.
  3. For a closer look, open your browser's developer tools and watch the Network tab while you choose a file. No request carries your file anywhere.

The tools work in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.

Last reviewed November 11, 2026. Found a bank export this tool reads wrongly? Tell us about the layout and we will look at it.

More finance tools