QIF to CSV converter
QIF files from old Quicken, Microsoft Money or a bank's "Quicken 2004" download are plain text but awkward to read. Convert them to CSV for a clean table you can open anywhere.
- ✓ Free, no account, no email
- ✓ Converted in memory and never stored
- ✓ Reads files from any bank or finance app
When you need to convert QIF to CSV
- You have years of QIF exports from Quicken or Microsoft Money and want them in a spreadsheet.
- Your new software imports CSV but not QIF.
- You need the categories (L field) as a column.
How to convert QIF to CSV
- Drop your .qif file on the converter (up to 5 MB).
- Check that "Convert to" says CSV, and pick the date order if your dates are ambiguous.
- Click Convert: the CSV file downloads straight away. Nothing is stored.
- Open or import it: Excel, Google Sheets, Numbers — Open the file directly. Dates are written YYYY-MM-DD by default so they sort correctly in every locale.
What happens to your data
- Each record (D, T, P, M, N, L lines ending with ^) becomes a row with Date, Description, Amount, Debit, Credit, Memo, Check number and Category.
- Dates like 1/5'24 (Quicken's apostrophe year), 01/05/2024 and 2024-01-05 are all read; the day/month order is detected or chosen by you.
- Account headers, category lists and investment sections are skipped; only bank and credit card transactions are converted.
Importing the CSV file
- Excel, Google Sheets, Numbers
- Open the file directly. Dates are written YYYY-MM-DD by default so they sort correctly in every locale.
- QuickBooks Online and Xero
- Both import CSV bank statements; columns are Date, Description, Amount (plus Debit and Credit), which their import screens can map in one step.
What is a QIF file?
QIF is a plain-text format from the early days of Quicken. Each transaction is a short block of lines: D for the date, T for the amount, P for the payee, M for the memo, L for the category and N for the check number, ending with a ^. It has no transaction IDs, so importing the same file twice creates duplicates.
What is a CSV file?
A CSV file is a plain-text table: one row per transaction, columns separated by commas (or semicolons in many European banks). Every bank lays its CSV out differently, with its own column names, date order and sign convention, which is why accounting software often rejects a bank's CSV as it is.
QIF to CSV: questions
My QIF has several accounts. Are they all converted?
All bank and credit card transactions in the file are converted into one CSV. Investment transactions (!Type:Invst) are not.
Are splits kept?
The transaction total is kept. Split lines (S, $, E fields) aren't written as separate rows.
What if dates are read with day and month swapped?
Choose MM/DD/YYYY or DD/MM/YYYY under "Dates in the file" and convert again.
Is the QIF to CSV converter free?
Yes. Format-to-format conversions are free and need no account. Files are converted in memory and never stored. Converting PDF bank statements is a separate tool with a free daily allowance.
Only have a PDF statement? Convert a PDF bank statement to CSV — digital or scanned, any bank.
Other converters: QBO to CSV · OFX to CSV · QFX to CSV · QIF to Excel · QIF to QBO · IIF to CSV · All file converters