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 September, 2025

Imagine a small but growing manufacturing company. The engineers are busy designing innovative products in CAD tools like SolidWorks or...

17 September, 2025

At OpenBOM, our long-term vision has been consistent: to enable engineers and manufacturing companies to make better decisions by providing...

15 September, 2025

NEWTON, Mass., Sep 16th, 2025 /PRNewswire-PRWeb/ — OpenBOM, a leading provider of cloud-native PDM and PLM software, today announced the...

12 September, 2025

In modern manufacturing, data is the new infrastructure. From design to procurement, from production planning to supplier collaboration, every process...

11 September, 2025

Earlier last week, I shared a series of articles about the main principles and elements of the OpenBOM data model.....

10 September, 2025

This article is the next chapter in the OpenBOM Data Model 2025 Update series. If you’re new to the series,...

9 September, 2025

This article is the next chapter in my ongoing blog series about OpenBOM Data Management. In the first chapters, I...

6 September, 2025

Modern engineering and manufacturing teams don’t sit under one roof anymore. They are increasingly distributed across different offices, time zones,...

5 September, 2025

In my recent article, OpenBOM Data Model (2025 Update): A High-Level Overview, I introduced the foundations of the OpenBOM Data...

To the top