QIF → EXCEL · FREE ONLINE TOOL

QIF to Excel converter

Convert supported unsplit QIF transactions into typed Excel rows; split records are rejected.

Click here to upload QIF filesor drag and drop here · browse your files · up to 20 files, 50 MB each
Account and export details

Only details required for the selected export are used. Account IDs and bank identifiers are included in bank-feed files.

Upload a bank, credit-card or cash QIF file and choose the date order for ambiguous dates. Split transactions are not supported.

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.

Typed cells

Dates are real Excel dates, Debit, Credit, Amount and Balance are numbers, and references stay as text.

Split records rejected

Multi-line QIF splits are rejected rather than flattened.

Category column

The L line is kept whole, for example Utilities:Electric, so you can filter or pivot on it.

Account column

Names from !Account blocks are written on every row, so multi-account exports stay sortable.

Date order selected

Ambiguous dates require a chosen month/day or day/month order.

File removed after the job

The QIF export is validated, fingerprinted with SHA-256 and removed as soon as the job exists.

Who converts QIF to Excel

Users retiring old software

History moves into a workbook that outlives the program.

Small business owners

Years of Quicken data feed reports and tax schedules.

Accountants

Client history is reviewed with totals by category.

Family record keepers

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.

FieldIn QIFIn Excel
DateD line, locale-dependent formatTyped date cells that sort and filter correctly
DescriptionP (payee) and M (memo) linesText cells; wrapped descriptions stay in one cell
AmountT line, signedNumeric Debit, Credit and signed Amount cells
BalanceNot storedNumeric running balance column
ReferenceN line for check numberText cells so leading zeros survive
Account!Account header blockSheet header or a dedicated column
CurrencyNot stored; account currency appliesNumber format applied per column
QIF to Excel converter diagram showing date, description, amount, balance, reference, account and currency fields carried from QIF to Excel
QIF fields are written to typed cells. Split transactions are rejected rather than flattened.

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

  1. 1Upload the QIFAdd the export from Quicken, Microsoft Money or your budgeting app.
  2. 2Confirm the date orderCheck interpreted dates against raw lines.
  3. 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.