The following are the official steps to import data from excel to quicken. However, if you still face any issues let me know and I will be glad to help. Thanks.
You can use the Import feature in Quicken Home Inventory to move your data from Microsoft® Excel (or any other program) if the file is in a Comma-separated or Tab-separated format. In Excel, these formats are referred to as comma-delimited and tab-delimited.
To import your data:
Source : http://quicken.intuit.com/support/help/reports--graphs-and-snapshots/how-do-i-import-data-from-excel-into-quicken-home-inventory/GEN82100.html