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
18 September, 2026

To adopt OpenBOM, start with one product or assembly and one business problem. Organize the information, bring the team into...

17 September, 2026

OpenBOM manages product information through three levels: live collaborative data, automatic change history, and immutable snapshots. This architecture allows engineering,...

16 September, 2026

From checking readiness to supporting the decisions that make delivery possible. A product can begin drifting toward a late launch...

14 September, 2026

Shop Floor and Supplier Access to BOM, Drawings, and 3D Models  Shop floor access to engineering data means giving a...

11 September, 2026

How thumbnails, drawings, lightweight 3D files, and an integrated viewer help a team move from a BOM finding to a...

10 September, 2026

Review builds context. Agents put it to work. Decisions write it back. Why AI agents in manufacturing need a Product...

9 September, 2026

For the last few months, I had multiple conversations with people responsible for delivery hardware products – complex equipment, high-tech...

8 September, 2026

Welcome to the OpenBOM September 2026 update! The September update focuses on giving teams tighter control over who sees what...

4 September, 2026

Importing product data has always been one of the most frustrating parts of engineering and manufacturing software. The reason is...

To the top