CSV converter Options

CSV converter Options

Output format — QIF or OFX?

The converter produces two output formats. Which one you need depends on your accounting software:

  • QIF (Quicken Interchange Format) — an older but very widely supported format. Compatible with Quicken, MS Money, GnuCash, Moneydance, MoneyWorks, KMyMoney, and most desktop accounting applications. QIF is a plain-text format and is human-readable.
  • OFX (Open Financial Exchange) — a more modern format based on a structured markup language (similar to XML). Supported by Quicken 2005 and later, MS Money, iBank, and most online accounting tools. OFX carries more detail (such as a running balance and transaction IDs) and is preferred when your software supports it.

If you are unsure, try QIF first — it is accepted by almost every desktop accounting package.

Loose mode vs Strict mode

This setting controls how long field values are allowed to be in the output file:

  • Loose (recommended for most users) — the full content of each field is preserved exactly as it appears in your CSV. Description and payee names can be as long as your CSV contains. Use this unless you experience import errors.
  • Strict — the payee and category fields are truncated to 32 characters, and the memo field to 249 characters. This matches the limits defined in the original QIF specification from the 1990s. Some older versions of Quicken and MS Money enforce these limits strictly and will reject or garble entries that exceed them. If you are using an older version of Quicken (pre-2010) or MS Money, try Strict mode if imports fail.

Export transactions with Amount = 0

When ticked (the default), rows where the amount is zero are included in the output. Untick this if your CSV contains fee-free or informational rows with no monetary value that you do not want to import.

Delivery method

  • Download — the converted file is downloaded directly to your computer when you click the button.
  • Email — the converted file is sent to the email address you specify. Useful if you are converting on a mobile device and want to open the file on your desktop.