Importing Bill of Materials Data from a .CSV File

If you have a Bill of Materials in .csv format, you can import the data into the Bill of Material tab in the Table Manager.

You must properly format data in a .csv file to ensure it is added to the correct fields in the Bill of Material tab. SOLIDWORKS Inspection has three sample templates you can use to format data so it imports accurately:
  • BOM-All Fields Example.csv. Template of all BOM data (Part Name, Part Number, Part Serial Number, FAI Report Number, and Supplier Code). It includes a header row listing the field labels. You must delete the row with the field labels after import.
  • BOM-No Column Header part name.csv. Template with Part Number only.
  • BOM-Part Name & Number Example.csv. Template for Part Name and Part Number only.

To import bill of materials data from a .csv file:

  1. Open a BOM template.
  2. Enter data from the electronic BOM into the template.
    The data must match the field order in the template.
  3. Save the template as a .csv file.
  4. In the Table Manager, on the Bill of Material tab, click Import from CSV file .
  5. In the dialog box, select the template and click Open.
    The data appears in the Bill of Material tab.