NEW – Multi-level BOM import from a single spreadsheet

Oleg Shilovitsky
Oleg Shilovitsky
6 July, 2019 | 1 min for reading
NEW – Multi-level BOM import from a single spreadsheet

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 list with numbers (levels) into OpenBOM Multi-level BOM? Our new import feature is going to solve this specific problem

It is enough to have your levels numbered as I show below and OpenBOM will create such a structure.

1.

1.1.

1.2.

1.2.1.

1.2.2

And this is what you will get in OpenBOM

The following short video demonstrates this feature. 

Conclusion

Very simple and powerful feature. You can simply convert many flat lists with pseudo-structure levels columns to true structured records of Bill of Materials. 

Check OpenBOM tomorrow by registering to OpenBOM FREE user subscription. And forget about your BOM spreadsheets.

Best, Oleg

PS. Let’s get to know each other better. If you live in the Greater Boston area, I invite you for a coffee together (coffee is on me). If not nearby, let’s have a virtual coffee session — I will figure out how to send you a real coffee.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Related Posts

Also on OpenBOM

4 6
23 April, 2024

Last year, we introduced a new service – OpenBOM Design to enhance OpenBOM’s capabilities to manage files. The goal of…

20 April, 2024

The development of seamless integrations with different design and engineering systems is one of the fundamental core values of OpenBOM….

19 April, 2024

To gain a competitive advantage, companies often look to how they can reduce their production costs by exploring low-cost sourcing…

19 April, 2024

In today’s fast-paced digital landscape, where data becomes a new oil, the concept of a Single Source of Truth (SSOT)…

17 April, 2024

In the modern landscape of engineering and manufacturing, the concept of Digital Thread stands as a foundational pillar of Digital…

16 April, 2024

In the space of modern industrial operations and manufacturing, the quest for efficient CAD data management, streamlined BOM management, and…

12 April, 2024

Culture eats strategy for breakfast, technology for lunch, and stays hungry for dinner. The manufacturing industry is getting more complex,…

12 April, 2024

Choosing the right contract manufacturer (CM) is an important decision for anyone launching a new product. The quality of your…

11 April, 2024

In the world of woodworking, but not only, you can face fractional units. When working with Autodesk Fusion 360, integrating…

To the top