OpenBOM How-To: Create Catalog, Create BOM, Import from Excel

Oleg Shilovitsky
Oleg Shilovitsky
19 December, 2024 | 2 min for reading
OpenBOM How-To: Create Catalog, Create BOM, Import from Excel

Welcome to the OpenBOM Tutorial Series! We are excited to kick off a brand-new series of tutorial videos designed to provide you with quick, effective training on the fundamentals of OpenBOM. Each video in this series is just 1-2 minutes long, giving you concise and practical insights to get started.

In today’s guide, we’ll cover the foundational elements of OpenBOM: creating catalogs, building product structures (BOMs), and importing data from Excel. Let’s dive in!

Creating Your First Catalog

In OpenBOM, catalogs are the building blocks of your product data management. They serve as item databases for organizing assemblies, mechanical parts, electrical components, materials, software, and more. A catalog typically represents a specific item type, and you can create as many catalogs as needed to manage your product data.

Each item recorded in a catalog can include the following:

  • Basic attributes (e.g., description, cost, material, supplier information).
  • Complex data (e.g., CAD files, PDFs, specifications in Excel, links to external resources).

Watch the tutorial to learn how to create your first catalog and start organizing your data – Creating a First Catalog.

Building Your First Bill of Materials (BOM)

A Bill of Materials (BOM) is a critical part of product structure management. OpenBOM’s Digital BOM data model allows you to create hierarchical product structures containing assemblies, subassemblies, and individual parts with a rich set of customizable properties.

With OpenBOM, your product structure can include:

  • Hierarchical relationships for assemblies and parts.
  • Mechanical, electrical, software, and documentation data.
  • Files, links to OpenBOM objects, and external resources.

Watch the video to learn how to create your first BOM: Creating a First BOM

Importing Product Structures from Excel

Have an existing product structure in Excel? OpenBOM makes it easy to import data and visualize it as a multi-level BOM. You can display your BOM in various formats, including:

  1. Indented lists
  2. Hierarchical tree structures (graph view)

The tutorial will walk you through importing hierarchical structures (e.g., levels like 1, 1.1, 1.2, 1.3) from Excel, complete with images and additional data elements. Watch Video: Importing BOMs from Excel

Additional Resources

Want to dive deeper? Check out these resources to master OpenBOM:

Conclusion and Next Steps

OpenBOM is a powerful data management and collaboration platform built on a flexible, robust data model. By using catalogs and BOMs, you can seamlessly configure and organize your engineering and manufacturing information.

We’ve covered the basics in this article, but there’s so much more to explore! Start your OpenBOM journey today by registering for a free trial. You’ll gain instant access to a full production account and the tools you need to succeed.

REGISTER FOR FREE Happy organizing!
Best, Oleg

Related Posts

Also on OpenBOM

4 6
29 August, 2025

Digital BOM is a foundation of all OpenBOM to ERP integrations. From the very early days of PLM, the connection...

28 August, 2025

In 2025, the push for better design-to-manufacturing integration is stronger than ever. But for many companies, this still gets reduced...

27 August, 2025

For decades, PDM meant file vaults, check-in/check-out, and revision control. But today’s products span mechanical, electronic, and software domains, with...

26 August, 2025

This article is part of OpenBOM BOM Excel MCP building in public. For the next few weeks, we are going...

22 August, 2025

In yesterday’s article – Understanding OpenBOM’s Multi-Tenant Data Model and System Configuration, I shared some insights about OpenBOM’s multi-tenant data...

21 August, 2025

In today’s manufacturing and engineering world, the term multi-tenant triggers both questions and confusion. Product Lifecycle Management (PLM) has historically...

20 August, 2025

Since the very beginning of OpenBOM, our mission has been to help engineers, manufacturers, and teams organize product information and...

19 August, 2025

There is a need for a rich and structured context.  Artificial intelligence has quickly become the buzzword in every boardroom,...

15 August, 2025

A recent post by Martijn Dullaart on LinkedIn about Product Changes caught my attention. Here is the link to the...

To the top