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 May, 2023

In the complex world of engineering and manufacturing, part numbers form a hidden language that orchestrates the processes of manufacturing….

26 May, 2023

This a question that often comes up when engineers or manufacturing companies decide to step up in their data management…

26 May, 2023

In the vast and intricate world of manufacturing, where precision and efficiency reign supreme, there exists a hidden language that…

25 May, 2023

In today’s data-driven landscape, organizations face the challenge of managing vast amounts of information efficiently. When it comes to CAD,…

23 May, 2023

At OpenBOM we help manufacturing companies to organize their data and processes to streamline their engineering and help them to…

19 May, 2023

In the complex world of engineering and manufacturing, effective identification of components is a key to success. Everyone has a…

19 May, 2023

Today, we’re delving into an interesting topic that has garnered quite a bit of attention in our community: “Do I…

18 May, 2023

I’m thrilled to share that I’m invited to speak and share my insight at the upcoming PI DX USA 2023…

17 May, 2023

In today’s fast-paced and globally connected manufacturing landscape, effective collaboration with your supplier is crucial for success. A key aspect…

To the top