More articles

Import Excel into Quicken

Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2017 does not provide import for CSV, TXT, XLS, XLSX (Excel) files. How to import Excel into Quicken? You can easily convert Excel files into one of the following formats and then import converted files.

How to import an Excel file into Quicken

Convert Excel to QIF

CSV2QIF supports direct import from Excel (XLS or XLSX) files.

But Quicken 2005-2017 does not allow QIF files to be imported under checking, savings, credit card, broker, and investment accounts, right? Not exactly. There are different QIF file variations. QIF created for MS Money, or provided for download by your bank are not accepted by Quicken unless you import them under a cash account.

However, CSV2QIF creates QIF files for Quicken, and Quicken does accept these files. In fact, all Quicken versions for Windows (up to Quicken 2017) import QIF files just fine under checking, savings, credit card, broker, and investment accounts.

Where is the catch then? The catch is that you need to enter the account name in CSV2QIF exactly as you have it Quicken, otherwise during QIF import, Quicken will try to create a new account with that name. For example, if your checking account in Quicken is called “Checking” or “Bank checking” or another name, you need to enter this name exactly in CSV2QIF (as well as select correct account type) before saving a QIF file.

What is the advantage of using QIF files? Quicken does not require “online call home” during the import. You do not need to have an Internet connection active, and firewall enabled for Quicken to go through to import a QIF file. This can come quite handy when you work and travel and do not have the Internet always on, but need to complete your finance report on time.

Another advantage? Creating investment transactions becomes quite easy when you are comfortably working in Excel, then copy and paste them in CSV2QIF and import QIF into Quicken.

So when QIF is not good? For Quicken For Mac 2015-2017 or Quicken Essentials for Mac. This Quicken variants do not allow QIF files at all. Please see the next paragraph on how to import your CSV into Quicken including Quicken for Mac 2015-2017 and Quicken Essentials for Mac.

Quicken for Mac 2007 is special case and it does import QIF files.

Convert Excel to QFX (Web Connect)

Convert Excel to QFX (Web Connect) using CSV2QFX. CSV2QFX creates QFX files acceptable by Quicken. CSV2QFX covers bank (checking and savings, credit line and credit card accounts. During QFX import, Quicken ‘calls home’ using Internet connection (so please make sure your firewall allows it to go through), and assigns bank details supplied in QFX file with selected account in Quicken. Even more, if Quicken finds the match for bank details in the QFX to details with an account, it imports data there automatically. Otherwise, if offers you the import dialog to select existing “unlinked” account, or create a new one.

CSV2QFX supports direct import from Excel (XLS or XLSX) files.

QFX format supplies unique id for each transaction and Quicken uses it to avoid import for the same transaction next time. However, when you prepare your CSV file, it is common you may notice some transactions errors, so you need to fix them and import the file again. Even if you deleted the transaction in Quicken, it still refuses to import it the second time.

To deal with your need to import corrected transactions again, CSV2QFX allows creating unique transaction IDs every time you save the QFX file (this option is turned on by default), as well as keep transaction IDs consistent if you need them to be this way.

Related articles for: