1. Navigate to Parts>>Reports>>Component Need Across BOMs
2. Click "Choose File" and select your Excel file.
3. Your file should have the BOMs listed, and the quantity you want to make out of each BOM.
4. Click "Show Components." You will see the parts used on the BOMs you imported and the qty needed across all BOMs.