QIF stands for Quicken Interchange Format. It is a plain-text export used by Quicken, Microsoft Money, GnuCash, Moneydance and many banks. Each line begins with a one-letter code — D for date, T for amount, P for payee — and a caret separates transactions.

Will my dates come out right?

Yes, and this is the part most converters get wrong. QIF never records whether it was written day-first or month-first. We read every date in your file before converting: any day above 12 proves the order for the whole file. The Summary sheet inside the workbook tells you exactly which reading was applied.

Is the output a real Excel file?

Yes — a genuine .xlsx workbook, not a CSV with a changed extension. Dates are date cells and amounts are number cells, so sorting and SUM work immediately. It opens in Excel, Google Sheets, LibreOffice and Numbers.

Does it handle split transactions?

Yes. QIF split lines (S, E and $) are read alongside the main record rather than being dropped.

Yes, within your daily allowance. Signed-in accounts use the same page credits as the bank statement converter, so a QIF costs the same as the equivalent statement.

How long do you keep my file?

Uploads and the workbook we generate are removed from our server and our database automatically. We do not sell or share anything you upload.

QIF to Excel Converter

Open a Quicken QIF file as a proper Excel workbook — dates as real dates, amounts as real numbers, and debits and credits in their own columns.

Drop your file here, or click to choose

Accepts .qif from Quicken, MS Money, GnuCash and most banks - up to 15 MB

QIF is the format Quicken invented in the 1980s, and almost every personal finance package can still export it — Quicken, Microsoft Money, GnuCash, Moneydance, and a good number of banks. What none of them can do is open it in Excel. A QIF file has no columns at all: it is a stack of one-letter codes, one per line, with a caret between records.

This converter reads those codes and writes a real .xlsx workbook. Dates land as dates, so you can sort and filter by month. Amounts land as numbers, so SUM works the moment the file opens. Debits and credits are split into separate columns, which is the shape bookkeeping software expects on import.

It also does the one thing QIF makes genuinely hard. The format never records whether a date is written day-first or month-first, so 03/04/2024 is either 3 April or 4 March depending on which country the file came from. Rather than guess, the converter reads every date in your file first: any day above 12 settles the order for the whole file. The Summary sheet then tells you which reading was used, so the dates in your spreadsheet are never quietly someone else's calendar.

How it works

1
Upload your QIF file
Drop in any .qif export from Quicken, MS Money, GnuCash, Moneydance or your bank. Files up to 15 MB.
2
We read every field code
D, T, P, M, L and N become Date, Amount, Payee, Memo, Category and Cheque number — including split transactions.
3
Download the workbook
A real .xlsx with typed cells, frozen headers, autofilter and a Summary sheet. Opens in Excel, Numbers or Google Sheets.

What it handles

Dates that behave like dates

Written as real Excel dates, not text, so you can sort chronologically and group by month straight away.

Day-first or month-first, decided by your file

QIF does not record its own date format. We scan every date in the file to work out the order, and the Summary sheet states which was used.

Debit and credit columns

As well as the signed amount, debits and credits are split out — the layout accounting packages expect when you import.

Split transactions kept

Records with S, E and $ split lines are read rather than silently dropped.

Quicken's odd date years

Handles the apostrophe years Quicken wrote, like 12/31'99 and 01/15' 4, along with UK, US and European number formats.

Safe to open

A payee beginning with = or + cannot execute as a formula — text stays text, so a spreadsheet from an untrusted export is still safe to open.

How this compares to other QIF converters

Most free QIF tools online hand you a CSV and leave the awkward parts to you. Here is what differs.

How this compares to other QIF converters
Feature	Bank Statement Magic	Typical free online converter	Desktop finance software
Real .xlsx workbook	Yes	No	Yes
Dates written as Excel dates	Yes	No	Yes
Day-first vs month-first detected from your file	Yes	No	No
States which date order it used	Yes	No	No
Separate debit and credit columns	Yes	No	No
Split transactions kept	Yes	No	Yes
Spreadsheet formula injection blocked	Yes	No	No
Works in the browser, nothing to install	Yes	Yes	No
Files deleted automatically	Yes	Varies	Not applicable
Price	Free daily allowance	Free	Paid licence

Frequently asked questions

What is a QIF file?: QIF stands for Quicken Interchange Format. It is a plain-text export used by Quicken, Microsoft Money, GnuCash, Moneydance and many banks. Each line begins with a one-letter code — D for date, T for amount, P for payee — and a caret separates transactions.
Will my dates come out right?: Yes, and this is the part most converters get wrong. QIF never records whether it was written day-first or month-first. We read every date in your file before converting: any day above 12 proves the order for the whole file. The Summary sheet inside the workbook tells you exactly which reading was applied.
Is the output a real Excel file?: Yes — a genuine .xlsx workbook, not a CSV with a changed extension. Dates are date cells and amounts are number cells, so sorting and SUM work immediately. It opens in Excel, Google Sheets, LibreOffice and Numbers.
Does it handle split transactions?: Yes. QIF split lines (S, E and $) are read alongside the main record rather than being dropped.
Is it free?: Yes, within your daily allowance. Signed-in accounts use the same page credits as the bank statement converter, so a QIF costs the same as the equivalent statement.
How long do you keep my file?: Uploads and the workbook we generate are removed from our server and our database automatically. We do not sell or share anything you upload.

Convert your QIF file now

No sign-up needed to try it. Your file and the workbook we build are deleted automatically.