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, 2025

I’m super excited to share more information for users of Siemens NX. Siemens NX is great for complex products. But...

18 June, 2025

We live in a very interesting time. Over the past two decades, we’ve seen how the internet and mobile technologies...

17 June, 2025

We’re excited to announce a new addition to the OpenBOM family of CAD integrations — support for KiCad, the widely...

13 June, 2025

Every engineering team has lived through this moment: a new product revision gets released, the buyer runs a PO, and...

12 June, 2025

Have you ever faced that moment during a project review where someone asks, “Why did the cost go up?” or...

11 June, 2025

As we move into the summer, we’re excited to share several new updates and improvements in the May 2025 OpenBOM...

10 June, 2025

At OpenBOM, we’re committed to reducing friction when it comes to managing your product data. With our latest enhancement, we’re...

6 June, 2025

At OpenBOM, we’ve always believed that managing product data should be smarter, easier, and more connected, not just for engineering...

5 June, 2025

At OpenBOM, we’re excited to preview a new feature for users of Autodesk Fusion — the ability to insert a...

To the top