Excel (or spreadsheets) is one of the greatest inventions of IT for the last decades. Flexible, powerful and easy to use. But, it brings too many problems when it comes to engineering and product data management. In my Do’s and Don’ts of Escape Plan from Excel, I shared my recommendation on how you can move…
Best practices of Import BOM or Catalog to OpenBOM from your existing spreadsheet The things are rarely happening in the vacuum. Usually, you have already a bunch of data in spreadsheets you want to bring to OpenBOM to keep managing or using this data in the future. What are the most typical use cases? Over…
We’ve been getting many requests to expand OpenBOM integration with Google Sheet. I’m happy to share some early information about OpenBOM import from Google Sheet coming in the next release (yay!!!). So, let’s say, I want to import BOM from the following Google Sheet The first function will integrate Google Sheet file picker from OpenBOM import…
Another cool new feature coming soon in OpenBOM. Many of you asked us how to transform your existing BOM spreadsheets into nested structure Bill of Materials. For many companies, the structure like I show on the image before is a very typical way to store and manage Bill of Materials. How to transform this flat…