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
1 November, 2024

Managing the details of every part, component, and material involved in product development is both a challenge and a necessity....

1 November, 2024

Data management in today’s digital age is absolutely important to help your business to thrive and not die. The “garbage...

30 October, 2024

It was a pleasure to be part of Autodesk University 2024. I presented on a subject I’m passionate about: Developing...

28 October, 2024

In this live demo, we dive into OpenBOM’s advanced capabilities for managing product structures and Bills of Materials (BOM) including...

26 October, 2024

Manufacturing is evolving, introducing new challenges in data management far beyond what we’ve seen before. These challenges include managing the...

25 October, 2024

When it comes to turning ideas into plastic parts, there are two common types of prototypes: prototype molds and 3D...

24 October, 2024

Adopting engineering software such as PDM, PLM, and other has historically been a significant challenge. These systems have earned a...

23 October, 2024

I’m thrilled to share the latest updates in OpenBOM’s October 2024 release. From advanced data model enhancements to user experience...

21 October, 2024

I’m super excited about recent data model enhancements introduced in the OpenBOM October 2024 release. Let me share more information...

To the top