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
8 May, 2024

Setting up a data management and collaboration environment is not a simple task. It requires some planning, system settings, and…

7 May, 2024

The modern engineering and manufacturing environment is super collaborative and demands everyone to be connected and be able to manage…

3 May, 2024

Effective communication with any partner, including your manufacturing partner, is the key to success. If you have clear communication then…

2 May, 2024

Engineering disciplines are hard and demand complex data structures and techniques to manage them. At OpenBOM, we don’t believe in…

2 May, 2024

We continue the set of publications about key enhancements of OpenBOM in the way we allow to manage design projects…

1 May, 2024

In today’s rapidly evolving landscape of engineering and manufacturing, the seamless integration of design data is critical for the efficiency…

30 April, 2024

In today’s rapidly evolving landscape of digital design and PLM, efficiency, collaboration, and seamless integration are critical to achieving seamless…

26 April, 2024

Selecting the right manufacturing partner is a critical decision that can significantly impact the success and sustainability of your business….

26 April, 2024

In my article today, I’d like to explore the seamless integration of OpenBOM and Autodesk Fusion 360. In the dynamic…

To the top