QIF to CSV Converter Online (Quicken to Excel)

Why CSV?

A QIF file is plain text, one field per line: D for the date, T for the amount, P for the payee, L for the category, a caret between transactions. Excel opens it as one long column. Utilly reads each transaction into a row and keeps the Quicken category (split transactions list every split line), so a Quicken history can be sorted, filtered and totalled in a spreadsheet, or moved into another app that takes CSV. Prefer the Excel-framed walkthrough? Use the QIF to Excel converter.

How to convert a QIF file to CSV

Get the QIF. From Quicken for Windows: File → File Export → QIF File, pick the account (or all accounts), set the dates and tick Transactions (steps from Quicken's help). Some banks and older money apps (Microsoft Money, GnuCash, MoneyWiz) also save .qif files.
Upload it above. Each D/T/P/L block becomes one row. Bank, cash and credit card registers are told apart from the file's !Type line.
Check the preview. Spending should show as negative. If the file was written with day-first dates (1/9/2026 for 1 September), choose a day-first date format there.
Download the Clean CSV. It opens straight in Excel, Numbers or Google Sheets. For a workbook, use File → Save As → Excel Workbook (.xlsx) in Excel.

From QIF lines to spreadsheet columns

A split purchase in our sample Quicken export (made-up data):

D9/ 3'26
T-86.43
PPOS PURCHASE OFFICE DEPOT #1123
LOffice Expenses
SOffice Expenses
$-50.00
SPostage
$-36.43
^

is this row in the CSV:

Date,Description,Amount,Balance,Category
2026-09-03,POS PURCHASE OFFICE DEPOT #1123,-86.43,,Split: Office Expenses -50.00; Postage -36.43

QIF line	CSV column
D, including Quicken's two-digit-year style `9/ 3'26`	Date, written 2026-09-03 so every spreadsheet sorts it correctly.
T (or U when T is missing)	Amount as a plain number: sign kept, thousands commas removed.
P, or M when the payee is empty	Description. A check with neither becomes CHECK and its number.
L	Category, exactly as Quicken wrote it: `Utilities:Electric`, `Rent/Studio` (category/class) or `[Savings]` for a transfer.
S and $ split lines	One row for the total; the Category lists each split category with its amount.
N, C, A, E	Not in the CSV (check number, cleared flag, address, split memo).
Balances	None in a QIF, so Balance is blank. The Opening Balance entry is skipped, not counted as income.

The sample file's 31 rows come to 11 Sales, 12 Office Expenses, 2 Payroll, 2 Utilities, 2 Contract Labor, 1 Rent and 1 split, ready for a pivot table by Category.

Which QIF files work

Registers of type Bank, Cash, CCard, Oth A and Oth L. Card registers keep charges negative and payments positive.
Full Quicken exports with many accounts: one tab and one CSV per account, plus a combined CSV whose first column is the Account.
Investment registers (!Type:Invst) are skipped; a file holding nothing else is refused with a message.
Free up to 100 transactions per file; files up to 20,000 transactions.

Common problems

Problem	Fix
Excel shows lines starting with D, T, P and ^	That's the .qif opened directly. Open the converted .csv instead.
"No transactions found in that QIF file"	The export held only lists (categories, payees). Export again with Transactions ticked.
September rows show as January	Day-first dates. Pick `%d/%m/%Y` or `%d/%m/%y` in the preview's date format.
Only one account appears	The others are in tabs above the preview, or download the all-accounts CSV.
Category column is empty for some rows	Those transactions were uncategorized in Quicken. Fill them in the spreadsheet, or recategorize in Quicken and export again.
Amounts are text in Google Sheets	Import with File → Import and leave "Convert text to numbers" on, or check File → Settings → Locale.

Other conversions

Just need to open or view the .QIF? How to open a .QIF file covers Quicken for Windows and Mac, Xero, GnuCash, Excel and opening it without Quicken.
Have a BAI2 file from a US bank? The BAI2 to CSV converter reads previous-day cash-management files (03/16/88 records), puts the decimal point back on amounts in cents and checks each day against the opening and closing ledger.
Have an MT940 (.sta) statement from a European bank? The MT940 to CSV converter reads :61:/:86: bookings and checks each statement against its opening and closing balance.
Have a camt.053 (ISO 20022 XML) statement? The CAMT.053 to CSV converter reads those bank-to-customer XML files and checks each statement against its booked opening and closing balances.
Want the Excel walkthrough instead? The QIF to Excel converter downloads the same Clean CSV with Excel-first steps (open in Excel, Save As .xlsx).
Moving Quicken data into QuickBooks? The QIF to QBO converter writes a .QBO; for Desktop without Web Connect use the QIF to IIF converter.
Importer that takes OFX but not QIF? The QIF to OFX converter writes an OFX statement with transaction IDs.
Have an .ofx, .qfx or .qbo instead? Use OFX / QFX to CSV, QFX to CSV or .QBO to CSV.
Have a QuickBooks Desktop .iif? The IIF to CSV converter keeps SPL accounts as Category the same way.
Going back into Quicken? CSV to QIF writes a QIF from a spreadsheet. Have a QuickBooks Desktop .IIF instead? The IIF to QIF converter.
Only have PDF statements? The bank statement PDF to CSV converter checks every statement against its balances.
Not sure which file you have? See QBO vs IIF vs QIF. To open a QIF or OFX without converting yet, see how to open an OFX or QIF file.

Pricing

Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.

FAQ

Questions

Is it free?

Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.

Can I open a QIF file in Excel?

Not as a table. Excel opens a .qif as text, one field per line (D, T, P, L and ^ separators). Convert it here and open the CSV instead: one row per transaction, ready to sort, filter, pivot or Save As .xlsx.

Do I need the Excel walkthrough?

No. This page downloads the same Clean CSV for spreadsheets, scripts or any importer that takes CSV. If you want Excel-first steps (open in Excel, Save As .xlsx), use the QIF to Excel converter.

Are my Quicken categories kept?

Yes, in a Category column at the end of the CSV, written as Quicken has them, including subcategories (Utilities:Electric), a class after a slash, and transfers in brackets ([Savings]). A split transaction is one row for its total, and the Category lists each split line with its amount, for example Split: Office Expenses -50.00; Postage -36.43.

What columns are in the CSV?

Date (YYYY-MM-DD), Description (the payee, or the memo when there's no payee), Amount (money out negative), Balance and Category. Balance is blank because a QIF file has no balances. Check numbers, cleared marks and memos aren't separate columns.

My QIF has several accounts. Do I get one CSV?

You get both. Each account in the file has its own tab in the preview and its own CSV named after the account, and one CSV of every account with an Account column first. One credit covers the whole file.

Does it convert Quicken investment accounts?

No. Investment registers (!Type:Invst) hold buys, sells and share counts, which don't fit one Amount per row. Export the bank, cash and credit card accounts instead.

Is the Opening Balance line included?

No. Quicken writes an Opening Balance entry at the top of each register; it's the account's starting balance, not a transaction, so it's left out of the rows.

Convert QIF to CSV or Excel

Why CSV?

How to convert a QIF file to CSV

From QIF lines to spreadsheet columns

Which QIF files work

Common problems

Other conversions

Pricing

Questions

Other converters

Convert CSV to QBO for QuickBooks

Convert Excel (.xlsx) to QBO for QuickBooks

Convert CSV to IIF for QuickBooks Desktop

Convert Excel to IIF for QuickBooks Desktop

Convert OFX or QFX to IIF

Convert a .QBO file to IIF

More bookkeeping tools

Receipts & invoices to CSV

Bank reconciliation checker

QuickBooks reconciliation discrepancy finder