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

Revisions, Change Requests, and Change Orders in OpenBOM This article is concluding our five days blog series with OpenBOM Product...

9 July, 2026

Ask an engineering team when the BOM is finished and they will point to the release. Ask a purchasing team...

8 July, 2026

On Monday we said that nobody has a BOM problem. On Tuesday we followed a design out of CAD and...

7 July, 2026

There is a button in every CAD system that engineers know well: export BOM to Excel. It feels productive. In...

6 July, 2026

When companies start looking for better tools to manage product information, the conversation usually begins with a very specific pain....

3 July, 2026

Here is a story I hear almost every week. Engineering export the bill of materials (BOM) in Excel. Procurement works...

2 July, 2026

Excel is not going away. Let’s start there, because PLM vendors have always defined Excel as the problem. For years,...

30 June, 2026

Every few weeks during onboarding, someone stops me with the same worried question. They have just seen the words “data...

29 June, 2026

Across the previous four articles in this series, I made a case that can sound almost philosophical. A Part Number...

To the top