Format converter

Free CSV to QIF Converter for Quicken

Runs entirely in your browser — your file is never uploaded to a server.

100% private
Never uploaded
Instant
Runs in your browser
CSV & Excel
Real spreadsheet output
No signup
No account, no card
Convert a CSV to QIF

Drop your file below — runs entirely in your browser, nothing is uploaded.

Drag and drop your CSV file hereor click to browse your files CSVQIF

Only have a PDF statement? That converts too.

A CSV file means your bank gave you structured data — which most banks only do for the last few months. Beyond that you get a PDF, and a PDF won't open in Excel. BalanceExtract reads those directly: it works out the column layout from the document itself, handles scanned statements with OCR, checks that every running balance reconciles, and flags any row it isn't confident about before you export.

Same QIF output, same on-device processing, nothing uploaded.

Convert a PDF statement6 pages free, no signup, no card

How to convert CSV to QIF in 3 steps

Step 1: Drop in your CSV file

Drag the file onto the box above or click to browse. It is read in your browser — nothing is uploaded to a server, which you can confirm in the Network tab.

Step 2: Check what was found

Every transaction is read out with its date, payee, description, amount and transaction ID, along with any warnings about rows that need a look.

Step 3: Download the QIF

The QIF file saves straight to your device, ready to open in a spreadsheet or import into your accounting software.

QIF is one of the oldest personal-finance file formats still in active use — a plain-text, line-based structure where each transaction is a short run of prefixed lines ending in a bare "^". Quicken still imports it directly, and it's the only one of Quicken's three import formats (QIF, QFX, OFX) that actually preserves categories and split transactions.

Quick summary

Getting a bank statement into Quicken without losing your categories, or retyping them back in afterward, is the real reason to pick QIF over the alternatives. QIF beats QFX and OFX for one real reason: it's the only format that carries category and split data into Quicken. This converter reads any CSV with a date, description, and amount column, handles Quicken's real apostrophe-year date shorthand (1/15'26), and outputs a clean QIF file — without inventing categories a plain bank CSV never had to begin with.

What's Inside a QIF File

Field codeWhat It Contains
DTransaction date
TAmount
PPayee
MMemo
^End-of-record marker

What This Converter Doesn't Do

Frequently Asked Questions

Why QIF instead of QFX or OFX for Quicken?
QIF is the only one of the three that carries categories, subcategories, and split transactions — QFX and OFX don't include category data at all. That said, a plain bank statement or CSV usually doesn't have category data to begin with, so this converter outputs QIF without categories unless your source CSV already has one.
What software reads QIF files?
Quicken (Windows and Mac), Banktivity, MYOB, YNAB, GnuCash, and many older or lightweight accounting tools.
How do I import the QIF file into Quicken?
File > File Import > QIF File in Quicken, then select the file and choose the account to import into. On Quicken Mac specifically, QIF import creates a new account rather than adding to an existing one.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser — nothing is sent to a server.
Related articles

How BalanceExtract compares

Honest side-by-side write-ups, including where each of them is the better choice.

Other converters