Why you want a flat list
A structured BOM follows the assembly tree. Purchasing needs each part once, with the total quantity for the whole machine. AssembleFlow does not roll up quantities through subassemblies or merge identical part numbers into one purchase order line, so importing a flat list is the way to get one line per part with its total quantity.
Save a drawing BOM table as CSV
- Create a drawing of the top-level assembly of the machine.
- Insert a BOM table with a repeat region, or use your company's standard BOM table.
- Set the repeat region to read data from all levels of the assembly (recursive), and to list duplicate occurrences as a group, so each part appears once with its quantity.
- Show the columns you need, such as part number, description and quantity, using report symbols or model parameters.
- Select the table. On the Table tab, open Save Table and choose Save as CSV.
- Open the CSV file in Excel, check it, and save it as .xlsx or keep it as .csv.
Note: menu names and repeat region options can differ between Creo versions and company templates. If your table shows each subassembly separately, check the repeat region settings first.
Using Creo View?
If your team views assemblies in Creo View, open the Bill of Materials there, choose Export and select CSV as the file type.
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.
- Hardware not in the model. Add screws, grease or other items that are not modeled before you import, or add them later in AssembleFlow.
- 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 Creo files 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 Onshape, or the overview at How to export a BOM from your CAD system to Excel. Prefer to start in Excel? Use the free Machine BOM template.
Turn your Creo BOM into purchase orders
Import the CSV, check stock, and send RFQs and purchase orders straight from the parts list.
Frequently asked questions
Can Creo export a BOM straight to Excel?
Not with one button in assembly mode. Save a drawing BOM table as CSV; Excel opens CSV files directly.
Should I export a structured or a flat BOM for purchasing?
Flat. It lists each part once with its total quantity.
Can AssembleFlow open Creo files?
No. It imports the BOM as a spreadsheet (CSV, XLSX, XLSM or 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
Creo and Creo View are trademarks of PTC Inc. AssembleFlow is not affiliated with or endorsed by PTC Inc.