QIF (Quicken Interchange Format) is a file format developed by Intuit for exporting and importing financial transaction data. It uses a text-based format with transaction entries separated by hyphens. QIF files (.qif) are exported by Quicken, older versions of QuickBooks, and many UK and Australian banks for statement downloads.

What data is in a QIF file?

A QIF file contains: Date (D field), Amount (T field), Payee/Description (P field), Memo (M field), Category (L field), Cleared status (C field), and optional Address (A field). The converter extracts Date, Description (Payee), Amount, Memo, and Category into separate Excel columns.

QIF to Excel Converter — Open Quicken QIF Files in Excel & CSV Free

What is a QIF File?

QIF (Quicken Interchange Format) is a plain-text file format developed by Intuit in the 1980s for exporting and importing financial transaction data between personal finance software. Despite its age, QIF remains widely used because it is simple, human-readable, and supported by hundreds of banks and accounting applications worldwide.

A QIF file has the .qif file extension and looks like this inside a text editor:

!Type:Bank
D03/15/2025
T-82.45
PWHOLE FOODS MARKET
MWeekly groceries
^
D03/18/2025
T2500.00
PPAYROLL DIRECT DEPOSIT
^

Each transaction starts with a date (D), amount (T), payee (P), memo (M), and category (L), ending with a caret (^) separator. Excel cannot read this format directly — you need a converter to parse it into tabular rows.

Why Convert QIF to Excel?

Excel analysis: Pivot tables, SUMIF by category, spending trend charts — none of these work on a raw QIF text file
Software compatibility: Modern QuickBooks (2005+), Xero, and FreeAgent dropped direct QIF import — CSV is the universal alternative
Data cleaning: Excel lets you filter, sort, and edit transaction descriptions before importing into accounting software
Archival: Convert old QIF exports from discontinued Quicken versions to Excel for long-term archival without needing Quicken installed
HMRC / IRS / ATO: Tax authorities and auditors work with Excel, not QIF files — conversion produces the format they expect

Convert QIF to Excel or CSV — 4 Steps

Get QIF File

Export from Quicken, download from your bank, or locate your .qif file

Upload Here

Drop the .qif file into the converter above — no software needed

Review Transactions

See all parsed transactions — date, payee, amount, memo, category

Download

Excel for analysis · CSV for QuickBooks, Xero, FreeAgent, Sage

QIF File Format — Fields Explained

QIF Field Code	Field Name	Output Column	Example
D	Date	transaction_date	2025-03-15 (converted to ISO format)
T	Amount	amount	-82.45 (negative = debit)
P	Payee / Description	description	WHOLE FOODS MARKET
M	Memo	memo	Weekly groceries
L	Category	category	Food:Groceries
C	Cleared status	cleared	* (cleared) or X (reconciled)
N	Number / Cheque number	reference	1042
^	Transaction separator	(used during parsing)	—

QIF vs OFX vs CSV vs QFX — Format Comparison

Format	Extension	Structure	Best For	QuickBooks	Xero
QIF	.qif	Plain text, field codes	Quicken legacy, UK/AU bank exports	Convert to CSV first	Convert to CSV first
OFX	.ofx	XML-based	Modern bank downloads	✅ Direct import	✅ Direct import
QFX	.qfx	OFX + Intuit fields	Quicken Direct Connect	❌ Quicken only	❌ Not supported
CSV	.csv	Comma-separated text	Universal — all software	✅ Direct import	✅ Direct import

Where QIF Files Come From — Banks That Export QIF

UK Banks

Most major UK banks still offer QIF as a legacy download option. In the account download section, look for "Quicken" or ".QIF" as a format choice:

HSBC UK: Online Banking → More → Download Statements → Quicken (.qif)
Barclays: Account → Download Transactions → Quicken format
Lloyds Bank: Internet Banking → Download → Quicken/Money format
NatWest / RBS: Statements → Export → QIF format
Halifax: Transactions → Export as Quicken
Santander UK: Account → Export transactions → Quicken

Australian Banks

Commonwealth Bank: NetBank → Accounts → View Transactions → Export → Quicken QIF
ANZ: Internet Banking → Accounts → Export → Quicken format
Westpac: Online Banking → Download → Quicken (QIF)
NAB: Internet Banking → Accounts → Export transactions → QIF

Exporting QIF from Quicken Desktop

Open Quicken and go to your account
Click Account Actions → Export Transactions
Choose QIF as the file format
Select the date range and account
Click Export and save the .qif file
Upload the .qif file to our converter to get Excel or CSV

