QIF to Excel Converter Online Free — Open QIF Files in Excel
Open a .qif in Excel and the whole file runs down column A, one coded line per cell: D3/15'24 in one, PCOSTCO WHOLESALE in the next, T-100.00 below it. Convert QIF to Excel online free and the same file opens as a proper sheet, with a date column, amounts you can sort and total, and every split payment on complete rows. The QIF is read in this browser tab, so there is nothing to download.
Not the file you need?
Why Use Our QIF to Excel Converter Tool?
No blank split lines
Each part of a split payment is a full row: date, payee and cheque number repeated, plus a Txn # tying the parts together.
Numbers, not text
Amounts, quantities, prices and cheque numbers arrive as numbers, so SUM, sort and pivot work straight away.
Opens in any spreadsheet
A standard .xlsx for Excel 365, older Excel, Google Sheets or Numbers. Nothing installs on your computer.
How to convert QIF file to Excel in three steps
Get the QIF out of the program
Quicken for Windows writes one from File, Export, QIF File, and Microsoft Money from its own Export menu. A single account and the whole file both work.
Upload the QIF
Drop it on the box above. The transactions appear as a table first, so you can check payees and amounts before anything downloads.
Download the Excel file
There is nothing to set. The .xlsx has one Transactions sheet with the columns already sized, ready to sort, filter or pivot.
Opening a QIF file in Excel: before and after
Excel has no QIF import, so a .qif opens as plain text: every line in column A, the letters still on the front. The same two transactions, converted, fill a sheet you can use.
The .qif opened in Excel
| A | |
|---|---|
| 1 | !Type:Bank |
| 2 | D3/1'24 |
| 3 | PACME PAYROLL |
| 4 | T2,400.00 |
| 5 | LSalary |
| 6 | ^ |
| 7 | D3/15'24 |
| 8 | N1031 |
| 9 | PCOSTCO WHOLESALE |
| 10 | T-100.00 |
| 11 | L--Split-- |
| 12 | SGroceries |
| 13 | $-60.00 |
| 14 | SHousehold |
| 15 | $-40.00 |
| 16 | ^ |
Sixteen rows for two payments, and nothing to sort on.
The .xlsx from this converter
| Date | Description | Amount | Category | Memo | Number | Split | Txn # | |
|---|---|---|---|---|---|---|---|---|
| 2 | 2024-03-01 | ACME PAYROLL | 2,400.00 | Salary | 1 | |||
| 3 | 2024-03-15 | COSTCO WHOLESALE | -60.00 | Groceries | 1031 | 1 of 2 | 2 | |
| 4 | 2024-03-15 | COSTCO WHOLESALE | -40.00 | Household | 1031 | 2 of 2 | 2 |
Swipe the sheet to see every column.
The $100.00 split payment becomes two complete rows, and the parts add back to the $100.00 paid. Amounts, the cheque number and Txn # are numbers, right-aligned the way Excel shows them.
What goes wrong when a QIF meets Excel
Excel guesses the day and month
Hand Excel 03/04/2024 as text and it reads it with your computer's date settings: 4 March on one machine, 3 April on another. The workbook here writes 2024-03-04 instead, once the file has shown which order it uses, so no setting can swap them.
--Split-- where a category should be
A split payment's own category line just says --Split--, and the real categories sit on the lines below it. Each part here gets its own category, so a pivot by category never shows a --Split-- bucket.
Microsoft Money has no Excel export
Money saves reports as text and transactions as QIF, one account at a time. Money in Excel sounds like the answer but is a separate Excel template, closed in 2023, and it cannot open an .mny file. To export Microsoft Money to Excel, export the QIF and convert it.
The preview shows 200 rows; the file has them all
A long register only shows its first 200 rows on screen, to keep the page quick. The Excel download carries every transaction in the QIF, however many years it covers.
Four ways to export Quicken to Excel, and what happens to splits
Quicken can put data into a spreadsheet itself. The catch is the split payment: each route below handles it differently, and that decides whether the sheet can be sorted and totalled.
| Route | Where | Split payments | What you get |
|---|---|---|---|
| Quicken for Windows report | Where: Reports → Export to Excel | First line only | Date, account and payee appear on the first line of a split and the rest are left blank, so a sort scatters the parts. |
| Quicken for Mac register | Where: File → Export → Register Transactions to CSV File | Every line, no totals | All split lines come out, with no option for one total per payment. It is a CSV, so Excel guesses how to read the dates. |
| Quicken Simplifi | Where: Its CSV export | Left out | Each payment arrives as its total; the split detail is not in the file by default. |
| A QIF, converted here | Where: Quicken for Windows or Money → Export → QIF | Every part, full rows | Date, payee and number on every part, with Split and Txn # columns. Amounts are numbers and dates sort. |
Who converts QIF to Excel, and what for
Pivoting spend by category
Convert Quicken to Excel once and a pivot table on Category and Amount shows where ten years of money went, without Quicken open.
Sending it to an accountant
An accountant asking for last year's figures wants a workbook, not a .qif. Filter the dates, delete what is private, send the file.
Checking against a bank PDF
Put the register beside the bank's own statement and mark what matches. A PDF statement turns into a sheet with our PDF bank statement converter.
Comparing one year to the next
The date column sorts, so copy two years side by side and compare the totals for each category.
Rescuing an old Money file
Microsoft Money never had an Excel export. Its QIF export still works, and the sheet it becomes outlives the computer Money runs on.
Looking inside a QIF file
Not sure what a .qif holds? The rows appear on screen before any download, so the page works as a free QIF viewer when you only need to look.
What arrives as numbers, and what stays text
A spreadsheet is only useful if its numbers are numbers. This is every column the workbook can have, what kind of cell it is, and what that lets you do.
| Column | Arrives as | So you can |
|---|---|---|
| Date | Text, 2024-03-15 | Sorts oldest to newest. Data → Text to Columns → YMD turns it into real dates. |
| Amount | Number | SUM, AVERAGE and pivot totals work at once. |
| Number | Number | Cheque numbers sort in order and can be looked up. |
| Split | Text, 1 of 2 | Filter to see split payments only. |
| Txn # | Number | Groups the parts of one payment for a subtotal. |
| Description · Category · Memo | Text | Filter or pivot by payee and category. |
| Quantity · Price · Commission | Number | Investment files: shares and costs total like any column. |
Frequently Asked Questions — QIF to Excel Converter
QHow do I open a QIF file in Excel?
QCan I open a QIF file in Excel without converting it?
QCan Quicken export to Excel?
QWill the file open in Excel 365, Google Sheets or Numbers?
QWhy are the dates written as 2024-03-15?
QDo split transactions stay together?
QWhat happens to a QIF with several accounts?
QCan I convert an investment QIF to Excel?
QCan I open a QDF file without Quicken?
QIs there a QIF to Excel converter free download?
QDoes my QIF leave my computer?
QShould I convert my QIF to Excel or to CSV?
QWhat is the best QIF to Excel converter online?
Other Conversion Formats
Open your QIF as a spreadsheet
A .qif was made for Quicken to read, not you. Put it on the box above and it comes back as a workbook you can sort, total and pivot, split payments intact: a QIF file to Excel converter online, free to start, with nothing to install. The rest of our formats, from PDF statements to QuickBooks files, are listed on the converters page.