Video blog #10 – From Excel to OpenBOM

Oleg Shilovitsky
Oleg Shilovitsky
8 May, 2020 | 2 min for reading
Video blog #10 – From Excel to OpenBOM

Think escaping Excel BOM management is mission impossible? Think twice, because in this video, I’m going to show you how easy to do it in OpenBOM. 

In my demo today, I will show you how to grab a BOM from your Google Sheet, split it into 2 pieces, import item information to create the OpenBOM catalog, and BOM just under 10 minutes total. Once you will do it, your Bill of Materials information will be taken to the next level. Just a few examples of what you will be able to do automatically: 

1- By updating information in the catalog(s), the change will be automatically reflected in all BOMs (OpenBOM is databases and not spreadsheets you need to search for an update). 

2- Automatic rollups for quantities (Flattened BOM) and calculations. 

3- Share data (BOMs and catalogs) automatically with all members of your organization (you stay on the same BOM, no need to send Excels and emails. 

OpenBOM can do many other things like help you to plan production and manage purchase orders, import data from CAD systems. I will talk about these features in my next videos. 

Many companies made a switch from Excels to OpenBOM. Read their stories here

And there is the video with my demo:

Conclusion

Staying with old fashion Excel spreadsheet, you can expose yourself to potential mistakes, production delays, excessive cost, and missing production targets. Somebody else will come to your place and will eat your lunch by developing products faster and at a lower cost. 

Here is the truth: You can easily escape messy Excels and stop doing manual Bill of Materials calculations. However, here is the thing – most software products out there are not equipped with a unique set of functions and capabilities as OpenBOM. 

OpenBOM gives you a unique way to change what you do with the Bill of Materials and other related tasks in less than fifteen minutes. It is because of the unique technologies we developed at OpenBOM.

Check OpenBOM now by registering an account here

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