Convert QIF to Excel — Formatted & Pivot-Ready
Turn your Quicken QIF export into a formatted Excel workbook — typed dates, real numbers, and clean columns ready for pivot tables, formulas, and sharing with your accountant.
Works with Quicken, Microsoft Money, and GnuCash QIF exports. Free online — no signup.
How It Works
Upload Your QIF File
QIF file from Quicken, Microsoft Money, GnuCash, or any finance software. Bank, credit card, cash, and investment accounts all supported.
Data Typed & Formatted
Dates become real Excel dates, amounts become numbers, categories and memos stay as text. Split transactions expanded into individual rows.
Download XLSX
Formatted workbook with header row and typed columns. Opens in Excel, Google Sheets, LibreOffice, or Numbers — ready for analysis immediately.
What Happens When You Open QIF in Excel
Excel doesn't understand QIF format. Open it as text and you get this:
Raw QIF in Excel
!Type:Bank D03/15/2026 T-45.99 PAMAZON MKTPL*RT4K2 LAuto:Fuel MOrder #123-456 ^ D03/16/2026 T1250.00 PPay Deposit LIncome:Salary ^
One column, no structure, unusable
After Conversion to XLSX
| Date | Payee | Amount | Category |
|---|---|---|---|
| 03/15/2026 | AMAZON MKTPL | -45.99 | Auto:Fuel |
| 03/16/2026 | Pay Deposit | 1,250.00 | Income:Salary |
Typed columns, sortable, pivot-ready
Excel or CSV — Which Do You Need?
Excel XLSX (This Tool)
- Typed dates and amounts — formulas work
- Pivot tables, charts, SUMIF, VLOOKUP
- Best for analysis and sharing
- Opens in Excel, Sheets, LibreOffice
CSV (Plain Text)
- Everything stored as text strings
- Max compatibility for software import
- Best for data migration
- Use QIF to CSV instead
What is QIF?
Quicken Interchange Format
Quicken's legacy text format with single-letter field codes (D, T, P, L, M). Excel can't open it — you'll see raw codes with no column structure. Needs conversion to be useful in a spreadsheet.
What is XLSX?
Microsoft Excel Open XML Spreadsheet
Formatted spreadsheet with typed cells — dates are sortable, amounts are summable, text stays text. Pivot tables, charts, and formulas work immediately. Opens everywhere.
Why This Tool
Typed Date Cells
QIF dates (D03/15/2026) become real Excel dates. Sort by date, filter by month, use DATE functions — no manual parsing.
Amounts as Numbers
Transaction amounts are real numbers. SUM, SUMIF, AVERAGE, and pivot tables work immediately — no "number stored as text" warnings.
Split Transactions Expanded
Multi-category splits become individual rows with their own category, amount, and memo. Nothing collapsed or hidden.
Categories Preserved
Quicken hierarchies like "Auto:Fuel" and transfer references like "[Savings]" pass through intact in a dedicated column.
Investment Support
Buy, Sell, Div, ReinvDiv actions mapped with security name, shares, and price columns for portfolio analysis in Excel.
Multi-Account Handling
QIF files with multiple !Account or !Type sections parsed completely. All accounts, all transactions, one workbook.
When to Use This
Share With Your Accountant
Not everyone has Quicken. Export QIF, convert to XLSX, and send a formatted spreadsheet your accountant can open in Excel or Google Sheets.
Spending Analysis
Build pivot tables by category and month from years of Quicken data. Spot trends, compare periods, and create charts Quicken's built-in reports can't.
Quicken Migration
Moving away from Quicken? Convert your transaction history to Excel as a universal archive, then import CSV into your new software.
QIF-to-Excel Issues & Fixes
Dates appear swapped — March 4 showing as April 3
QIF doesn't specify locale. D03/04/2026 is March 4 (US) or April 3 (UK). Our converter auto-detects based on context, but verify the first few dates match your records.
Investment transactions missing shares or price columns
Only !Type:Invst QIF entries contain investment fields (shares, price, action). If your QIF is !Type:Bank, these columns won't appear — that's expected for non-investment accounts.
Split transactions appear as separate rows instead of one row
This is by design. QIF splits have separate categories and amounts — each becomes its own row for accurate category-level analysis in pivot tables. The parent transaction amount ties them together.
File won't upload — "invalid format" error
The QIF file must start with !Type: or !Account header. If it starts with invisible characters (BOM) or is actually a different format renamed to .qif, the parser will reject it.
Frequently Asked Questions
Can't I just open a QIF file in Excel?
No. Excel doesn't understand QIF format. If you open it as text, you'll see raw single-letter codes (D, T, P, L) with no column structure — unusable for analysis. Our converter maps those codes to proper labeled columns with correct data types.
Why Excel instead of CSV?
CSV stores everything as text — dates and amounts are strings. Excel (XLSX) has typed cells: dates you can sort chronologically, amounts you can SUM, and categories you can pivot on. No reformatting needed.
Does it handle split transactions?
Yes. QIF splits (S/$/E fields) become individual rows in the spreadsheet, each with its split category, amount, and memo. The parent transaction connects them.
Does it handle investment transactions?
Yes. Buy, Sell, Div, ReinvDiv, and other investment actions are mapped with security name, shares, and price columns — useful for portfolio tracking in Excel.
Can I share this with my accountant?
Yes — that's one of the main use cases. Not everyone has Quicken, but everyone has Excel or Google Sheets. Export QIF, convert to XLSX, and share a formatted spreadsheet.
Does it preserve Quicken categories like "Auto:Fuel"?
Yes. Category hierarchies (parent:child) and transfer references ([AccountName]) pass through intact in the Category column.
Can it handle multi-account QIF files?
Yes. QIF files with multiple !Account or !Type sections are parsed completely. All transactions from all accounts are included.
CoolUtils and FinanceFileConverter also do this. Why use yours?
No file size limits, no daily conversion caps, no signup walls. Fully free with no restrictions on transaction count or file frequency.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your QIF file is deleted immediately after conversion.
Related Tools
QIF to CSV
Convert QIF (Quicken Interchange Format) files to CSV. Extract all transactions including multi-account QIF files. Free, instant, no signup required.
Convert now →QIF to QBO
Convert QIF files to QBO for QuickBooks. The easiest way to migrate transaction data from Quicken to QuickBooks Desktop or Online. Free, no signup required.
Convert now →PDF to Excel
Turn bank statement PDFs into formatted Excel spreadsheets. Keeps all columns, headers, and transaction details. Any bank, any language. Free, no signup.
Convert now →CSV to Excel
Convert CSV files to formatted Excel (XLSX) spreadsheets with proper columns and headers. Opens in Excel and Google Sheets. Free, instant, no signup required.
Convert now →