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

Sheet metal design has a manufacturing reality that solid parts do not. The 3D model is only the beginning. Before...

27 May, 2026

A practical guide to working folders, Smart Sync, design structure, locking, revisions, and conversational commands inside SOLIDWORKS Introduction: Why PDM...

26 May, 2026

Last week I was at the Share PLM Summit. AI was everywhere: in the keynotes, in the vendor demos, in...

25 May, 2026

Companies struggle to get real business value from AI in engineering and manufacturing not because the technology is weak, but...

22 May, 2026

Here is the problem most PLM and other product data tools ignore Most engineering and manufacturing companies already know they...

21 May, 2026

Welcome to the OpenBOM May 2026 update! Every month we work hard to make OpenBOM better — and this month...

20 May, 2026

Every product starts with an idea, but turning that idea into a shippable product requires structure, coordination, and detail. That’s...

20 May, 2026

Why disconnected BOM and product data holds AI agents back — and how to fix it AI agents in engineering...

19 May, 2026

For years, BOM review was often treated as a procedural step between engineering and release. Teams created bills of materials,...

To the top