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

Many manufacturing companies using SOLIDWORKS as a mechanical design CAD system start with a relatively simple engineering process. A few...

14 May, 2026

For almost three decades, most PDM and PLM systems followed the same architectural assumptions. A product was represented as a...

13 May, 2026

How modern products require connected data models that combine mechanical, electronic, software, and manufacturing information across the lifecycle. Why Mechanical...

11 May, 2026

Twenty years ago, designing a product mostly meant mechanical design. A mechanical assembly captured most of what needed to be...

8 May, 2026

Earlier this week, I previewed CAD File Agent for SOLIDWORKS. If you missed that, check these two articles: Why did...

7 May, 2026

A new kind of experience for engineers who never wanted a PDM system in the first place We Started with...

5 May, 2026

When I left Autodesk, I had a strong gut feeling about where the industry was headed. CAD vendors, I believed,...

4 May, 2026

Engineering work starts with files. CAD assemblies, parts, drawings and other related design files are the foundation of product development....

1 May, 2026

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

To the top