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
19 June, 2026

Every OpenBOM implementation eventually arrives at the same question: “What Part Number schema should we use?” And every time, the...

17 June, 2026

We are proud to share that OpenBOM has been included in the Gartner® Magic Quadrant™ for PLM Software in Discrete...

16 June, 2026

From BOM management to a connected operational layer across engineering, procurement, inventory, and business systems. Earlier this week, I introduced...

15 June, 2026

On Friday I wrote about how OpenBOM re-thinks cloud PDM and moves engineering teams beyond the local vault. The question...

12 June, 2026

For the last 10-15 years, I watched CAD vendors promise to deliver cloud PDM, but the promise didn’t come true....

9 June, 2026

AI will not fix broken CAD-to-Excel-to-file processes. It will expose them. Engineering teams that want real value from AI need...

9 June, 2026

Get clear, actionable advice on product cost management software—features, benefits, pricing, and tips to help your team control costs with...

8 June, 2026

The principle behind the OpenBOM and QuickBooks integration is straightforward. OpenBOM manages the bill of materials, the parts, the structure,...

4 June, 2026

Modern product development no longer happens inside a single company, a single department, or a single system. Products are designed,...

To the top