Convert QIF to CSV

Open a QIF file as a spreadsheet. Each transaction becomes a row with its date, payee, memo, category, check number and amount.

  • Free, no sign-up
  • Your file never leaves your computer
  • Keeps categories
Converted in your browser. Nothing is uploaded. No file handy?

Reading QIF files

QIF files store each transaction as a short block of lines: a date, an amount, a payee, a memo and a category. They're hard to read as text and won't open as a table in Excel. Converting to CSV gives you one tidy row per transaction.

Files exported from Quicken often hold several accounts. You can pick which account to convert, and split transactions come through as one row with the full amount.

Questions

Where do QIF files come from?

Quicken, Microsoft Money and many banks can export QIF. Some older banking sites still offer it as a download option.

Are categories included?

Yes. When the file has categories, the CSV gets a Category column.

My dates look wrong. What should I do?

Set "Date format in your file" to day first or month first. QIF files don't say which they use.

Can I convert investment accounts?

Not yet. Bank, cash and credit card accounts are supported; investment accounts are skipped.

Is my data safe?

Your file is read and converted inside your own browser. It is never uploaded to a server, so nobody else can see your transactions.