How Much Time Do Engineers Spend Managing BOM in Excel?

Oleg Shilovitsky
Oleg Shilovitsky
26 May, 2022 | 3 min for reading
How Much Time Do Engineers Spend Managing BOM in Excel?

In any business, time is money. The more time an organization spends on tasks that don’t generate revenue, the less money they have to invest in growing its business. Engineers like to get engaged in the design and actual engineering jobs rather than manage data and organize Excels. From my experience of working with many engineers, managing data will be the least favorite activity for engineers. No one really likes to manage data. BOM in Excel is one of these activities. Managing BOMs in Excel is one of the most time-consuming non-design tasks. 

Poll: How much time is wasted managing BOM in Excel

We wanted to learn more about how much time engineers spend managing BOM in Excel. Without any chance to provide a systematic answer, we decided to create a LinkedIn poll and publish it in a large Solidworks LinkedIn user group with more than 100K members. We’ve got pretty interesting results. With more than 60K impressions and more than 400 votes, it can give you an idea of how much time is spent and what engineers actually think about it. In the picture below you can see the results of the voting. 

Roughly half of the respondents said that they spent less than an hour and it is not a big deal. That was not a surprise. SolidWorks is known for a very nice BOM to Excel export and I know, from experience, that for many engineers exporting BOM to Excel is the end goal. Then they pass it to other people in their organization that need to take care of managing these BOMs and this amount of work is not counted by engineers. 

It was very interesting to learn that 38% of respondents are spending 1-5 hours every week in Excel and this is messy and disturbing. The last 10% spend more than 5 hours a week and this is a total waste

What did we learn from comments and conversations? 

I’ve been talking to many engineers during this poll online and offline to understand where the time is spent and how to help engineers to streamline their work. Here are the top three things where we believe companies are failing and, as a result, wasting time and money using Excel as a data management tool. 

  1. Many engineers are not aware that there is a better way to manage BOMs rather than export files from SolidWorks to Excel and send them downstream using emails. 
  2. Export data actually takes very little time, but processing data is where real waste is happening. 
  3. Updates are very painful and once data is exported, it is very difficult to manage updates. 
  4. Engineers prefer to keep all information in Solidworks (including non-CAD items), which can simplify merges, but bring a lot of unnecessary data to the CAD system. 
  5. Managing non-CAD business data using CAD storage (eg. SolidWorks) can make purchasing decisions very hard. 
  6. There is no good visibility of the data managed using Excel, which is a big downside for all companies. 

Conclusion

The amount of time engineers spent in Excel is gigantic. However, the problem is much bigger and deeper. While the visible time engineers spend managing BOM in Excel is between 1-5 hours per week, companies are losing money on mistakes, wrong Excel file sharing, wrong data used by different departments, and many other problems that are caused by using Excel as a data management tool.

How we can help? OpenBOM provides out-of-the-box, simple, and easy cloud-based tools that can simplify the work of every engineer and help organizations to get aligned and streamline data management including parts, BOMs, documents, and purchasing process. 

REGISTER FOR FREE and check out how OpenBOM can help you today. 

Best, Oleg

Related Posts

Also on OpenBOM

4 6
18 July, 2025

Managing product data is no longer just about locking files in a vault. Modern engineering teams work across disciplines such...

17 July, 2025

Every product starts with an idea—but to turn that idea into a real, physical thing, you need structure, coordination, and...

16 July, 2025

Let’s talk about part numbers today. Every engineering team and manufacturing company needs a clear, consistent part numbering strategy. But...

15 July, 2025

How did Abram Scientific replace spreadsheet chaos with seamless CAD and BOM integration using OpenBOM?  In product development—especially in medical...

11 July, 2025

If you work in manufacturing or procurement, you already know the struggle. You need STEP files for CNC programming, PDF...

10 July, 2025

We are excited to share that OpenBOM now offers a completely revamped integration with QuickBooks, bringing your engineering, inventory, and...

9 July, 2025

A few days ago, I posted an article titled Is your data BOMable?, where I explored the readiness of your...

8 July, 2025

Let’s be honest – keeping track of accurate Bills of Materials (BOMs) is one of the biggest challenges in engineering...

3 July, 2025

Walk into any engineering office today, and you’ll see it immediately: Excel open on someone’s screen. Spreadsheets have been the...

To the top