CSV to QIF Converter
Turn a bank or credit card CSV download into a QIF file you can import into Quicken and other personal finance programs.
or click to choose one
No file handy? Try it with the sample CSV.
How to convert a CSV file to QIF
- Download your transactions from your bank's website as a CSV file. It is often labeled "Comma delimited", "Excel/CSV" or "Spreadsheet".
- Drop the file into the box above. The converter guesses which column holds the date, payee and amount.
- Check the column choices and the preview. The running balance makes mistakes easy to spot.
- Download the .qif file and import it into your finance program.
What is a QIF file?
QIF (Quicken Interchange Format) is a plain text format Intuit created for Quicken in the early 1990s. Each transaction is a short block of lines, one field per line, ending with a caret:
!Type:Bank D10/15/2026 T1850.00 PPAYROLL DEPOSIT MDirect deposit ^
D is the date, T the amount (negative for money out), P the payee, M a memo, N a check number and L a category. Because it is so simple, almost every personal finance program can read it, even though Intuit now prefers QFX.
Importing into Quicken
Quicken for Mac
Choose File > Import > QIF File, pick the file, choose the account to put the transactions in and review them before accepting. Back up your Quicken data before a large import.
Quicken for Windows
Choose File > File Import > QIF File. Recent versions of Quicken for Windows limit which account types accept QIF imports, and may not allow importing into an existing checking or credit card account. If Quicken refuses the file, a QFX file is the usual way around it.
Common problems with bank CSV files
- Extra lines above the header. Many banks put the account name and date range above the column names. The converter skips those and finds the row that starts the table.
- Separate withdrawal and deposit columns. Choose both columns in step 2 and leave Amount set to (none).
- Amounts like "(12.50)" or "12.50-" or "$1,234.56". These are all read correctly as numbers.
- Newest transactions first. The QIF file is written oldest first, which is how Quicken expects to see them.
- Day/month dates. UK, Canadian, Australian and European banks often write 03/10/2026 to mean 3 October. Check the date setting in step 2.
Sample file
The sample CSV looks like a typical checking account download: three lines of account details, then separate withdrawal and deposit columns with dollar signs and commas. Drop it in the box above to see how the converter handles it.
Frequently asked questions
- Is my bank file uploaded anywhere?
- No. The conversion runs in your web browser using JavaScript on this page. Your file is never sent to ConvertDepot or anyone else, and you can disconnect from the internet after the page loads and it will still work.
- Which programs can import the QIF file?
- Quicken for Mac, GnuCash, Banktivity, Moneydance and most other personal finance programs that accept QIF. Quicken for Windows only accepts QIF imports into some account types, so if it refuses, try a QFX file instead.
- My spending shows up as deposits. What happened?
- Some banks export purchases as positive numbers. Tick the Flip signs box in step 2 and check the preview again before you download.
- The dates came out wrong.
- Set the Dates in the file look like option to match your bank. Banks outside the US often use day/month/year. The converter guesses from your data, but a file with only early-month dates can look the same either way.
- Does it work with credit card downloads?
- Yes. Choose Credit Card as the account type. Charges should show as withdrawals and payments as deposits in the preview.
- Does it handle split transactions or investment accounts?
- No. It writes one line per transaction for checking, savings, credit card and cash accounts. Investment transactions need a different QIF layout.