Convert QIF to CSV

Convert QIF file to CSV free online. Export Quicken QIF transactions to an Excel-ready CSV spreadsheet with memo, category, splits, batch conversion, and no software download.

QIF files still appear in older Quicken exports, personal finance backups, bookkeeping handoffs, and account migration projects. The problem is simple: QIF is useful for finance software, but it is not easy to review in Excel or Google Sheets. This QIF to CSV converter reads the transaction records, preserves the fields that matter, and creates a clean spreadsheet file you can open, filter, sort, and share.

What is a QIF file?

QIF stands for Quicken Interchange Format. Quicken, Microsoft Money, GnuCash, Moneydance, and many older accounting or personal finance tools have used it to move transactions between systems. A QIF file can include dates, amounts, payees, memo notes, categories, check numbers, cleared status, addresses, and split transaction lines.

Why use this QIF to CSV converter

A basic converter may only copy date, payee, and amount. This tool is built for real bookkeeping work: it can preserve memo and category fields, export check numbers and cleared status, keep or expand split transactions, add account type and source file columns, merge multiple QIF files, and write an Excel-friendly UTF-8 CSV. Those options matter when you are cleaning old Quicken data, preparing a client spreadsheet, or moving transactions into another system.

How to convert QIF to CSV

The converter gives you control over the spreadsheet layout before download.

QIF to CSV features

The tool focuses on clean transaction extraction and spreadsheet-ready output.

• Converts Quicken QIF files into Excel-ready CSV spreadsheets.
• Reads common QIF account types such as Bank, Cash, Credit Card, Investment, Asset, and Liability.
• Preserves date, amount, payee, memo, category, check number, cleared status, and address fields.
• Detects split transaction lines and can expand them into separate CSV rows.
• Supports single amount or separate debit and credit columns.
• Supports ISO, US, EU, and source date output.
• Adds account type and source file columns for batch exports.
• Adds an Excel-friendly UTF-8 marker for names, categories, and notes with special characters.
• Shows a live preview with transaction count, split count, net change, and sample rows.
• Warns about empty files, unusual dates, missing account type, and split transactions.
• Batch converts multiple QIF files into separate CSV downloads.
• Can merge multiple QIF files into one CSV for combined review.

When QIF to CSV conversion helps

Use this converter when you need old finance data in a spreadsheet.

• You have an old Quicken QIF export and need to open it in Excel.
• A bookkeeper receives client QIF files and needs CSV for cleanup.
• An accountant wants transaction data in a spreadsheet for tax review.
• A small business is moving from older finance software to a modern app.
• You need to inspect categories, memos, and split transactions before import.
• You want to combine several account exports into one review file.
• You need a CSV archive of old Quicken data.
• You want to read a QIF file without installing Quicken.

QIF to CSV versus opening QIF directly

QIF is made for finance applications, not spreadsheets. CSV gives you a plain, flexible table you can filter, edit, audit, and map into other accounting tools. Converting to CSV also makes old QIF exports easier to review before you trust them in a new system.

Tips for better QIF to CSV results

These checks help avoid common spreadsheet import problems.

• Use ISO dates when the CSV will be imported into another app.
• Use source dates if an old QIF file has dates that do not parse cleanly.
• Expand split transactions when category-level totals matter.
• Keep category and memo columns visible for bookkeeping review.
• Use debit and credit columns when sharing with accountants who prefer separate columns.
• Include the source file column when batch converting multiple accounts.
• Check transaction count and net change against the original account before importing the CSV.

Turn QIF transactions into a clean CSV

If you need to open, clean, migrate, or archive QIF transactions, upload the file above and create an Excel-ready CSV.

Review the preview, choose the columns your workflow needs, and keep the original QIF file with the converted CSV for your records.