01 / Fast steps
- Drop or select the .qif file.
- Sections and records are parsed, dates normalised, amounts read as numbers.
- Download the CSV and open it anywhere.
QIF to CSV Converter
Drop a .qif file, the format Quicken and many older finance programs exported for decades, and get a CSV with one transaction per row: date, amount, payee, category, memo. Years of financial history stop being trapped in a format nothing modern opens, and none of it leaves your browser.
drop your files anywhere in this area
Your files never leave your device. This tool even works offline.
QIF
02 / Best for
- Recover transaction history from an old Quicken, Microsoft Money or MS-DOS era finance archive.
- Move years of records into Excel or Google Sheets for analysis.
- Prepare old data for import into a modern app that accepts CSV but not QIF.
- Read what a QIF file actually contains before trusting an import.
03 / Why here
- Understands the whole line-oriented QIF structure: sections, records, dates, amounts, payees, categories, memos, check numbers and cleared flags.
- Day-first and month-first dates are told apart by scanning the entire file for a row that settles the question, not by assuming your locale.
- Amounts in both American (1,234.56) and European (1.234,56) writing come out as plain numbers.
- Runs offline once the page is loaded: financial history never reaches a server.
04 / Keep in mind
- Investment sections carry positions rather than simple transactions; their basic fields are exported but security-specific ones are not.
- QIF has no account identifiers inside records, so multi-account files rely on their section headers, which the CSV preserves in an Account type column.
Tool connections
Related tools
Just converted a file here? Click a tool that reads it and your new file is handed over automatically, no re-upload needed.
01CSV to ExcelConvert CSV files into Excel XLSX spreadsheets ready to open, sort and format.02CSV to OFXTurn the CSV your bank exports into an OFX statement that GnuCash, YNAB and Quicken import cleanly, entirely in your browser.03Excel to CSVConvert Excel spreadsheets (XLSX, XLS) to CSV files, one per sheet, entirely in your browser.04OFX to CSVTurn OFX and QFX bank statements into a clean CSV you can open in Excel, without the statement ever leaving your browser.05Make an E-Invoice ReadableTurn a signed or plain Italian e-invoice into a PDF you can actually read, keeping the XML original alongside it.06HEIC to JPGConvert iPhone HEIC photos to JPG files that open on Windows and everywhere else, right in your browser.
Good to know
Questions & answers
01What is a QIF file?
QIF (Quicken Interchange Format) is the text format Quicken introduced in the late eighties to move financial data between programs: sections opened by a !Type header, one field per line keyed by its first letter (D for date, T for amount, P for payee), records closed by a caret. It was replaced by OFX around 2000 because QIF has no transaction IDs, which makes duplicate detection impossible, but decades of archives still exist in it.
02Why do dates in old QIF files look strange?
Quicken wrote dates in the local convention of the machine, sometimes with an apostrophe separating the year, like 5/13’24. Whether 5/13 means May 13th or is impossible depends on day-first versus month-first writing. This converter scans the whole file first: a single date with a component above 12 settles the convention for every row, which is far safer than assuming a locale.
03Is my financial data uploaded to convert it?
No. The file is parsed by JavaScript in your browser tab and the CSV is written straight to your disk. It works offline once the page is loaded. Old finance archives are complete pictures of years of life, which is exactly why this tool has no upload step.
04Can I import the resulting CSV into modern accounting software?
Usually yes, most apps import CSV, but be aware of what QIF lacks: there are no unique transaction IDs, so importing overlapping periods twice can create duplicates. If your target app accepts OFX, a cleaner path is converting the CSV again with the CSV to OFX tool, which generates stable IDs precisely to make re-imports safe.
05Is QIF to CSV free?
Yes, completely free, with no sign-up and no limits. It runs in your browser, so your files never leave your device.
06How do I get QIF transactions into Excel?
Convert the QIF here and you have a CSV that Excel, Google Sheets and LibreOffice open directly. If you prefer a real spreadsheet file with typed columns over plain text, run the CSV through the Excel converter and download an .xlsx. CSV XLSX
07My bank offers both QIF and OFX. Which one should I export?
OFX, whenever you have the choice: it is the newer format and it carries structured fields the QIF era never standardised, currency, account identifiers and unambiguous dates, so it survives the trip between tools with fewer surprises. QIF is the right pick only when it is the only thing the bank offers. Both convert to CSV here. OFX CSV