Mastering OpenBOM: How to Export a Sorted Bill of Materials in Just a Few Simple Steps (Video Tutorial)

Oleg Shilovitsky
Oleg Shilovitsky
28 March, 2023 | 3 min for reading
Mastering OpenBOM: How to Export a Sorted Bill of Materials in Just a Few Simple Steps (Video Tutorial)

Bill of Materials (BOM) is an essential component in product manufacturing and design. It provides a comprehensive list of components and raw materials that are required to build a particular product. As the complexity of products and their manufacturing processes increases, the BOMs also become more intricate and multi-level. OpenBOM is a cloud-based BOM management software that provides a platform for companies to create, manage, and share BOMs with their suppliers, manufacturers, and customers.

Challenges of Data and BOM Export

Exporting data is a very important function of every business software. As much as we believe that data will live peacefully inside the business systems, the need for engineering and product development organizations is too broad and Excel (or other spreadsheet software) is still taking a big role in the day-to-day processes. 

Exporting multi-level BOMs from many engineering software packages is always a challenging task. Especially when there are several components and sub-assemblies involved – multi-level BOM. To make this process more manageable, OpenBOM allows users to apply specific rules while exporting and sorting BOMs.

OpenBOM Export Options 

One of the key features of OpenBOM is the ability to export BOMs in various formats, such as Excel, CSV, and PDF. To export a multi-level BOM from OpenBOM, users can select the BOM they want to export and choose the export format. OpenBOM provides several export options, such as exporting all levels, exporting only the top level, or exporting a specific level. Users can also choose to export only specific columns, such as item number, description, quantity, and unit of measure.

Applying specific rules while exporting BOMs can help streamline the process and make it more efficient. For example, users can choose to export and sort together all the sub-assemblies and their components to ensure that the BOM is organized and easy to understand. OpenBOM also provides an option to export the BOM in a hierarchical format, which displays the BOM in a tree-like structure, with each level of the BOM indented to show its relationship with the other levels.

Another useful feature of OpenBOM is the ability to customize BOM exports. Users can create custom templates that define the format and content of the exported BOM. For example, users can create a template that includes specific columns, such as material type, supplier, and cost. This allows users to tailor the BOM export to their specific needs and requirements.

OpenBOM Export Sorted Multi-Level

You can easily export BOM from OpenBOM by applying to sort when following these simple rules. First of all, switch the BOM to a single-level BOM option. 

Once it is done, use the Export command and select the following 2 options – export sorted and multi-level. 

Click “Export” and your BOM will be fully exported to Excel with the preserving sort option. 

Video Demo

Watch the following video to learn more about the process. 


Exporting multi-level BOMs from OpenBOM can be made easier by applying specific rules and using the platform’s features to customize the export. By exporting and sorting together all sub-assemblies and components, users can create an organized and easily understandable BOM. Additionally, customizing the BOM export with specific columns and formats can help streamline the manufacturing and supply chain processes. OpenBOM provides a powerful platform for managing BOMs, and by leveraging its features, companies can increase efficiency and productivity in their product development and manufacturing processes.

REGISTER FOR FREE to start your 14-day trial and learn how OpenBOM can help. 

Best, Oleg 

Related Posts

Also on OpenBOM

4 6
29 November, 2023

The new year is fast approaching, and as I counted earlier today, we have only 18 working days left until…

28 November, 2023

In the world of product design and manufacturing, the complexity of aligning data between Computer-Aided Design (CAD) software and Bill…

25 November, 2023

Digital transformation is important for everyone these days and you can embrace the future of digital transformation with OpenBOM. The…

24 November, 2023

Everyone knows that China is the global manufacturing powerhouse of the world that attracts business from all around the world….

23 November, 2023

In the modern digital software world, the importance of User Experience (UX) cannot be overstated. UX is an important element…

23 November, 2023

Hello there! If you’re reading this, you’ve probably taken the first step toward managing your engineering data more efficiently by…

22 November, 2023

In the ever-evolving landscape of modern technology, staying ahead of the curve is essential for businesses seeking to remain competitive…

21 November, 2023

The landscape of Product Lifecycle Management (PLM) software has undergone a significant transformation in recent years, thanks to modern software…

17 November, 2023

I’m excited to share the new tutorial that just became available in OpenBOM Training Library – OpenBOM Design Training Course. …

To the top