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
16 October, 2026

How OpenBOM Engineering Frontend connects SOLIDWORKS design data with electrical, electronics, software, and manufacturing information. A SOLIDWORKS assembly can be...

15 October, 2026

A BOM management system organizes product Items, assembly relationships, quantities, revisions, and supporting information so engineering, manufacturing, and purchasing can...

14 October, 2026

Product development depends on people working together across engineering, purchasing, manufacturing, and suppliers. Each participant brings different information and often...

13 October, 2026

Every day brings another example of AI at work: reading documents, writing code, analyzing data, generating content, or helping someone...

13 October, 2026

For years, the PDM vs PLM conversation followed a familiar pattern. Product Data Management controlled CAD files and engineering revisions....

9 October, 2026

A design change is not finished when the CAD model is saved. Engineering still needs to know which component changed,...

8 October, 2026

A buyer asks which bracket to order. Engineering sends a drawing. The BOM lists a part number, the supplier quotation...

7 October, 2026

The engineering frontend workflow across disciplines This is the third article in the series of articles about OpenBOM engineering frontend....

7 October, 2026

Files and Items in the product knowledge graph This is the second article in the series of articles about OpenBOM...

To the top