CAD BOM export guides

How to export a BOM from your CAD system to Excel

For purchasing you need one list per machine: each part once, with the total quantity for the whole machine. Most CAD systems can produce that list, but each one calls it something different: "Parts only", "atomic parts" or "flattened". Pick your CAD system below for the exact steps.

Guides by CAD system

  • SolidWorks: a "Parts only" BOM table, saved as Excel.
  • Autodesk Inventor: the "Parts Only" view in the Bill of Materials, exported to Excel.
  • Autodesk Fusion: the "Parts Only" layout in the Bill of Materials, exported to CSV.
  • Solid Edge: an atomic parts list or the "Summary of atomic parts" report, copied to Excel.
  • Onshape: the "Flattened" BOM table, exported to CSV.
  • Creo Parametric: a drawing BOM table (recursive repeat region), saved as CSV.

Why a flat list and not the assembly tree

An indented (structured) BOM shows how the machine is put together. A buyer needs something else: how many of each part to order. If a bracket is used 2 times in a subassembly that is used 4 times, the buyer needs to order 8. A flat ("parts only") export from the CAD system already does that multiplication. AssembleFlow does not roll up quantities through subassemblies or merge identical part numbers into one purchase order line, so the flat list is the file to import.

Check the file before you use it

  • Each part number appears once. If it appears in several rows, total them in Excel first if you want one purchase order line.
  • Quantities are for the whole machine. If you build several identical machines, AssembleFlow multiplies by the number of machines in the project.
  • Parts you do not buy (reference parts, weldment members you make in-house) are left out or marked.

Then: from the file to purchase orders

AssembleFlow reads CSV, XLSX, XLSM and XLS files. Import the flat BOM, check stock, and send RFQs and purchase orders straight from the parts list. Prefer to start in Excel? Use the free Machine BOM template.

Turn your CAD BOM into purchase orders

Import the flat BOM, check stock, and order straight from the parts list.

Frequently asked questions

Can AssembleFlow open my CAD files directly?

No. Export the BOM as a spreadsheet (CSV or Excel) and import that file.

What if my CAD system is not listed?

Look for a "parts only", "flattened" or "summary" BOM option and export it to CSV or Excel. The same checks apply.

Which file types can I import?

CSV, XLSX, XLSM and XLS.

Can I try it on one of my own machines?

Yes. Start the 14-day free trial without a card, or, if you are a small machine builder, request the free 3-month pilot on one real build.

Start the 14-day trial Request the 3-month pilot

SolidWorks is a trademark of Dassault Systèmes. AssembleFlow is not affiliated with or endorsed by Dassault Systèmes.

Autodesk and Inventor are registered trademarks or trademarks of Autodesk, Inc. AssembleFlow is not affiliated with or endorsed by Autodesk, Inc.

Autodesk and Autodesk Fusion are registered trademarks or trademarks of Autodesk, Inc., and/or its subsidiaries and/or affiliates in the USA and/or other countries. AssembleFlow is not affiliated with or endorsed by Autodesk, Inc.

Solid Edge and Designcenter are trademarks or registered trademarks of Siemens Industry Software Inc., or its subsidiaries or affiliates, in the United States and in other countries. AssembleFlow is not affiliated with or endorsed by Siemens.

Onshape is a trademark of PTC Inc. or its subsidiaries. AssembleFlow is not affiliated with or endorsed by PTC Inc.

Creo and Creo View are trademarks of PTC Inc. AssembleFlow is not affiliated with or endorsed by PTC Inc.