Import into Quicken through QIF format (all Quicken versions are supported) or QFX format (all Quicken versions are supported until they are three years old). There are some differences with QIF and QFX import (see below).
Use CSV2QIF to convert CSV, Excel (XLS, XLSX), TXT to QIF and import into all Quicken versions
Use OFX2QIF to convert OFX to QIF
Use QFX2QIF to convert QFX (Web connect) to QIF
Use Bank2QIF to convert OFX, QFX, QBO, QIF, QBX, OFX to QIF
Use QBO2QIF to convert QBO to QIF
Here is a short video (9 min) showing whole process of converting a CSV file to QIF format and importing into Quicken:
Use CSV2QFX to convert CSV, Excel (XLS, XLSX), TXT to QFX and import into Quicken
Use OFX2QFX to convert OFX to QFX
Here is a short video how to convert an OFX file to QFX format and import into Quicken:
QIF format supports categories (and subcategories) and tags, and QFX does not (Quicken offers the renaming rules feature to assign the category during import
QIF formats for Quicken, Microsoft Money and other software are different by their structure. ProperSoft converters allow to create different QIF variants by selecting the QIF target value.
QIF import into Quicken is not “officially supported” by Quicken support. Regardless of the support, QIF files import quite well for all account types. Simply follow the instructions provided on the converter help page, and your data will be imported.
QFX format creates “online services link” to account ID values provided on the QFX files. Make sure to enter different account IDs when converting QFX files for different accounts.
Overall, QIF format is somewhat easier to import than QFX (truly based on our experience).
QFX format can be imported by Quicken Essentials for Mac
Related articles for: