QIF to Excel Converter Online (CSV for Excel)

Why Excel?

Excel won't open a QIF as a spreadsheet. Quicken's export (or a bank's QIF download) is one letter-coded field per line, so you get a single column of D, T, P and L codes instead of rows. Utilly reads each transaction and writes a CSV laid out for Excel, with the Quicken category kept (split lines listed), the same columns as our QIF to CSV download.

How to convert QIF to Excel

Export or download the QIF. 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 also save .qif files.
Upload it above. We read each D/T/P/L block into a row and tell bank, cash and credit card registers apart from the file's !Type line.
Check the preview. Money out should be negative. If the file used day-first dates (1/9/2026 for 1 September), pick a day-first date format there.
Download the CSV and open it in Excel (File → Open, or double-click). Dates and amounts come through as real dates and numbers. Use File → Save As → Excel Workbook if you want a .xlsx.

What carries over from the QIF

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
^

becomes this row in the CSV (opened in Excel):

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

In the QIF	In the Excel CSV
D, including Quicken's `9/ 3'26` style	Date column, written YYYY-MM-DD so Excel sorts it correctly.
T (or U when T is missing)	Amount column, signed as in the file, two decimals: negative for money out.
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: subcategory, class after a slash, or `[Savings]` for a transfer.
S and $ split lines	One row for the total; Category lists each split category with its amount.
N, C, A, E	Not in the CSV (check number, cleared flag, address, split memo).
Balances / Opening Balance	None in a QIF, so Balance is blank. The Opening Balance entry is skipped.

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 in Excel.

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 opens the .qif as one long column of D, T, P and ^	That's the raw QIF. Open the converted .csv instead (Data → From Text/CSV, delimiter comma).
Dates look like text, or day and month are swapped	Import with Data → From Text/CSV and set the Date column's data type. Our dates are year-first (YYYY-MM-DD).
"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 in the QIF. Pick `%d/%m/%Y` or `%d/%m/%y` in the preview.
Category column is empty for some rows	Those transactions were uncategorized in Quicken. Fill them in Excel, or recategorize and export again.
Balance column is empty	Expected: a QIF has no running balances. Add a formula in Excel, or reconcile against your statement.

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.
Just need a Clean CSV (scripts, Wave, Zoho, FreshBooks): the QIF to CSV converter downloads the same file with CSV-first steps.
Moving Quicken data into QuickBooks? The QIF to QBO converter writes a .QBO; for Desktop without Web Connect use the QIF to IIF converter.
Need an OFX statement instead of a spreadsheet? The QIF to OFX converter.
Have an .ofx or .qfx instead? The OFX / QFX to Excel converter.
Have a QuickBooks Web Connect .qbo? The .QBO to Excel converter.
Have a QuickBooks Desktop .iif? The IIF to CSV converter or the IIF to Excel converter keeps SPL accounts as Category.
Going back into Quicken? Excel to QIF writes a QIF from an .xlsx, and CSV to QIF from a .csv. Have a QuickBooks Desktop .IIF instead? The IIF to QIF converter.
Only have PDF statements? The bank statement PDF to Excel converter checks every statement against its balances.
Not sure which file you have? See QBO vs IIF vs QIF. To open a QIF 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.

Do I get an .xlsx file?

You get a CSV laid out for Excel: Date, Description, Amount, Balance and Category, one transaction per row. Excel opens it directly with real dates and numbers; use File → Save As → Excel Workbook to keep it as .xlsx.

Are my Quicken categories kept?

Yes. The Category column keeps Quicken's L line as written (Utilities:Electric, Rent/Studio, [Savings] transfers). A split is one row for the total, and Category lists every S/$ line with its amount.

Can I convert a credit card QIF to Excel?

Yes. Card registers (!Type:CCard) are detected. Charges stay negative and payments positive. You can also choose Credit card as the account type in the preview.

Will the Balance column be filled in?

No. A QIF has no running balances, so Balance is blank. Reconcile against your statement, or add a running-balance formula once the sheet is open.

My QIF has several accounts. Will that work?

Yes. Each account gets its own tab in the preview and its own CSV, named after the account. You can also download every account in one CSV with an Account column. One credit covers the whole file.

Is the Opening Balance line included?

No. Quicken's Opening Balance entry is the account's starting balance, not a transaction, so it is left out of the rows.

Convert QIF to Excel

Why Excel?

How to convert QIF to Excel

What carries over from the QIF

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