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

Other starting points Your BOM already exists. It is in a spreadsheet, and your design is in CAD. Typing it...

28 October, 2026

In a spreadsheet, the same part shows up again and again. It is a row in this BOM, a row...

28 October, 2026

Reading about a BOM tool only tells you so much. The real question is whether it works with your parts,...

27 October, 2026

Where does your bill of materials live? For many teams, the honest answer is “everywhere.” Part of it is in...

27 October, 2026

Why your files show as “outside mapped folders” File versions and revisions serve different purposes Design files rarely stay in...

27 October, 2026

I’m excited to be at Oracle AI World 2026 in Las Vegas. At Oracle AI World 2026, OpenBOM and Trinamix...

23 October, 2026

“I don’t think we need onboarding. We just have a few technical questions.” We sometimes hear this from customers getting...

22 October, 2026

What is product data management at the record level? Keep item identity, BOM quantity, and revision distinct so purchasing uses...

21 October, 2026

“Can we support 10 units by November 8?” Picture that question coming up in a planning, production or even sales...

To the top