Follow these three steps to import an Excel spreadsheet into openBoM:
- Format your excel spreadsheet so that all information starts on row six (6). Note – you should have “Part Number” column in your BOM.
- 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.
- 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: