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
22 November, 2024

Manufacturers usually start to manage their Bill of Materials (BOM) in Excel, but as businesses grow and the complexity of...

22 November, 2024

I’d like to share the story of xLM Solutions, a PLM service provider that focuses on helping businesses adapt and...

21 November, 2024

Manufacturing faces mounting challenges as product complexity grows, demanding advanced design and production capabilities to stay competitive. Cost pressures and...

20 November, 2024

In this article, we explore the story of Xtend AI, a company developing mobile intelligence and robotic platforms. With a...

16 November, 2024

OpenBOM’s open architecture empowers you to connect seamlessly with a variety of applications and services, enabling efficient collaboration across design...

15 November, 2024

With tariffs on Chinese imports potentially climbing above 60% and increases of 10% or more on goods from other regions,...

14 November, 2024

I’m thrilled to invite you to watch the second Design Projects Live Demo we held yesterday and check out more...

13 November, 2024

Product development success relies on the synergy between multiple team members. It is a teamwork. Engineers, project managers, procurement teams,...

12 November, 2024

I’m excited to share the great story of the Purdue Electric Racing Team and their journey to streamline CAD data...

To the top