QIF to CSV and Excel: convert Quicken interchange files
QIF is a plain but awkward format with no standard date order. This tool works out the order from your file, and you can correct it.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: runs in your browser
No file at hand?
Statements
Columns of
Detected automatically. Change anything that looks wrong and the result updates.
Transactions
Output options
How to use it
- Drop your .qif file.
- Check the date order if the page warns you.
- Download CSV or Excel.
Which programs use QIF
Quicken and Microsoft Money made QIF popular, and programs such as GnuCash still read it. Some banks and card issuers still offer it as an export. Each record is a set of lines beginning with a letter (D date, T amount, P payee, M memo) and ending with ^.
When it helps
- Rescuing old Quicken or Microsoft Money data.
- Analysing exported transactions in a spreadsheet.
- Moving to a program that takes CSV.
Private by design
A statement shows your income, your rent and who you pay, so it should not need uploading to convert it. Here the file is read by code running on your device, and nothing is sent to a server. You can check it in your browser’s network panel.
Known limitations
- PDF statements are not read. Convert them to Excel first with the PDF tools and check the result, because PDF extraction can misread rows.
- A .qbo file is read but not written: QuickBooks Desktop requires an Intuit bank ID that cannot be validated here. Use OFX, or the 3-column CSV for QuickBooks Online.
- OFX requires a closing balance. If your source has none, the file contains the sum of the transactions, which is not your real balance.
- Investment transactions in OFX and QIF are not read. Split lines in QIF are kept as one transaction with its total.
- File size is limited by your device memory, not by any quota. The work runs on the page, so very large files can pause it for a moment.
Frequently asked questions
Is this QIF converter really free?
Yes. It is 100% free, with no usage limits, no account and no sign-up. There is no paid plan and no feature is locked.
Are my bank statements uploaded to a server?
No. Your files never leave your device: they are read and converted inside your browser. The page only downloads its own code and open-source libraries from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never the contents or names of your files.
How are QIF dates interpreted?
QIF does not say whether 01/02/2024 means January or February. The tool looks for dates that only fit one order, such as 13/01. If every date fits both, it warns you and you choose the order under Output options.
Are split transactions kept?
Each transaction keeps its total amount, payee, memo and main category. The individual split lines are not exported as separate rows.
Can I read investment accounts?
No. Only bank, cash, credit card and other asset or liability accounts are read. Investment sections are skipped.
Does it check the balance?
No. QIF files usually carry no balances, so the page says there is nothing to check.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives the contents or names of your files. You can change your choice at any time with “Cookie settings” at the bottom of the page.