ConvertCSVtoQBO

Convert CSV to QIF

Turn a bank or credit card CSV into a QIF file you can import into Quicken for Mac, GnuCash, Banktivity, Moneydance and other personal finance apps.

  • Free, no sign-up
  • Your file never leaves your computer
  • US or international dates
Converted in your browser. Nothing is uploaded. No file handy?

How to import the QIF file

  • Quicken for MacGo to File, Import, and choose the QIF option. Pick the account to import into.
  • GnuCashGo to File, Import, Import QIF, and follow the steps to match accounts.
  • Banktivity, Moneydance, MoneyWiz and othersLook for Import in the File menu and choose QIF.
  • Quicken for WindowsOnly accepts QIF for some account types, such as cash and asset accounts. For checking, savings and credit cards, use the CSV to QFX converter instead.

What goes into the QIF file

Each transaction gets its date, amount, payee, memo and check number. Bank accounts are written as a bank register and credit cards as a credit card register, so the app puts them in the right kind of account.

QIF files don't record which date format they use, so pick the one your app expects: month first for US apps, day first for most apps set up in the UK, Europe, Australia and elsewhere.

Related converters

  • CSV to QFX

    Bank CSV for Quicken for Windows and Mac.

  • CSV to OFX

    Bank CSV for Xero, GnuCash and YNAB.

Questions

What is a QIF file?

QIF, or Quicken Interchange Format, is a plain-text format for transactions that many personal finance apps can import.

Can I import QIF into Quicken for Windows?

Only into some account types. For checking, savings and credit cards, use the CSV to QFX converter.

Which date format should I choose?

Month first if your app uses US dates, day first if it uses the format common in the UK, Europe and Australia. If imported dates look wrong, switch it and download again.

Does it work with credit card CSVs?

Yes. Choose Credit card as the account type and the file is written as a credit card register.

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.