CSV to QIF Converter
Turn a bank CSV or Excel file into a QIF file for older Quicken versions and other money apps, right in your browser.
Drop your bank file here or choose a file
CSV, Excel, QBO, QFX, OFX or QIF · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert CSV to QIF
- Download a CSV from your bank Open the account's transactions on your bank's website and download them as CSV or Excel.
- Drop the file into the converter Choose the file or drag it onto the box above. It is read by your browser and never uploaded.
- Check the columns Confirm the date, description and amount columns. Map a category column if your file has one; QIF can carry categories.
- Review the transactions Fix or delete rows, and limit the dates if you need to.
- Choose QIF and the date format Pick the account type (bank, credit card or line of credit) and the date format. MM/DD/YYYY is the usual choice in the US.
- Download the QIF file Click Download QIF file and import it into your app.
How to import the QIF file
Back up your data file before importing. Menu paths are from each app's own documentation.
Quicken for Windows
- Create the account first The account you import into must already exist in Quicken.
- Open the QIF import Choose File › File Import › QIF File.
- Choose the file and account Set the location of the QIF file, pick the Quicken account to import into, choose what to include, and click Next.
Quicken's own help pages disagree on whether QIF can be imported into checking and credit card accounts. If Quicken doesn't list your account, use QFX or the Quicken CSV option instead.
Quicken for Mac
- Only for a new data file Quicken for Mac reads QIF only when you create a new data file (File › New, then start from a QIF file). It can't add a QIF file to an existing data file.
GnuCash, KMyMoney and other apps
- Use the app's QIF import For example, GnuCash has File › Import › Import QIF. Follow the app's steps and pick the account.
What a QIF file looks like
QIF (Quicken Interchange Format) is plain text. The first line names the account type, for example !Type:Bank
for a bank account or !Type:CCard for a credit card. Each transaction is a few lines that start with a letter:
D for the date, T for the amount (negative for money out), P for the payee, M for a memo, N for a check
number and L for a category. A line with only ^ ends the transaction.
Supported banks and file layouts
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.
Known layouts, picked automatically
- American Express card · Date, Description, Card Member, Account #, Amount, … 8 more
- Apple Card · Transaction Date, Clearing Date, Description, Merchant, Category, … 3 more
- Bank of America checking or savings · Date, Description, Amount, Running Bal.
- Bank of America credit card · Posted Date, Reference Number, Payee, Address, Amount
- Barclays credit card · Transaction Date, Description, Category, Amount
- Capital One 360 checking or savings · Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance
- Capital One credit card · Transaction Date, Posted Date, Card No., Description, Category, … 2 more
- Charles Schwab Bank checking · Date, Status, Type, CheckNumber, Description, … 3 more
- Charles Schwab Bank checking (older layout) · Date, Type, Check #, Description, Withdrawal (-), … 2 more
- Chase checking · Details, Posting Date, Description, Amount, Type, … 2 more
- Chase credit card · Transaction Date, Post Date, Description, Category, Type, … 2 more
- Citi credit card · Status, Date, Description, Debit, Credit
- Discover card · Trans. Date, Post Date, Description, Amount, Category
- Mercury transactions · Date (UTC), Description, Amount, Status, Source Account, … 9 more
- PayPal activity · Date, Time, TimeZone, Name, Type, … 11 more
- PNC checking or savings · Transaction Date, Transaction Description, Amount, Balance
- SoFi checking or savings · Date, Description, Type, Amount, Current balance, Status
- Square transactions · Date, Time, Time Zone, Gross Sales, Discounts, … 44 more
- Stripe balance report · balance_transaction_id, created_utc, available_on_utc, currency, gross, … 4 more
- USAA checking or savings · Date, Description, Original Description, Category, Amount, Status
- Venmo statement · ID, Datetime, Type, Status, Note, … 16 more
- Wells Fargo · 5 columns, no header row
Each layout was checked against the bank's own help pages or real sample files. If your bank changes its layout, the converter still reads the file by its column names.
Common problems and fixes
- Dates are read the wrong way round
- QIF files can't say whether 03/04/2026 is March 4 or April 3. Choose the date format your app expects (MM/DD/YYYY for US Quicken). The converter writes 4-digit years to avoid century mix-ups.
- Transactions are duplicated after a second import
- QIF has no transaction IDs, so most apps can't tell if a transaction is already there. Import each file once, and start each new download the day after the last one.
- Accented letters look wrong
- The QIF file is written as Windows-1252 ("ANSI") text, the character set older Quicken versions expect. Plain letters and numbers are the same in any character set.
- Quicken won't import into my checking account
- Quicken's help pages disagree on which account types accept QIF. Use the CSV to QFX converter (QFX or Quicken CSV) for checking, savings and credit card accounts.
CSV vs QIF
| CSV | QIF | |
|---|---|---|
| What it is | A table: one row per transaction | Text records, one line per field, each record ending with ^ |
| Account type | Not stored | In the header line (!Type:Bank, !Type:CCard…) |
| Categories | Only if you add a column | Yes (L line) |
| Transaction IDs | Only if you add a column | No |
| Read by | Spreadsheets and most apps | Quicken (with limits), GnuCash, KMyMoney and many others |
Frequently asked questions
How do I convert CSV to QIF?
Drop the CSV into the converter above, check the columns and transactions, choose QIF and the date format, and download.
Which apps can import QIF?
Many personal finance apps, including GnuCash and KMyMoney. Quicken for Windows imports QIF with File › File Import › QIF File; Quicken for Mac only when starting a new data file.
Should I use QIF or QFX for Quicken?
For checking, savings and credit card accounts in current Quicken, QFX (or Quicken's own CSV import) is the safer route. Quicken calls QIF a legacy format.
Can I keep my categories?
Yes. Map your category column in step 2 and each transaction gets an L (category) line in the QIF file.
Which date format does the QIF file use?
MM/DD/YYYY by default. You can choose DD/MM/YYYY or a two-digit year before you download.
Is my file uploaded?
No. The CSV 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 CSV A bank CSV with debit and credit columns.
sample-bank-statement.csv - Sample QIF file Quicken Interchange Format, bank account.
sample.qif
Related tools
Last updated · EmproIT