The long answer is that you have to first convert the csv to a qif and then tweak and import the qif file. There used to be (havenot checked recently) a free download out there that would do the Excel csv to qif conversion. It was here:
One comment about YirehBiz steps for using XL2QIF and ImportQIF (the "QuicknPerlWiz utility").
XL2QIF has an "Auto import" option. What this really does is after the converting of the data to a QIF file it tells Windows to open the file, and the program that is registered to use QIF is started with the QIF file as an argument.
What this all means is if you install ImportQIF and allow it to be the registered QIF handler and you select "Auto Import", once you press the Convert button in XL2QIF, ImportQIF will run with your QIF file already loaded and ready for you to press one button to complete the operation, instead of having to browse for the QIF file.
I stumbled upon an even easier approach to importing the QIF file format to accounts that Quicken does not allow directly, such as checking and savings accounts (Quicken Home & Business 2010).
1. Create a "Cash" account and use a name that you'll recognize. E.g.; "Import Checking". 2. Download the QIF file. 3. Import the QIF file into the target "Import..." cash account. 4. Open the "Import..." account and select transaction(s). 5. Right click and select "Move transaction(s)", then select the correct account from the pull down list and click OK. You should here the multiple "Cha-ching!" as each transaction is moved.
***Note: Select multiple transactions by holding the Shift key and clicking on the transactions you want moved. Clicking on a transaction at the top of the ledger, then holding Shift and clicking on the bottom transaction in a range will select all transactions in between the two.