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
18 March, 2025

In today’s fast-moving world of innovation, the way we interact with technology is constantly evolving. One of the latest breakthroughs...

15 March, 2025

I have never met an engineering or manufacturing organization that is not interested in cost. Cost is a fundamental aspect...

14 March, 2025

Design for Manufacturing (DFM) is a critical step in product development, ensuring that a design is optimized for efficient and...

14 March, 2025

Back in the early days of PDM development, the primary focus was on organizing and managing CAD files. Engineers struggled...

11 March, 2025

Managing product structures efficiently is crucial for engineers and manufacturers. OpenBOM provides powerful tools to visualize and organize Bills of...

11 March, 2025

At OpenBOM, we continuously strive to enhance user experience by simplifying workflows and reducing friction in daily operations. One area...

8 March, 2025

In today’s fast-moving manufacturing environment, efficiency is everything. Companies must ensure that their engineering and procurement teams work together seamlessly...

7 March, 2025

Supplier collaboration is a critical part of manufacturing, but too often, it’s bogged down by outdated tools like spreadsheets and...

7 March, 2025

Last week, we hosted an exciting OpenBOM Live Demo, showcasing how OpenBOM Digital Thread as Services streamlines the CAD-to-Purchase process....

To the top