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.
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.
QIF to CSV at a glance
| Input | A .qif file with !Type:Bank, CCard, Cash, Oth A, Oth L or Invst sections; several accounts in one file are fine |
|---|---|
| Columns | Date, Amount, Payee, Memo, Category, plus Account, Type, Number, Cleared, Address, Splits and investment fields when the file has them |
| Dates | Written 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 |
| Amounts | Copied exactly; only thousands separators are removed, and a decimal comma becomes a point |
| Splits | One Splits column per transaction, or one row per split line with its category, memo and amount |
| Not converted | Category, 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
- Export the account from Quicken or your finance app as a .qif file
- Drop the file here or paste its contents
- Check the date order and, for split transactions, choose one column or one row per split
- 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