Why export a "Flattened" BOM
Onshape's BOM table has two views. Structured keeps the assembly hierarchy, with subassemblies and their parts. Flattened lists all parts from all levels together, without the subassemblies, which is the view purchasing needs. AssembleFlow does not roll up quantities through subassemblies or merge identical part numbers into one purchase order line, so importing a flattened BOM is the way to get one line per part with its total quantity.
Export the BOM table to CSV
- Open the top-level Assembly tab of the machine.
- Open the Bill of Materials table from the BOM icon on the right of the graphics area.
- In the BOM type drop-down, choose Flattened.
- Click Add column to show the columns you need, such as Part number, Description and Quantity. Remove columns you do not need by right-clicking the column header and choosing Remove column.
- Open the overflow menu (the three dots at the top right of the table) and choose Export to CSV. The file downloads to your computer.
- Open the file in Excel, check it, and save it as .xlsx or keep it as .csv.
Tip: if you export the Structured view instead, choose Expand all first. Onshape only exports the rows that are expanded.
Make purchased subassemblies one line
Some subassemblies are bought as one item, for example a gearbox or a pneumatic unit. Right-click the subassembly in the instance list, open Properties and set Subassembly BOM behavior to Show assembly only. The BOM then lists it as one item instead of its internal parts. Items you do not buy can be left out with Exclude from BOM (right-click the row in the BOM table).
Check the file before you import it
- Same part, several rows. If the same part number appears in more than one row, AssembleFlow keeps every row. Total them in Excel first if you want one purchase order line.
- Parts you do not buy. Check that excluded items and purchased subassemblies appear the way you expect.
- Extra columns. Add supplier, price or lead time in Excel before import, or later in AssembleFlow.
Import the file into AssembleFlow
AssembleFlow reads CSV, XLSX, XLSM and XLS files. It cannot open Onshape documents directly. In your project, open Import BOM, choose the file and check the column mapping (Part No, Description, Qty per machine, Supplier and so on). A part number in the file is kept exactly as written. If you import a revised file into the same project, parts whose part number is already there are skipped (this option is on by default).
Using another CAD system? See the guides for SolidWorks, Inventor, Autodesk Fusion, Solid Edge and Creo. Prefer to start in Excel? Use the free Machine BOM template.
All CAD guides in one place: How to export a BOM from your CAD system to Excel.
Turn your Onshape BOM into purchase orders
Import the CSV, check stock, and send RFQs and purchase orders straight from the parts list.
Frequently asked questions
Does AssembleFlow connect to Onshape directly?
No. Export the BOM table to CSV and import that file.
Which BOM view should I export?
Flattened. It lists each part with its quantity for the whole assembly, without the subassembly structure.
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
Onshape is a trademark of PTC Inc. or its subsidiaries. AssembleFlow is not affiliated with or endorsed by PTC Inc.