Import QIF-Converted CSV into Accounting Software

QuickBooks Online (QIF → CSV → QuickBooks)

QuickBooks dropped QIF support in 2005. The workaround: convert your QIF to CSV here, then in QuickBooks Online: Transactions → Bank transactions → Upload from file → Upload CSV → map Date, Description, Amount → select your account → Import. QuickBooks accepts the signed-amount format our CSV uses without any splitting.

Xero (QIF → CSV → Xero)

Xero does not import QIF files. Convert to CSV first, then: Accounting → Bank Accounts → Import Statement → Upload CSV. Xero auto-detects the Date, Payee (description), and Amount columns. For UK Xero users, the date format is auto-detected as YYYY-MM-DD from our output.

FreeAgent (QIF → CSV → FreeAgent)

FreeAgent does not import QIF directly. Convert to CSV, then: Banking → Import a Bank Statement → CSV upload. FreeAgent accepts our CSV column format without remapping.

Sage Accounting

Convert the QIF to CSV. In Sage Business Cloud: Banking → Import → CSV. In Sage 50: Bank → Import Statement → CSV. If Sage asks for separate Debit and Credit columns, select the "split columns" format option in our CSV download settings.

Google Sheets

To open a QIF file in Google Sheets: convert to CSV here → in Google Sheets go to File → Import → Upload → choose the CSV → Import. All transactions appear in a clean spreadsheet with columns for date, description, amount, memo, and category.

🇬🇧 UK Use Cases — QIF File Conversion

QIF downloads are most prevalent in the UK, where all major high street banks still offer QIF alongside OFX and CSV. UK-specific use cases for QIF to Excel conversion:

HMRC Self Assessment: Sole traders and freelancers who download QIF files from HSBC, Barclays, or Lloyds to manage finances in Quicken can use our converter to export to Excel for Self Assessment tax preparation without ongoing Quicken subscriptions.
Making Tax Digital (MTD): MTD-compliant software requires importing transaction data digitally. Convert QIF to CSV and import into Xero, FreeAgent, or QuickBooks — all MTD-compatible.
Switching accounting software: Many UK SMEs are migrating from Sage 50 or Quicken to Xero or FreeAgent. QIF-to-CSV conversion is the most reliable way to migrate historical transaction data without needing to pay for old software licences.
Bookkeepers processing client QIF exports: UK bookkeepers often receive QIF downloads from clients who use online banking. Converting to Excel lets the bookkeeper review and categorise transactions before importing into the client's accounting package.

HMRC Self Assessment Making Tax Digital Xero Import FreeAgent Import Sage Import Software Migration

🇺🇸 US Use Cases — QIF File Conversion

In the US, QIF files are primarily associated with Quicken desktop software. Key US use cases:

Migrating from Quicken: Users switching from Quicken to QuickBooks, Mint, or YNAB export their Quicken history as QIF and convert to CSV for import into the new software.
Archiving old Quicken data: Users who no longer have Quicken installed can still access their transaction history by converting QIF exports to Excel — no Quicken subscription needed.
Tax preparation: Self-employed individuals who used Quicken for bookkeeping can convert QIF exports to Excel for their CPA or tax preparer to categorise for Schedule C.

🇦🇺 Australia — QIF Bank Downloads

Australian banks (Commonwealth Bank, ANZ, Westpac, NAB) still offer QIF downloads. Australian use cases include:

MYOB import: Convert QIF to CSV and import into MYOB AccountRight via Banking → Import Transactions → CSV
Xero AU import: Same process as UK — convert QIF to CSV, import via Accounting → Bank Accounts → Import Statement
ATO (Australian Taxation Office) record keeping: The ATO requires digital transaction records for businesses using tax agent software. QIF-to-Excel conversion provides the audit trail in a format auditors can review

🇮🇳 India — QIF in Indian Accounting

QIF is not common in Indian banking, but some Indian businesses that use international accounting software may encounter QIF files when consolidating data from overseas subsidiaries or NRI accounts. For Indian bank statements (SBI, HDFC, ICICI, Axis), see our dedicated bank statement converters which handle the specific PDF formats used by Indian banks.

For Indian bookkeepers and CAs managing cross-border transactions, our Bank Statement to Tally converter and PDF Bank Statement to CSV tools are more relevant than QIF conversion.

Troubleshooting QIF File Conversion

