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. 

Conclusion

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
19 June, 2025

I’m super excited to share more information for users of Siemens NX. Siemens NX is great for complex products. But...

18 June, 2025

We live in a very interesting time. Over the past two decades, we’ve seen how the internet and mobile technologies...

17 June, 2025

We’re excited to announce a new addition to the OpenBOM family of CAD integrations — support for KiCad, the widely...

13 June, 2025

Every engineering team has lived through this moment: a new product revision gets released, the buyer runs a PO, and...

12 June, 2025

Have you ever faced that moment during a project review where someone asks, “Why did the cost go up?” or...

11 June, 2025

As we move into the summer, we’re excited to share several new updates and improvements in the May 2025 OpenBOM...

10 June, 2025

At OpenBOM, we’re committed to reducing friction when it comes to managing your product data. With our latest enhancement, we’re...

6 June, 2025

At OpenBOM, we’ve always believed that managing product data should be smarter, easier, and more connected, not just for engineering...

5 June, 2025

At OpenBOM, we’re excited to preview a new feature for users of Autodesk Fusion — the ability to insert a...

To the top