Step 1 – Import From a List of Products
Inside your BOM table, click Import Products.
Select where the data is coming from:
List of Products → Quote, fixture schedule, Excel/PDF list
Existing Submittal Package → An existing lighting package with datasheets
Existing Parspec BOM → Copy products from another project inside Parspec
Select the Section you want these products placed in.
You can select an existing section or create a New Section.
Upload the file (PDF or Excel) or select from existing Project Files
💡 Tip: If selecting Existing Parspec BOM, choose the Project and BOM, then hit Confirm – it will create a carbon copy of the BOM.
Step 2 – Select Products from the Uploaded List
Once the pdf loads, click Confirm Import.
Now automatically selected you'll see a blue highlight over the fields you want to import (manufacturer, model, type, quantity…).
Click Include or Exclude to adjust the selection.
💡 Tip: You can use the blue dots to expand the highlight to cover additional fields
Step 3 – Review & Reassign Columns
Review the Column Mapping tab and Product View
To assign or reassign what a column is mapped to:
Click the downward arrow on the header in Column Mapping
To edit default Section names or create a lot, click into the Product View to review the imported lines
💡 Tip: Any columns in orange will be imported to your BOM and edits such as deleting lines, creating kits, or assigning lots can be included in the Product View
How to Upload a Product List
Easily streamline your BOM creation process by uploading product lists. Follow the steps below to bring in data from multiple sources.
Written by Ni Nguyen
Updated over a week ago