What is a QIF file and why do you need one?
Managing your finances is easier when your tools work together. Banks usually hand you a CSV export, while Quicken, MS Money, and similar apps expect QIF. Closing that gap by hand every month wastes time.
CSVall's free CSV to QIF converter closes that gap in seconds. Upload your CSV, map your columns, and download a clean QIF file ready to import. No registration and nothing to install.
QIF stands for Quicken Interchange Format — a structured text format that programs like Quicken, Microsoft Money, and GnuCash use to import transactions.
Banks almost always export history as CSV. CSV is universal, but your finance software does not import it natively. You convert CSV to QIF first, then import cleanly.
Without a reliable converter you risk manual entry, paid desktop tools for a one-off job, or broken imports. CSVall translates your sheet accurately so you can focus on your books.
Who uses a CSV to QIF converter?
Personal finance users
You track spending in Quicken and want monthly bank exports in QIF without buying extra software.
Small business owners
You reconcile in MS Money or GnuCash using CSV files from your bank or payment processor each month.
Accountants and bookkeepers
You juggle clients at different banks and need a fast, repeatable conversion workflow.
Freelancers and contractors
You import expenses and income quickly at tax time with Quicken or similar tools.
Mac and Windows users
CSVall runs in the browser on any operating system — no app install required.
CSV to QIF vs QIF to CSV
This page converts CSV to QIF. Need the other direction? Use our QIF to CSV tool to analyze transactions in Excel or Google Sheets. QIF to CSV converter.
CSV to QIF turns a bank spreadsheet into an import file for Quicken, MS Money, GnuCash, or any QIF-compatible program. See also our CSV to QBO converter and CSV to PDF converter.
QIF to CSV exports accounting data to a flat spreadsheet for sorting, filtering, and charts.
Why CSVall beats other CSV to QIF converters
- Flexible column mapping — you choose which column is date, amount, payee, and memo, so any bank export works.
- Handles messy real-world CSV: extra header rows, stray spaces, mixed date formats, and special characters.
- Typical monthly statements convert instantly without artificial limits.
- Nothing leaves your device — conversion runs in the browser with no server upload.
- Works on Windows, Mac, iPhone, and Android without installing an app.
- Truly free — no paywall for basic conversion.
Supported accounting software
Quicken (including Mac and Home & Business), Microsoft Money, GnuCash, Moneydance, iBank/Banktivity, MoneyWorks, Personal Finance for Windows, and any app that supports QIF import.
Understanding the QIF file format
Each transaction uses short codes: D for date, T for amount, P for payee, M for memo, and ^ to end the record. CSVall maps your columns to these codes automatically.
!Type:Bank D01/15/2025 T-250.00 PSuper Grocery Store MShopping expenses ^
Tips for a perfect CSV to QIF conversion
- Remove summary or total rows from your CSV before converting.
- Match the date format dropdown to what you see in the raw file.
- Use negative amounts for debits; flip the sign if your bank does the opposite.
- Enable 40-character payee trim when targeting older Quicken versions with long merchant names.
- Convert one month first, import it, then scale up to larger files.
Privacy and security
Your CSV is processed in your browser with JavaScript. Content is not stored, logged, or sent to our servers. Close the tab and no trace of your file remains with us.
Common problems and fixes
Wrong dates after import
Re-check the date format setting and peek at raw values in Notepad or a text editor.
Wrong amount sign
Debits should be negative and credits positive. Use the sign flip control or fix amounts in the CSV first.
Corrupted payee characters
Save the CSV as UTF-8 before uploading.
Duplicate transactions in Quicken
Trim overlapping dates from your CSV so you do not import rows already in the register.
Extra header rows
Delete rows above the real column headers in Excel or Sheets, save, and upload again.