What is QIF and how is it different from IIF?
QIF (Quicken Interchange Format) is a line-based format for personal finance exports, not the same as QuickBooks IIF.
Converting QIF to CSV lets you open decades of Quicken history in Excel for audits and migration.
For QuickBooks !TRNS tab files, use our IIF to CSV tool instead.
What data is included in the QIF to CSV export?
Your CSV typically includes:
- Transaction date, formatted for spreadsheets
- Amount, with optional sign flip for your bank convention
- Description, payee, or narrative text when present
- Reference, check number, or category fields when supplied
- Account or currency metadata when the file includes it
Why use this QIF to CSV converter
Private b行er conversion
Files never leave your device. No account required.
Fast preview
See 行 before you download so you can catch format issues early.
無料 with no watermark
Unlimited conversions for personal and business use.
Works with real bank exports
Built for production statement files, not toy samples.
Excel-ready output
UTF-8 BOM and CRLF options help Excel open the file on the first try.
Batch-friendly
Combine multiple statement files in one session when supported.
Who converts QIF to CSV?
Accountants and bookkeepers
Reconcile in Excel, match invoices, and share clean tables with clients.
Small business owners
Build cash-flow views without proprietary software.
Treasury and finance teams
Normalize bank feeds before loading a data warehouse or ERP.
Migrating between tools
Move historical transactions into a new accounting platform via CSV.
CSVall vs other ways to convert QIF
Compare common approaches before you pick a workflow.
| Method | Cost | Speed | Data privacy | Ease of use |
|---|---|---|---|---|
| CSVall (this tool) | Free | Instant | Browser-only | Upload and download |
| Manual copy in a text editor | Free | Slow | Local | Technical |
| Desktop converter app | Paid | Fast | Varies | Install required |
| Ask your bank for CSV | Free | Depends on bank | Bank portal | Not always offered |
How to export QIF from Quicken
In Quicken, export accounts or registers to QIF:
- Log in to online banking and open the account.
- Choose Download or Export for transactions.
- Pick the date range you need.
- Select QIF or the closest format your bank lists.
- Save the .qif file, then upload it here.
Shorter date ranges convert faster and are easier to verify.
Common QIF to CSV issues
Dates look like numbers in Excel
Pick ISO, US, or EU in options, or format the column as Date after import.
Wrong debit and credit signs
Enable 金額の符号を反転 or multiply the amount column in your sheet.
Garbled characters
Use UTF-8 BOM and import with UTF-8 selected in Excel.
Missing 行
Confirm you exported transactions, not a summary PDF or HTML page.
Related tools
Compare IIF to CSV (QuickBooks), OFX to CSV, and CSV to QIF for the reverse path.