The ugly fact is that most companies have BOMs and/or Catalogs (inventories) stored in Excel. OpenBOM has a variety of features to help you import and export this information directly to OpenBOM. This section will take you through:
The process for creating a BOM or Catalog from an existing Excel is almost identical. A small amount of preparation can greatly improve this experience. Fortunately, OpenBOM can process either a formatted or unformatted Excel.
Here’s a quick video that walks you through the process.
A few things to consider when importing from Excel:
From the OpenBOM Dashboard, click the “Import” button and select “Import BOM from spreadsheet” (or import catalog) from the drop-down menu.
Select your spreadsheet file as shown below by clicking “Select File” and choosing your .xls or .xlsx file.
For a properly formatted Excel, the defaults below will work.
Here is what a properly formatted Excel file looks like to create a BOM.
Once the dialog is complete – Click “Import” and your BOM or Catalog will be created.
If OpenBOM encounters and formatting issues the following message will be displayed. In this example, our Excel file header was on tow 6 and our part number property is named “PN”.
Correct the values for property row or part number name as needed and try again:
Download a pre-formatted Excel template below:
Excel Template for Import to openBoM
NOTE: please read this carefully, it is possible to delete existing data which cannot be recovered using this command.
Once you have created a new BOM or Catalog (often referred to as documents in OpenBOM) from an existing Excel spreadsheet you may have a need to update the original Excel (for example, if it is the output from an ERP system or likewise). Of course, you will any changes to the Excel to be reflected in your OpenBOM document.
The update process involves re-importing the revised Excel into where OpenBOM will automatically update your BOM or Catalog with any changes made to the Excel. This process is formerly called “Merging”.
It is important to understand exactly what Merging does. OpenBOM using the following rules to determine which data is preserved during the merge:
CAUTION: Importing to an existing BOM will overwrite the existing BOM with the imported BOM. Be careful – item #1 just above states that an item will be DELETED if it does not exist in both the OBM ad the new import.
The UI for importing into existing BOM is here:
Here is a short video on merging changes from an existing Excel into an existing OpenBOM catalog.
Sharing is caring!