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 August, 2026

Over the last three days I have looked at BOM Review from three angles. I explained that a BOM review...

30 July, 2026

What makes a BOM “good”? Is there such a thing at all?  The traditional perspective of any PLM or even...

29 July, 2026

A few months ago I spent time experimenting with an open source agent environment OpenClaw – a free and open-source...

28 July, 2026

Since we first introduced OpenBOM BOM Review in July, I have been asking engineering managers a simple question: how many...

25 July, 2026

We keep improving OpenBOM, and not every improvement is a new feature inside the product. Here is one that lives...

23 July, 2026

Everyone Is Asking for the API. Almost Nobody Is Asking the Right Question. Over the last few months we noticed...

22 July, 2026

There is a question I hear in almost every conversation with engineering and manufacturing companies in 2026: do we still...

21 July, 2026

OpenBOM security is a layered model combining AWS infrastructure, SOC 2 Type II certified operational controls, AES-256 encryption at rest...

20 July, 2026

A few weeks ago I was on a call with an engineering manager at a 60 person industrial equipment company....

To the top