QIF to CSV Converter
Open a QIF file from Quicken or another money app and save its transactions as CSV or Excel, right in your browser.
Drop your bank file here or choose a file
QIF · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert QIF to CSV
- Find the QIF file QIF files come from Quicken exports, older bank downloads and many money apps. They end in .qif.
- Drop it into the converter Choose the file or drag it onto the box above. Bank, cash, credit card, asset and liability sections are read; category and investment sections are skipped.
- Confirm the date format if asked QIF files don't say whether 03/04/2026 is March 4 or April 3. The converter checks every date and asks only when it still can't tell.
- Check the transactions Every transaction is shown with its date, payee, amount, memo, check number and category.
- Choose CSV or Excel and download CSV opens anywhere; Excel gives real date and number cells. Categories can be included as a column.
How to open the file in a spreadsheet
Microsoft Excel
- Open the file Double-click the CSV, or download Excel instead to get real date and number cells.
Google Sheets
- Import the file Choose File › Import › Upload and pick the file.
Why convert QIF to CSV
QIF files are easy for programs to read but awkward for people: each field sits on its own line. Converting QIF to CSV puts each transaction on one row with its date, payee, amount, memo, check number and category, ready for a spreadsheet, a bookkeeper or another app.
What you get in the CSV
Each row is one transaction with Date, Description (the QIF payee), Amount, Memo and Check number, plus Category when the QIF file has categories. Dates are written in the format you choose (MM/DD/YYYY unless you change it), and amounts as plain numbers with a minus sign for money out.
Which parts of a QIF file are read
A QIF file is made of sections, each starting with a header line. The converter reads the transaction sections
for bank (!Type:Bank), cash (!Type:Cash), credit card (!Type:CCard), asset (!Type:Oth A) and liability
(!Type:Oth L) accounts, and the account names from !Account lines. Category, class and memorized-transaction
lists are skipped because they aren’t transactions, and investment sections (!Type:Invst) are skipped with a
note. For split transactions, the main category and the full amount are kept.
QIF dates
Quicken writes QIF dates in several ways, such as 1/ 5'26 with an apostrophe before a two-digit year, and the
file never says whether 03/04/2026 is March 4 or April 3. The converter reads all of these forms, checks every
date in the file to decide, and asks you only when the file could be read both ways.
Supported banks and file layouts
QBO, QFX, OFX and QIF files from any bank
The reader handles both forms of OFX (the older SGML form used by QBO and QFX files, and the newer XML form), bank and credit card statements, and files that hold more than one account. QIF files from Quicken and other apps are read too, including Quicken's old date styles.
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Common problems and fixes
- The dates look wrong
- Old Quicken files write dates like 1/ 5'26 (an apostrophe before the year) or with spaces inside. The converter reads these. If day and month look swapped, choose the other date format when asked.
- Only some accounts came through
- A QIF file can hold several accounts. The converter lists them; pick each one in turn. Investment accounts are not converted.
- Split transactions show one amount
- The converter keeps the total of each transaction (the T line). Split lines inside a transaction are not listed separately.
- Some characters look odd
- Older QIF files use the Windows-1252 character set. The converter detects it, so accented names should look right; if not, tell us which app made the file.
QIF vs CSV
| QIF | CSV | |
|---|---|---|
| What it is | Text records, one line per field | A table: one row per transaction |
| Opens in Excel | No | Yes |
| Account type | In the header line | Not stored |
| Categories | Yes (L line) | As a column, if you include it |
| Transaction IDs | No | No |
Frequently asked questions
How do I convert QIF to CSV?
Drop the QIF file into the converter above, confirm the date format if asked, check the transactions, and download CSV or Excel.
Can I open a QIF file in Excel?
Not directly; Excel doesn't read QIF. Convert it to CSV or Excel here first.
Does it read Quicken's old date style?
Yes. Dates such as 1/ 5'26, 12/25' 6 and 2/10'2020 are read, along with normal MM/DD/YYYY dates.
Can I convert QIF to Excel?
Yes. Choose Excel before you download to get an .xlsx file with real date cells, number cells and filters on the header row.
Does the CSV keep my categories?
Yes. The QIF category of each transaction goes in a Category column. For split transactions, the main category is kept.
My QIF file has several accounts. What happens?
The converter lists them. Choose one account, download it, then choose the next.
Is my file uploaded?
No. It is read and converted in your browser.
Sample files
Made-up transactions you can download to see what each format looks like, or to try the converter. Open them in a text editor, or drop them into the converter above.
- Sample QIF file Quicken Interchange Format, bank account.
sample.qif
Related tools
Last updated · EmproIT