QIF to CSV Converter

Turn a Quicken QIF file into a CSV of transactions

Free, no signup. Runs entirely in your browser — files stay on this device.

Your fileQIF

Drop your file here or browse from your device

Accepts QIF. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.

Read in this browser tab · 0 bytes uploaded

QIF to CSV at a glance

InputA .qif file with !Type:Bank, CCard, Cash, Oth A, Oth L or Invst sections; several accounts in one file are fine
ColumnsDate, Amount, Payee, Memo, Category, plus Account, Type, Number, Cleared, Address, Splits and investment fields when the file has them
DatesWritten as YYYY-MM-DD from month-first or day-first QIF dates, or kept exactly as written. Day-first is detected when a day above 12 proves it
AmountsCopied exactly; only thousands separators are removed, and a decimal comma becomes a point
SplitsOne Splits column per transaction, or one row per split line with its category, memo and amount
Not convertedCategory, class and memorized-payee lists, which are not transactions

Convert a QIF (Quicken Interchange Format) file into a CSV you can open in Excel, Google Sheets or any spreadsheet. Each transaction becomes a row with its date, amount, payee, memo and category.

The converter reads bank, credit card, cash, asset, liability and investment sections, names transactions after the account they belong to when the file says, and keeps split transactions either summarised in one column or as one row per split. Dates such as 1/15'24 become 2024-01-15.

Everything runs in your browser. The QIF file is not uploaded.

How to Convert QIF to CSV

  1. Export the account from Quicken or your finance app as a .qif file
  2. Drop the file here or paste its contents
  3. Check the date order and, for split transactions, choose one column or one row per split
  4. Download the CSV and open it in Excel or Google Sheets

Features

  • Reads Bank, CCard, Cash, Oth A, Oth L and Invst sections
  • Names each transaction after its account when the file has !Account blocks
  • Writes dates as YYYY-MM-DD, including Quicken years like 1/15'24
  • Keeps split transactions, as one column or one row per split
  • Only adds columns the file actually uses
  • Comma, semicolon or tab output and a choice of encodings
  • Runs entirely in your browser, no upload or signup

Use Cases

  • Open old Quicken or Microsoft Money exports in Excel
  • Move transaction history from a QIF-only app into a budgeting spreadsheet
  • Check a QIF file before importing it into GnuCash, Moneydance or Banktivity
  • Hand an accountant a spreadsheet instead of a QIF file

Frequently Asked Questions

How do I convert a QIF file to CSV?

Drop the .qif file on this page. The transactions appear as a table straight away; check the date order, then click Download to save the CSV.

What does 1/15'24 mean in a QIF file?

Quicken writes years from 2000 on with an apostrophe, so 1/15'24 is 15 January 2024, while 1/15/98 is 15 January 1998. The converter reads both and writes 2024-01-15 and 1998-01-15.

How do I know whether my dates are month-first or day-first?

If any date in the file has a first number above 12, the file is day-first and the converter picks that for you. If no date proves it, the converter reads month-first, the way US Quicken writes dates, and says so; switch to "from D/M" if your file came from a UK, European or Australian app.

What happens to split transactions?

By default each transaction stays one row and its splits are listed in a Splits column, such as "Food -30.00; Home -20.00 (Bulbs)". Turn on Row per split to get one row per split line with its own category, memo and amount.

Is my QIF file uploaded?

No. The file is read and converted in your browser. Nothing is sent to a server.

Need to convert the other way? Try our CSV to QIF Converter