Convert QIF to CSV
Open a Quicken Interchange (.qif) file as a plain CSV, or as Excel, in your browser.
- Runs in your browser. The file is never uploaded.
- Free for 10 files a day. No account.
- Also writes Excel, QBO, QFX, OFX, QIF, IIF, PDF.
- Nothing is uploaded: the file stays on your computer
- Free for 10 files a day, no account
- Every output format from the same screen
You've used today's 10 free conversions
Plans from $19 a month include unlimited file conversions and 40 PDF statements. See plans, or come back tomorrow.
Click a date, description or amount to fix it before you download.
| Date | Description | Amount | Balance | Row actions |
|---|
Why QIF to CSV
QIF is readable by eye but useless in a spreadsheet: each field sits on its own line with a letter prefix. This converter turns every record into one row with the fields in columns, so you can sort, filter and sum.
Using the CSV
- Columns: Date, Description, Amount, Debit, Credit, Check number, Memo.
- Dates are ISO. Amounts are signed, with Debit and Credit split out as well.
- Choose Excel under Other formats for a workbook with real dates and numbers.
- QBO, OFX and QFX are available from the same screen for accounting software.
How the conversion works
1. Read
Each record's D, T, P, M and N lines become date, amount, payee, memo and check number. Quicken's date shorthand and credit card files are understood.
2. Check
Rows without a readable date and amount are counted and reported, never silently dropped. Totals in and out and the period are shown so you can compare them with the source before importing.
3. Write
UTF-8 CSV with ISO dates, a signed amount column plus debit and credit columns, and quoted fields.
Starting from a PDF statement? The statement converter reads it and checks every row against the printed balance.
Related converters
Questions
Are categories (L lines) kept?
Not yet. Date, amount, payee, memo and check number are converted. Category support is on the list.
Split transactions?
The total amount is used; split lines are ignored.
Investment QIF files?
Only bank, cash and credit card types are converted.