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
1 May, 2025

Welcome to the April 2025 edition of What’s New in OpenBOM! Each month, we work hard to turn your feedback...

30 April, 2025

I’m super excited to introduce April 2025 release of OpenBOM for PTC Creo with the new features to help you...

29 April, 2025

Meet Sarah. She’s a mechanical engineer at a growing robotics company, juggling CAD models, spreadsheets, supplier lists, and emails from...

25 April, 2025

Spreadsheets are everywhere. Every engineer, buyer, or project manager has their own system—color-coded tabs, clever formulas, and “just one more”...

24 April, 2025

Accessing the right information at the right time is a paramount requirement for all engineering and manufacturing teams. I’m super...

23 April, 2025

In my article today, I want to continue to share ideas about how to organize new types of agentic workflows...

21 April, 2025

There’s a lot of excitement right now about Large Language Models (LLMs). From writing code to generating marketing copy, these...

18 April, 2025

At OpenBOM, we believe seamless integration is the key to efficient product development. Engineering teams today work across mechanical and...

17 April, 2025

At OpenBOM, we’re always striving to improve the user experience. One of our guiding principles is continuous improvement — especially...

To the top