Dates are real Excel dates, Debit, Credit, Amount and Balance are numbers, and references stay as text.
Supported input and export details
QIF split transactions are not supported. Ambiguous dates require the date order to be selected.
Set required export details in “Account and export details” before converting. The preview shows up to ten transactions and totals by account and currency. Opening or running balances are not inferred, and previewed transactions cannot be edited here. Download links expire after 24 hours.
Why use this QIF to Excel converter
This workbook stores supported unsplit QIF transaction fields as typed dates, amounts and text, with a Summary sheet of totals per account and currency. It does not expand splits or create split indexes. If the next step is Google Sheets, a database or an accounting import screen, QIF to CSV gives the same columns as plain text.
Multi-line QIF splits are rejected rather than flattened.
The L line is kept whole, for example Utilities:Electric, so you can filter or pivot on it.
Names from !Account blocks are written on every row, so multi-account exports stay sortable.
Ambiguous dates require a chosen month/day or day/month order.
The QIF export is validated, fingerprinted with SHA-256 and removed as soon as the job exists.
Who converts QIF to Excel
History moves into a workbook that outlives the program.
Years of Quicken data feed reports and tax schedules.
Client history is reviewed with totals by category.
Household finances stay readable in a spreadsheet.
QIF to Excel: how each field is mapped
Every QIF field has a natural cell type. The table shows the code and how it is typed.
| Field | In QIF | In Excel |
|---|---|---|
| Date | D line, locale-dependent format | Typed date cells that sort and filter correctly |
| Description | P (payee) and M (memo) lines | Text cells; wrapped descriptions stay in one cell |
| Amount | T line, signed | Numeric Debit, Credit and signed Amount cells |
| Balance | Not stored | Numeric running balance column |
| Reference | N line for check number | Text cells so leading zeros survive |
| Account | !Account header block | Sheet header or a dedicated column |
| Currency | Not stored; account currency applies | Number format applied per column |
Converting QIF to Excel in practice
Bringing supported legacy Quicken data into a workbook
A QIF export often represents years of personal or small-business history. The converter writes it into a worksheet with typed date cells, numeric amounts, and text columns for payee, category, memo and check number, and adds an Account column taken from the !Account header so a file exported from several accounts stays sortable by account.
Split records are rejected rather than flattened. The workbook does not produce split indexes, parent/child category columns or a manual review screen.
After converting, check that:
- Amounts match the supported unsplit records
- Ambiguous dates use the selected order
- The Account field matches the input header where present
Import QIF to Excel: why the file needs converting first
Excel can open a QIF file as text, but every field lands on its own line in column A: a D line for the date, T for the amount, P for the payee, L for the category and a caret between records. Nothing sorts or adds up. The QIF to Excel converter reads those records and writes one transaction per row, with the date order you choose applied before the dates are stored, so the workbook is ready for filters, SUMIFS and pivot tables.
What the Excel workbook contains
The download has two sheets. Summary lists each account and currency with its transaction count, money in, money out and net. Transactions has a frozen, filterable header row and the columns Date, Payee, Memo, Debit, Credit, Amount, Balance, Reference, FITID, Account, Currency, Category and Source file. Balance and FITID stay empty for QIF input, because QIF stores neither a running balance nor a transaction ID.
Exporting a QIF file from Quicken or Microsoft Money
In Quicken for Windows the export is under File, File Export, QIF File; choose one bank, credit-card or cash account and the date range you need. Microsoft Money and most budgeting apps offer QIF under File or Export. Leave investment accounts out of the export, since only !Type:Bank, !Type:CCard and !Type:Cash records are accepted. Transfers between accounts keep their bracketed account name, such as [Savings], in the Category column.
Example: one QIF record as an Excel row
A record made of the lines D03/15/2024, T-54.20, PCity Power, N1042 and LUtilities:Electric becomes a row with Date 2024-03-15 stored as a real date, Payee City Power, Debit 54.20, Amount -54.20, Reference 1042 kept as text, and Category Utilities:Electric. From there a PivotTable with Category in rows and Amount in values gives spending by category for any period.
How to convert QIF to Excel in three steps
- 1Upload the QIFAdd the export from Quicken, Microsoft Money or your budgeting app.
- 2Confirm the date orderCheck interpreted dates against raw lines.
- 3Download the workbookOpen it and pivot on the Category column straight away.
About QIF and Excel
QIF is a letter-coded plain-text format from early Quicken, still exported by many programs. Its weak points are locale-dependent dates and the absence of identifiers; What is a QIF file? walks through the record codes. If your bank still offers a QFX or OFX download for the same period, QFX to Excel or OFX to Excel keeps the bank's transaction IDs as well.
An XLSX workbook stores typed cells, which makes the history sortable and summable immediately. For a fixed, printable copy of the same history, use QIF to PDF; to move it into QuickBooks, use QIF to QBO.
Specifications and vendor help for QIF and Excel: Quicken support · Microsoft Excel support · Quicken Interchange Format on Wikipedia · Microsoft: import or export text files
Questions about Excel conversion
Are QIF splits supported?
No. Split records are rejected.
Are categories kept whole?
Yes. The full L value, such as Auto:Fuel, goes into one Category cell. Use Excel's Text to Columns with a colon delimiter if you want parent and child in separate columns.
What if dates are two-digit years?
The parser uses its fixed two-digit-year pivot; ambiguous date order must be selected.
Can I convert several QIF files at once?
Yes. Each file's account appears in the Account column and its filename in the Source file column.
Which QIF sections are accepted?
!Type:Bank, !Type:CCard and !Type:Cash transactions, plus !Account headers. Investment, category-list and memorized-transaction sections are rejected.
Is this qif to excel converter online only?
Yes. It runs in the browser, so there is nothing to install on Windows or Mac and the workbook downloads directly.
How do I import QIF to Excel without converting?
Excel cannot read QIF directly; it is a letter-coded text format. Convert the QIF file to Excel here, then open the workbook.
Is the qif to excel converter free?
Yes. Uploading, reviewing dates and downloading the workbook is free.