There is already a free Excel add-in that will convert a .csv file to a .qif file: it's called "xl2qif"; it's available online and it's free. Google will find it.
All you have to do is have Excel open (or import) the .csv file; then have xl2qif format the excel data in qif format and create a .qif file.
Then, if necessary, you can use the following instructions to insure the .qif file can be imported into Quicken: