We have our BOM made in Excel and instead of spending 2 days (atleast) making new tables in multiple sheets, I would rather import the entire excel sheet as a large table and sort it into multiple drawing sheets. As an end result, I will be saving as a .dwg and loading into draftsight to send to a customer who uses AutoCAD. Anyone know if this is possible?

My plan would be:

1. Load large table from Excel into a new SolidWorks Drawing file and saving as a DWG/DXF.

2. Open this with DraftSight.

3. Sort the tables into different pages in DraftSight before sending to customer.

Any ideas on how to do step 1?