Importing a BOM spreadsheet

Follow these three steps to import an Excel spreadsheet into openBoM:

  1. Format your excel spreadsheet so that all information starts on row six (6).  Note – you should have “Part Number” column in your BOM.
  2. In the openBoM Dashboard, click the “Tools” button and select “Import BOM from spreadsheet” from the drop-down menu.  Choose your desired spreadsheet from your PC or Mac when prompted. 
  3. The imported Excel will appear in the Dashboard.  Click it and you are ready to work in openBoM.

Download a pre-formatted Excel template by clicking, here.

Watch this video to see these steps in action: