Bulk Import Virtual Components

Hello All.

I have a question regarding virtual components in an assembly.

I'm trying to import components like wires, loctite , etc. into an assembly.

One way is to create every component as a virtual part and enter description for the assembly BOM. This is a very tedious task when it comes to hundreds of components.

Can all these components be imported via a spreadsheet with part number and description so that they show up in the assembly tree and also on the bill of materials in the drawing ?

SolidworksImport/export