Importing Parts to Project

Is there a way to generate multiple components and add manufacturer parts to them to begin a project? We typically have a list of parts that will be used in a project when the project is handed off to our engineering department. We would like to be able to add all the parts in that list to a project so that the designer can insert their symbols to make the schematic. Can this be done using excel automation? Or is there another way to do this?

Thanks for your help.

SolidworksElectrical