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
10 February, 2026

A Complete Guide to Managing CAD, BOM, Procurement, and ERP Data Getting started with product data management is rarely a...

9 February, 2026

After returning from 3DEXPERIENCE World 2026, I found myself having many variations of the same conversation I had with engineers...

6 February, 2026

Engineering work begins with design and… still with CAD files. Designs are created in CAD systems, simulations are performed in...

5 February, 2026

Getting started with engineering software should feel like starting work, not like starting a procurement process. Yet many teams still...

4 February, 2026

Most product teams collaborate all the time. Engineers work in CAD systems and exchange files. BOMs are exported to Excel...

3 February, 2026

When people talk about inventory management or purchase orders, the conversation usually starts in accounting or ERP systems. That is...

2 February, 2026

This is the first article in a new series called “OpenBOM: Getting Started 2026.”  The idea behind this series is...

30 January, 2026

One of the things that has always bothered me about PLM and PDM software is how hard it is to...

29 January, 2026

Across the manufacturing industry, digital transformation initiatives often begin with ambitious investments in digital technologies. Sensors are installed, dashboards are...

To the top