Issue	Cause	Fix
Date shows wrong year	QIF uses ambiguous date formats (MM/DD/YY, DD/MM/YY, or MM/DD/YYYY) — UK and AU QIF files use DD/MM	Our converter auto-detects the date format. If dates still look wrong, check the "Date Format" option before converting and select DD/MM/YYYY for UK/AU files.
All amounts show as positive	Some QIF exports use separate !Type:CCard sections where the sign convention differs	Credit card QIF files may show expenses as positive — check the !Type header in the file. Our converter handles CCard type correctly with reversed sign convention.
Memo column appears blank	Not all QIF exports include the M (Memo) field	Correct — if the source application did not write M fields, the memo column will be empty. This is a QIF file limitation, not a converter issue.
Category appears as "Food:Groceries" with colon	Quicken uses colon-separated category:subcategory hierarchy in the L field	The full category string is extracted as-is. In Excel, use Text to Columns (split by colon) to separate category and subcategory into two columns.
File not recognised as QIF	File may have wrong extension or may actually be OFX/QFX	Open the file in a text editor. If it starts with <OFX> or <?OFX>, it is an OFX file — use our OFX to Excel converter instead.

Frequently Asked Questions

What is a QIF file?

QIF (Quicken Interchange Format) is a plain-text file format for financial transaction data, developed by Intuit. It uses field codes (D for date, T for amount, P for payee) with transactions separated by ^ characters. Files have the .qif extension and are exported by Quicken, UK banks, Australian banks, and legacy accounting software.

How do I open a QIF file in Excel?

Excel cannot open QIF files directly. Upload the .qif file to our converter above — it parses the QIF format and produces a clean Excel file (.xlsx) you can open directly in Excel without any plugins or additional software. Takes under 5 seconds.

How do I convert a QIF file to CSV?

Upload the .qif file above and select CSV as the output format. The converter parses all transactions and produces a CSV with columns for Date, Description, Amount, Memo, and Category — compatible with every major accounting and budgeting application.

What is the difference between QIF and OFX?

QIF is an older plain-text format with no data validation and limited fields. OFX is a newer XML-based format with stronger validation, account numbers in the header, and balance information. If your bank offers both, prefer OFX. If you have an OFX file, use our OFX to Excel converter instead.

What is the difference between QIF and QFX?

QFX is Intuit's proprietary extension of OFX — it adds Intuit-specific fields and is required for Quicken Direct Connect. QFX files only work in Quicken; they cannot be imported elsewhere. QIF is open and supported more widely. If you have a .qfx file, use our OFX to Excel converter (QFX is a variant of OFX).

Can I import a QIF file into QuickBooks?

QuickBooks no longer directly imports QIF files (support was dropped in QuickBooks 2005). The workaround: convert the QIF to CSV using our tool, then import the CSV via QuickBooks Online → Transactions → Bank transactions → Upload from file.

Can I import a QIF file into Xero?

Xero does not import QIF. Convert to CSV first using our tool, then in Xero: Accounting → Bank Accounts → Import Statement → upload the CSV. Xero auto-detects the column format from our output without manual mapping.

Which banks export QIF files?

UK banks (HSBC, Barclays, Lloyds, NatWest, Halifax, Santander) and Australian banks (Commonwealth Bank, ANZ, Westpac, NAB) commonly offer QIF download. In the US, QIF is primarily a Quicken export format rather than a bank download format — US banks typically offer OFX/QFX instead.

How do I export a QIF file from Quicken?

In Quicken desktop: select your account → File → Export → QIF File → choose the account and date range → Save. Alternatively: Account Actions → Export Transactions → QIF format. This produces a .qif file you can convert to Excel using our tool.

What data does a QIF file contain?

A QIF file contains: Date (D), Amount (T), Payee/Description (P), Memo (M), Category (L), Cleared status (C), and optional Cheque Number (N). Our converter extracts all these fields into separate Excel columns — Date, Description, Amount, Memo, Category, Cleared, and Reference.

Can I convert multiple QIF files at once?

Our converter processes one file per conversion. To combine multiple QIF files: convert each to CSV separately, open all CSVs in Excel, paste them into one sheet, and sort by date. Useful when combining QIF exports from multiple accounts or date ranges.

Is the QIF to Excel converter free?

Yes — completely free with no signup required. Register free (no credit card) to remove any size limits and save your conversion history for later download.

Related Format Converters

OFX to Excel CSV to QBO Converter PDF to CSV Converter Bank Statement to Tally Starling Bank PDF Monzo Bank PDF All Bank Converters