Convert QDF to CSV

People usually need this conversion to analyze Quicken transactions in Excel or Google Sheets, import them into another accounting system, or create a portable text archive. The dependable method is to open the file in Quicken and export the required account or report as CSV.

What the QDF format is

QDF is the native data-file format used by Quicken for Windows. It is a proprietary database containing accounts, transactions, categories, payees, budgets, securities, and relationships between financial records. Quicken backup files normally use the .QDF-backup extension; renaming one to .QDF does not convert it, so restore it through Quicken.

QDF is not a spreadsheet or a plain-text table. A single CSV export cannot preserve every Quicken feature, and Quicken for Mac does not generally open a Windows QDF file by simply changing its extension.

What the CSV format is

CSV is delimited text arranged in rows and columns, commonly with commas separating fields and one transaction per row. Excel, Google Sheets, databases, reporting applications, tax tools, and many accounting systems can import it without Quicken.

CSV is suitable for filtering, sorting, reconciliation, analysis, and compact text-based storage. It does not retain Quicken account hierarchies, budgets, attachments, memorized transactions, investment lots, reconciliation metadata, or links between transfers and related records.

How to export QDF data as CSV

1. Copy the original .QDF file and work from the copy. Open it in Quicken for Windows; allow Quicken to validate, convert, or update the file if prompted.
2. For one account, open its register and set the required date range. For several accounts, open or create a customized report and select the accounts, date range, transaction types, and columns to export.
3. Check the displayed transactions and report totals before exporting. Review split transactions and transfers because a flat export may not show their relationships clearly.
4. Use the report's Export or Export Data command, or the applicable File → Export command, and choose CSV or comma-separated text. The exact menu name differs between Quicken editions and releases.
5. Save a descriptive file such as checking-2025.csv. Open it in a plain-text editor first, then in the destination application, and verify the headers, row count, dates, amounts, payee names, and balances.

Some Quicken releases export account data directly; others provide CSV export mainly through reports. If the register has no CSV option, create a customized transaction report and export that report. Exporting to an Excel workbook first and then using Save as → CSV is a fallback, but inspect the result because spreadsheet software can change date formats, leading zeros, long identifiers, and numeric precision.

Quality and compatibility limitations

Confirm the destination system's required column names, date convention, decimal separator, delimiter, and text encoding before importing. Regional settings can produce semicolon-delimited output or locale-specific dates and decimal values instead of comma-delimited, US-style data.

Use UTF-8 when the export or destination offers that choice so accented and non-English names remain intact. Check negative amounts, currency symbols, blank values, duplicate headers, and quoted commas in payee or memo text. Do not assume that a spreadsheet's visual formatting represents the underlying CSV values.

Exports can omit split-line detail, transfer matching, reconciliation status, investment cost basis, security prices, attachments, and other Quicken-specific metadata. Export separate reports when the destination needs both transaction-level and split-category information, and reconcile totals manually after import.

Generic online QDF converters are not a suitable alternative. QDF is proprietary, Quicken files may contain account numbers and other private financial information, and a web service may not understand the file's internal relationships. No online service should be used unless it explicitly supports the exact Quicken file variant and the file contains no confidential data; Quicken desktop export is the safer option.