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
20 January, 2026

A recent LinkedIn comment from Scott Morris captured something many manufacturing companies are quietly struggling with but rarely say out...

19 January, 2026

When experienced configuration management practitioners repeatedly say “CAD is not a part,” it is usually a signal that the industry...

15 January, 2026

The manufacturing companies are not what they used to be. In fact, there often isn’t a single company anymore. The...

14 January, 2026

One of the goals behind the new OpenBOM licensing model is very simple:make it easy to start, even if you...

13 January, 2026

Every engineering team and manufacturing company is using Excel. For years, we thought Excel was a technical problem. But I...

12 January, 2026

At OpenBOM, design integrations are not treated as optional add-ons or isolated utilities. They are a core part of how...

9 January, 2026

I’ve spent a lot of time this week rereading notes from past conversations about ECOs, AI, and collaboration, and one...

8 January, 2026

Engineering change is quietly outgrowing the systems we built to control it. On paper, ECO and ECN processes still look...

7 January, 2026

Boston, MA — January 2026 — OpenBOM today announced a new pricing and licensing model for 2026, designed to lower...

To the top