CSV and Excel to QIF converter

Create a QIF (Quicken Interchange Format) file from a bank or credit card spreadsheet. QIF is an older format, but many apps still accept it, and unlike OFX it can include categories.

Choose your files

or drop .csv or .xlsx files here

Up to 20 files at a time. Your files stay on this device.

Or paste CSV text
View history

Your files stay on this device: the conversion runs in your browser and nothing is uploaded. Learn how your files are handled

How to convert CSV to QIF

  1. Choose your CSV or Excel file and check the columns: a date, an amount (or money in and money out columns), and optionally payee, memo, category and check number.
  2. Check the preview. Money out should be negative. Tick “Reverse the signs” if it isn’t.
  3. Pick the account type, and the date order used by the program that will read the file.
  4. Download the .qif file and import it.

Apps that import QIF

  • GnuCash (File → Import → Import QIF), Moneydance, Banktivity, KMyMoney, HomeBank, Microsoft Money Plus Sunset, MYOB and many smaller budgeting apps.
  • Quicken: File → File Import → QIF File. Some Quicken versions restrict QIF imports into checking, savings and credit card accounts. If yours refuses, use the QFX option of the CSV to OFX converter.
  • Not QuickBooks Online, which needs OFX, QFX, QBO or CSV. For QuickBooks and Xero, use the OFX converter instead.

Getting the details right

Date order

A QIF file has no fixed date format. The program reading it uses your computer’s regional settings. Choose US software for month/day/year (US versions of Quicken and Money), or UK, Europe, Australia, India for day/month/year. If dates import wrongly, convert again with the other setting.

Categories

A category column becomes each transaction’s category in the QIF file (the line starting with L). Use a colon for sub-categories, as Quicken does: Food:Groceries. Categories that don’t exist yet are usually created during import, or listed for you to match.

Account types

Choose Credit card for card statements, so the program handles charges and payments correctly. Bank account covers checking and savings accounts. The optional account name adds an !Account heading to the file, which some programs use to pick the right account automatically.

Accents and other characters

Quicken and older programs expect an older text format called Windows-1252, which is the default here. Characters it can’t hold lose their accents where possible. GnuCash, Moneydance and newer apps read UTF-8, the modern standard, which keeps every character.

Frequently asked questions

Should I use QIF or OFX?

Use OFX (or QFX or QBO) when your app accepts it, because it includes transaction IDs that prevent duplicates. Use QIF when you want categories to come across, or when the app only imports QIF.

Why are my dates wrong after importing?

The program read the day and month the wrong way round. Convert again with the other “Write dates for” option, delete the wrong import, and import the new file.

Can I import split transactions?

Not from a spreadsheet: each row becomes one transaction with one category. You can split transactions in your finance app after importing.

Can Quicken import QIF into my checking account?

It depends on your Quicken version and the account type, because Intuit, and later Quicken Inc., changed this over the years. If Quicken won’t accept the QIF, make a QFX file with the CSV to OFX converter instead.

What is the difference between QIF and CSV?

A CSV is a plain table with whatever columns your bank chose. A QIF file is a text format made for finance programs: each transaction is a group of short lines, one per detail (D for the date, T for the amount, P for the payee, L for the category), ending with a ^ line. Because the fields are fixed, finance apps import QIF without a column-matching step, and unlike OFX it can carry categories.

Which programs open QIF files?

Finance programs import QIF files rather than open them: GnuCash, Moneydance, Banktivity, KMyMoney, HomeBank, Microsoft Money and Quicken (with limits that depend on the version and account type). Excel and text editors show only the coded lines. To read a QIF file as a table, use the QIF to CSV converter.

Why isn’t my CSV importing correctly?

Most problems come from three things: dates read with the day and month swapped, amounts with the wrong sign (purchases showing as deposits), and columns the app doesn’t recognise. Converting to QIF here lets you check each one in the preview before you import: set how dates are written, tick “Reverse the signs” if needed, and match the columns once. Rows that can’t be read are listed, so none are dropped without you knowing.

Can Moneydance import Quicken data?

Yes. Moneydance imports QIF files, the format Quicken exports, as well as OFX and QFX files. Export your data from Quicken as a QIF file and import it in Moneydance with File → Import. If your transactions are in a spreadsheet instead, convert them to QIF or OFX here first.

Is my bank data uploaded?

No. The conversion runs in your browser, and the QIF file is created on your device.