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
26 July, 2024

Welcome to the final installment in our series on best practices for utilizing OpenBOM’s new xBOM feature. In previous articles,…

26 July, 2024

We continue to discuss the capabilities of recently released xBOM services. It expands OpenBOM product structure (BOM) management in many…

25 July, 2024

In today’s digital age, the ability to seamlessly connect and identify items is crucial for efficient operations and effective data…

24 July, 2024

If you’re following our publications and recent release news in July 2024 you already know that OpenBOM introduced a groundbreaking…

23 July, 2024

Last week, we introduced a new and groundbreaking service – xBOM, designed to support complex product development and lifecycle management….

19 July, 2024

Data is a new oil of the modern digital environment. Therefore the way companies can manage information about their products…

18 July, 2024

OpenBOM, a leading provider of cloud-based PDM and PLM software, announced the expansion of its services to include xBOM and…

18 July, 2024

I’m thrilled to share the launch of OpenBOM’s latest innovation – the xBOM Service. This architecture of xBOM is designed…

16 July, 2024

Welcome to the OpenBOM What’s New July 2024 release! I hope you’re having a fantastic summer. It’s scorching here in…

To the top