QIF to Excel converter
Turn a .qif file into a real Excel workbook — numeric amounts, readable dates, ready for formulas and pivot tables. Free, no upload.
Drop your .qif file here
QIFExcel or click to choose a file
100% private · never uploadedQuicken Interchange Format — the plain-text transaction format Quicken, GnuCash, Moneydance and MoneyMoney all import.
An Excel workbook with real numeric amounts, ready for formulas and pivot tables.
Why a real workbook beats renaming the file
The usual advice for opening a QIF in Excel is to rename it to .csv and hope. It does not work: QIF is one field per line, so Excel reads it as a single column of D, T, P and M lines with no rows and no columns. Even when a converter does produce a CSV, Excel imports the amount column as text if a currency symbol or a thousands separator survives — and then SUM returns zero.
This converter writes a genuine .xlsx. Amounts are stored as numbers, dates as a clean MM/DD/YYYY string, and the columns are pre-sized so nothing arrives as ####.
What you get
One sheet, four columns, one row per transaction:
- Date — normalised to a four-digit year, including files that use the Quicken 12/31’24 apostrophe style
- Description — the QIF payee and memo joined, so neither is lost
- Amount — a signed number: negative for money out, positive for money in
- Balance — populated only when the source file carries one, which QIF usually does not
Ready for the analysis you actually wanted
Because the amounts are numeric, a pivot table over Description and Amount works straight away, SUMIF over a date range works, and conditional formatting on negative values works. That is the whole reason to convert to Excel rather than CSV: the file arrives usable instead of arriving as a cleanup job.
Nothing is uploaded
The file is read in this browser tab with JavaScript and converted on your machine. There is no upload, no queue, no server-side copy and no account to create. A transaction export carries your account number, your salary and everyone you pay — the safest converter is the one that never receives the file at all.
You can verify it: open your browser devtools, switch to the Network tab, and convert a file. Your file is not among the requests — the only traffic is an anonymous analytics ping that records that a conversion happened, never what was in it.
Starting from a PDF statement instead of a file? The PDF bank statement converter reads the statement itself and exports Excel directly, so you do not need a QIF in the middle. Both tools run in the same tab, and neither uploads anything — here is how that works.
QIF to Excel, answered
Can Excel open a QIF file directly?
No. QIF stores one field per line with single-letter codes, so Excel shows a single unusable column. Converting first is the only way to get rows and columns.
Will the amounts be numbers I can sum?
Yes. The .xlsx export stores amounts as numeric cells, so SUM, SUMIF, AVERAGE and pivot tables work without a text-to-columns pass.
Does it work with Google Sheets and Numbers?
Yes — both open .xlsx. If you prefer, take the CSV download instead and import that; the columns are identical.
What about a QIF with investment transactions?
Investment records (securities, share counts, price per share) are not supported. Bank, cash and credit-card records convert.
Is the conversion free?
Yes, and there is no signup, no watermark and no row cap. It runs in your browser, so there is nothing for us to meter.
Every format pair we convert
The same private, in-browser conversion for each one.