What QIF export file format does this tool accept?

This tool accepts QIF Bank File files. Export from QIF and upload the File file directly.

Can I convert QIF CSV to CSV?

Yes, this tool converts QIF Bank File exports directly to CSV Spreadsheet format compatible with CSV.

How do I import QIF bank to CSV?

Export your bank from QIF, upload the CSV file to this converter, then import the converted file to CSV.

Convert QIF to CSV | QIF to Spreadsheet

🥦

CSV Spreadsheet Format

valid rows

Extract all transaction fields from QIF (Quicken Interchange Format) files into a clean CSV spreadsheet. Category, Payee, and Memo each stay in their own column. Your data never leaves your browser.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample QIF

Valid QIF file with sample transactions

Sample QIF File

How to Convert QIF to CSV

Export from Banking

My Account → Account Activity → Select .QIF

Upload and Configure

Upload QIF Bank Transactions CSV and choose QIF Bank Export (CSV) format

Preview and Download

Review converted data, download Csv-ready file

Open in spreadsheet

Open the CSV file in Excel, Google Sheets, or any spreadsheet application

Output is in CSV Spreadsheet format — ready to import directly, no manual reformatting needed.

Why Use the QIF to CSV Converter?

Category Preserved

QIF categories and subcategories are kept in their own column - unlike converters that drop them

All Fields Separated

Payee and Memo stay in separate columns for flexible filtering and analysis

Flexible Date Parsing

Handles all QIF date formats - MM/DD/YYYY, M/D'YY, DD/MM/YYYY, and more

Cleared Status Kept

Transaction cleared status (*, X, R) is preserved for reconciliation tracking

Browser-Based Security

All processing happens in your browser - your financial data never leaves your computer

Split Transaction Support

Split transactions are properly handled and converted to individual rows

QIF to CSV Conversion Questions

What columns does the CSV output include?

The CSV includes 7 columns: Date, Amount, Payee, Memo, Category, Check Number, and Cleared. Every field from the QIF file gets its own column.

Are categories preserved?

Yes! Unlike most QIF converters that drop category data, we keep categories (including subcategories like "Office Supplies:Paper") in their own column.

Is my financial data safe?

All conversion happens entirely in your browser. Your QIF file is never uploaded to our servers.

How People Use QIF to CSV

I exported all my Quicken transaction history as QIF files and needed them in spreadsheet format for a spending analysis series on my blog. The QIF to CSV converter kept all 7 fields separated, including categories like Auto:Insurance, which most other tools strip out.

I receive QIF files from clients during financial investigations and need them in CSV for pivot table analysis. The converter preserves the cleared status field, which is critical for identifying which transactions were reconciled before the dispute period.

I pull QIF exports from GnuCash and old Microsoft Money backups for clients migrating to modern platforms. Converting QIF to spreadsheet format lets me clean and validate the data in Excel before importing elsewhere. The split transaction handling saves me from manual row creation.

Field Mapping

How Banking Qif fields map to Csv Bank Export

Banking Qif	Source Value		Csv Bank Export	Target Value	Note
`D`	`01/15/2025`	→	`Date`	`01/15/2025`	QIF date (flexible formats) → MM/DD/YYYY
`T`	`-50.00`	→	`Amount`	`-50.00`	Signed amount (negative for payments, positive for deposits)
`P`	`Amazon Purchase`	→	`Payee`	`Amazon Purchase`	Payee name (kept separate)
`M`	`Online order`	→	`Memo`	`Online order`	Transaction memo (kept separate)
`L`	`Office Supplies:Computer`	→	`Category`	`Office Supplies:Computer`	Category with optional subcategory
`N`	`1001`	→	`Check Number`	`1001`	Check number or reference
`C`	`*`	→	`Cleared`	`*`	Cleared status

Why Convert QIF to CSV?

QIF Is a Legacy Format

QIF (Quicken Interchange Format) is a legacy text format: - Limited support: Most modern software can't read QIF files directly - Hard to read: Single-character field codes (D, T, P) make files cryptic - Category data: QIF contains categories that get lost in most conversions Converting to CSV preserves all your data in a format any spreadsheet can open.

What This Tool Does

We extract every field from your QIF file into separate CSV columns with all 7 fields separated: Date, Amount, Payee, Memo, Category, Check Number, and Cleared. Unlike other converters, we preserve the Category and Cleared fields that are unique to QIF.

Your QIF to CSV Conversion is Secure

Local Processing Engine

Your QIF to CSV files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your QIF to CSV files are never cached, logged, or stored anywhere. Every session is ephemeral.

Privacy-First Architecture

Designed for data sovereignty. No third-party trackers or analytics touch your QIF to CSV files.

Data Transformation

Each QIF transaction becomes one CSV row with all fields separated

Text-based transaction with single-character codes

Key columns: D (Date), T (Amount), P (Payee), M (Memo), L (Category)

1:1 — One input row creates one output row

Spreadsheet row with all fields in separate columns

Date Convert QIF date to MM/DD/YYYY

Amount Keep signed amount as-is

Payee Payee name in separate column

Memo Memo in separate column

Category Category preserved in separate column

Amounts must be numeric; dates must be valid

Common QIF Bank Export (CSV) Import Errors

Issues you might encounter when importing QIF Bank Transactions data to QIF Bank Export (CSV) - and how we solve them

Invalid QIF File

File is not a valid QIF format

CSV file or corrupted QIF

Valid QIF file from Quicken or bank

Ensure you're uploading a QIF file with proper format

QIF files are text files with lines starting with D, T, P, etc.

No Transactions Found

QIF file contains no transaction data

Empty QIF file or only header

QIF file with D, T, and ^ delimited transactions

Ensure your QIF file contains transaction data

Re-export from Quicken or your bank

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

The CSV includes 7 columns: Date, Amount, Payee, Memo, Category, Check Number, and Cleared. Every field from the QIF file gets its own column.

Yes! Unlike most QIF converters that drop category data, we keep categories (including subcategories like "Office Supplies:Paper") in their own column.

Split transactions (with S, E, and $ fields) are converted to separate rows, each with the split amount and category.

We support all common QIF date formats including MM/DD/YYYY, M/D/YY, Quicken's apostrophe format (M/D'YY), ISO format (YYYY-MM-DD), and European format (DD/MM/YYYY).

All conversion happens entirely in your browser. Your QIF file is never uploaded to our servers.