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

One of the most common questions I hear from engineering and manufacturing teams is simple: how do we move product...

30 April, 2026

There is a moment in every engineering company when Excel stops being a helpful tool and becomes the bottleneck. At...

29 April, 2026

Most engineering teams do not start with a product data problem. They start with a design problem. They need to...

28 April, 2026

Every manufacturing company has a BOM review process. The question is what that process actually catches — and what still...

24 April, 2026

A BOM can exist and still not be ready for release. Here is why that matters  and what a better...

23 April, 2026

Every month, I look at OpenBOM updates not just as a list of features, but as a reflection of how...

21 April, 2026

A continuation of the April 20, 2026 OpenBOM article: AI Agents and PLM Adoption: Why Understanding Your Work Comes First...

20 April, 2026

Why AI agents will expose the same adoption problem PLM has always had PLM Adoption Was Always Harder Than the...

17 April, 2026

Threaded at ACE 2026 by Aras: A Startup Space That Changed the Tone Earlier this week, I went to Miami,...

To the top