Convert a bank CSV to QIF

QIF is a simple, old text format that many personal-finance programs still import. Convert your bank CSV or Excel export to QIF on your own device.

Runs 100% in your browser
No sign-up
Free for 10 transactions per file
Pro: $29 one-time

Drop your bank CSV or Excel (.xlsx) file here or click to choose a file. It is read by your browser and never uploaded.

1. Check how the file was read

Delimiter Header row (0 = no header) Date format in file Decimal separator Flip sign (money out ↔ money in)

Columns

Use either one signed Amount column, or separate Debit and Credit columns.

2. Review transactions

	Date	Description	Amount	Check #	Balance

3. Account details (written into the file)

Account type Account number (or any unique ID) Routing number / bank ID Currency INTU.BID (QBO/QFX only) Bank name (optional) Dates in QIF/CSV output

Use a different account number for each real account, and the same number every time you convert that account. QuickBooks and Quicken use it to recognise the account. See what INTU.BID means.

4. Download

Pro ($29 one-time): coming soon

The output follows the standard Web Connect (QBO/QFX) and OFX formats and has been checked with independent OFX parsers. Try the free 10-transaction export in your software before buying Pro ($29 one-time). If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. Refund policy

How to import a QIF file

Quicken for Windows

Convert your file above and click QIF. Keep the QIF date setting on MM/DD/YYYY for US and Canadian Quicken.
Back up your Quicken data.
Go to File → File Import → QIF File.
Choose the account to import into, select the file, make sure Transactions is ticked, and click Import.
Check the register. QIF imports skip Quicken's review and matching step, so look for duplicates.

GnuCash and other apps

In GnuCash use File → Import → Import QIF and follow the wizard. It asks you to confirm the date format and to map the QIF account to a GnuCash account.

QIF vs QFX/OFX

QIF has no transaction IDs, so apps can't reliably detect duplicates, and current Quicken versions don't apply renaming rules or memorized payees to QIF imports. If your app accepts QFX or OFX, use that. QuickBooks generally does not import bank transactions from QIF; use the QBO converter instead.

FAQ

Which date format should I choose for QIF?

US and Canadian Quicken expect MM/DD/YYYY. For UK/EU apps that read DD/MM/YYYY, change "Dates in QIF/CSV output" before downloading.

What account types are supported?

Bank accounts (checking, savings, money market) are written as !Type:Bank and credit cards as !Type:CCard.

Are categories included?

No. Bank CSVs rarely carry categories that match your app's list, so assign them after import.

Is my bank file uploaded anywhere?

No. The page reads the file with your browser's built-in file APIs and builds the output on your device. There is no server-side code: you can open your browser's developer tools, watch the Network tab while converting, and see that no file data is sent. See the privacy page.

Is it free?

Yes for up to 10 transactions per file in every format, with full preview and editing. Pro removes the limit for $29 one-time. Try the free export in your software first. If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. See the refund policy.

QuickBooks and Quicken are trademarks of their respective owners (Intuit Inc. and Quicken Inc.). This site is independent and is not affiliated with, endorsed by, or sponsored by Intuit or Quicken. Product names are used only to describe file compatibility.