OpenBOM Export and Import Enhancements

Oleg Shilovitsky
Oleg Shilovitsky
5 September, 2019 | 3 min for reading
OpenBOM Export and Import Enhancements

The spreadsheets are part of everyday life for every single manufacturing company. People love them despite all the mess they can bring. And people hate them because of the same reasons. 

At OpenBOM we are taking an approach to integrate spreadsheets into the user experience and workflows in a non-invasive way. So, we are good with spreadsheets as far as they don’t do harm and we recommend to users and customers how to get rid of harmful workflows with spreadsheets. 

One of a very favorable spreadsheet workflow is import. We learned that at least in 40% of use cases, the company already has some data in a spreadsheet format, it is good to allow to bring this data in. 

OpenBOM has an import function that significantly improved in the last OpenBOM production update. Now we can import from Google Sheet and also handle some data such as Images and OpenBOM checkboxes. 

Here is how it goes…  It’s just like the existing import form Excel but there is a new option for Google Sheets.  After authenticating to your google account you will be presented with the file chooser to select a file.  Be sure you know which line has the header row and the name of your “part Number” property.

Here is a short video to demo this feature and also how to import images: 

Images is the big deal. We can see an increased amount of use cases when users are interested to use preview images as well as to import these images from outside. Therefore we delivered the option to import an image from both Excel and Google Spreadsheet.  Be sure your images are assigned to the cell and not free-floating then import as you would any spreadsheet.

Another thing is checkbox properties that became very useful for tasks and actions in OpenBOM. Since the last release, we can bring them as well. 

Export and Import 

We found a combination of Export+Import as a perfect way to change the way people work. Think about ripping one set in the data management workflow. Think about cost calculation. Think about only a single step. You can transform it from Excel cost calculation  (which is a nightmare) to OpenBOM multi-level cost rollup heaven. By doing so and combining it into an entire import/export scenario, you can keep the rest of the processes untouched. And then move with small incremental steps. 

In the video below, I demonstrate, how OpenBOM can Export / Import spreadsheet to OpenBOM while editing it in between. 


OpenBOM Import and Export of Excels and Spreadsheet is an important element of every digital transformation process in a company. Digital Transformation is an incremental process of taking your processes from one state (Excel-driven) to a new way of using digital technologies such as OpenBOM and others. To be able to collaborate and exchange data efficiently with a spreadsheet environment is absolutely needed to make it successful. 

Try OpenBOM Import today by registering to OpenBOM FREE user account and testing it with one of your existing BOMs.

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
20 June, 2024

In today’s fast-paced and highly competitive market, the complexity of products impacts every aspect of their development and lifecycle management….

19 June, 2024

As we reach the midpoint of 2024, it’s a perfect time to reflect on the journey and growth of OpenBOM….

18 June, 2024

In today’s fast-evolving business landscape, the importance of serialization is growing. Companies are increasingly shifting from a traditional model of…

14 June, 2024

The Bill of Materials (BOM) serves as a key component of the manufacturing process. The BOM is a comprehensive list…

14 June, 2024

Change is the only constant thing you can see in every engineering and manufacturing process in your organization. Despite the…

13 June, 2024

In every manufacturing business, cost is a critical factor that can determine success or failure. Efficient cost management is essential…

12 June, 2024

In today’s fast-paced manufacturing environment, companies are increasingly seeking ways to work in a more connected and efficient manner. The…

11 June, 2024

In my previous article, I briefly introduced you to upcoming OpenBOM enhancements related to product structure management and the introduction…

8 June, 2024

In the modern manufacturing and supply chain management environment, streamlining processes from engineering to procurement is vital. To support customer…

To the top