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.

Starting from $5 — see pricing & 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 It Works

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.

Quick Answers

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.

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 Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

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 Use This Tool?

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

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

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

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.