BOM Management – Spreadsheet vs OpenBOM comparison

Oleg Shilovitsky
Oleg Shilovitsky
3 October, 2019 | 2 min for reading
BOM Management – Spreadsheet vs OpenBOM comparison

When it comes to BOM management software, spreadsheet software such as Microsoft Excel and Google Sheets are one of the most popular. And it is not because Spreadsheets are very simple and flexible, but because an alternative is very complex and expensive. As a result, individual engineers, contractors, and entire manufacturing companies are still choosing Excel (spreadsheets) to manage BOM, to calculate how many units you need and essentially running your business. 

Fortunately enough, for the last three years, our team is building OpenBOM – the most advanced and easier replacement for Excel (and Google) Spreadsheets. I think, we achieved the level we can speak about the real advantages of OpenBOM approach comparing to Excel/spreadsheets. 

In this article, I will demonstrate what is the best way to build Bill of Materials using OpenBOM compared to Excel/Spreadsheet and make some important calculations such as quantity and cost rollup. 

Before starting, I recommend you to read this article – Fundamentals of OpenBOM Data Management. This article will help you to get an overal understanding of how OpenBOM is managing data. 

The core element of OpenBOM data management principals is the reference-instance model. Another commonly used name for the same concept is part-usage. 

Assuming, you are aware of the Reference-Instance model, lett’s get deep into details of creating and managing the Bill of materials. 

Comparison #1 

Managing parts, instances, re-use components, single-level and multi-level BOM and restructure of information. In my first video, I’m demonstrating how can you do both in Excel and OpenBOM. 

Advantages of OpenBOM is in managing structure, re-use component data and adding visual data. 

Comparison #2 

In the second comparison, I’m focusing on OpenBOM advantages in BOM management such as flatten report and rollup cost calculations. You will learn how to plan catalogs, calculate the quantity and any property rollup (in my case, it was cost rollup). 


Think about OpenBOM as an online spreadsheet with a huge amount of BOM steroids. It is easy to start (free) and it gives you something spreadsheet cannot – a distributed database of items (catalogs), reference-instance model in BOMs, flatten BOM, rollups and more. 

Start using OpenBOM today and leave your old spreadsheet behind. Register for FREE OpenBOM subscription here.

Best, Oleg @ openbom dot com.

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
3 February, 2023

I have something really cool today to talk about. Let’s talk about Folders and Files. Every company has a lot…

2 February, 2023

3DEXPERIENCE World 2023 is a premier event for product design, engineering, and manufacturing professionals. Organized by Dassault Systemes, it is…

1 February, 2023

As manufacturers increasingly strive to be more agile, efficient, and cost-effective in their product development processes, finding ways to simplify…

31 January, 2023

Are you considering implementing OpenBOM in your organization? In the world of product lifecycle management (PLM), OpenBOM represents one of…

27 January, 2023

As the demands of consumers change, so does the environment around them. We now live in a world where customers…

27 January, 2023

Data organization is key for any successful Product Lifecycle Management (PLM) program. The ability to manage, organize, search, and quickly…

26 January, 2023

Managing CAD files is an important part of the data management systems and product lifecycle management (PLM) process. CAD files…

25 January, 2023

The last decade of engineering and manufacturing business development demonstrated that data is increasingly important for modern manufacturing businesses as…

23 January, 2023

I’m excited to bring a sneak peek of OpenBOM user-defined commands. These commands will allow you to easily define specific…

To the top