VIDEO: Two secrets about BOMs in Excel

Oleg Shilovitsky
Oleg Shilovitsky
23 May, 2020 | 2 min for reading
VIDEO: Two secrets about BOMs in Excel

Excel is still the most popular application to manage Bill of Materials. Many companies consider Excel as a safe heaven. After all enterprise and business products fail, Excel can do a job. But the thing with Excel is that the visible part of Excel is easy. An invisible part of Excel is the one that you will have to fight and within the time it will be harder and harder to do. 

Why so? Because, Excel is easy to start, but when it comes to BOMs it gets messy very quickly because of the following two things. 

1- Part (Item) Reference 

Each Part (Item) has a set of attributes and you want these attributes to be managed in a central location. Such as Description, Manufacturer, Cost, Supplier, Part Number, etc. Using Excel you only can copy it from BOM to BOM. No single reference possible. 

2- Product (BOM) Structure 

Product structure (BOM) is a set of structured information. Excel doesn’t have a possibility to manage structured information of assemblies, sub-assemblies, parts. In Excel, you will be forced to use indentation mechanism, but it won’t give you a true structure, queries, calculations and other things needed to manage structure in BOM (effectivity, quantity, rollups, etc.) 

Watch the video

Conclusion

Excel (and any other spreadsheet) lack fundamental mechanisms that needed to manage BOM such as single item reference and product structure. I wonder what you think. Still think, Excel can do it, prove it – contact me and show me how you do so (oleg @ openbom dot com). 

Otherwise, register to OpenBOM for free here and try these two mechanisms with your real-data.

Best, Oleg @ openbom dot com.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Read OpenBOM customer reviews on G2 Crowd to learn what customers are saying about OpenBOM. 

Related Posts

Also on OpenBOM

4 6
2 May, 2025

Data is everything in today’s digital world. While every manufacturing company thinks differently about their products and strategy, the common...

1 May, 2025

Welcome to the April 2025 edition of What’s New in OpenBOM! Each month, we work hard to turn your feedback...

30 April, 2025

I’m super excited to introduce April 2025 release of OpenBOM for PTC Creo with the new features to help you...

29 April, 2025

Meet Sarah. She’s a mechanical engineer at a growing robotics company, juggling CAD models, spreadsheets, supplier lists, and emails from...

25 April, 2025

Spreadsheets are everywhere. Every engineer, buyer, or project manager has their own system—color-coded tabs, clever formulas, and “just one more”...

24 April, 2025

Accessing the right information at the right time is a paramount requirement for all engineering and manufacturing teams. I’m super...

23 April, 2025

In my article today, I want to continue to share ideas about how to organize new types of agentic workflows...

21 April, 2025

There’s a lot of excitement right now about Large Language Models (LLMs). From writing code to generating marketing copy, these...

18 April, 2025

At OpenBOM, we believe seamless integration is the key to efficient product development. Engineering teams today work across mechanical and...

To the top