For Solid Edge users

How to get a flat parts list from Solid Edge into Excel

Solid Edge can build an accurate parts list from your assembly, but it does not save that list straight to an Excel file. The usual route is to copy the list's contents and paste them into Excel. This guide shows how to get a flat list, one row per part with its total quantity, and save it as a file you can import into AssembleFlow.

Menu names below come from Siemens documentation and can differ slightly between Solid Edge versions.

Why you want an "atomic" (flat) list

A buyer needs to know how many of each part to order for the whole machine. If a screw is used 5 times in a subassembly and that subassembly appears 8 times, the buyer needs 40, not 5. In Solid Edge, an "Atomic" list includes the parts inside subassemblies without listing the subassemblies themselves, and the quantity for each part is the total number of times it appears in the assembly.

AssembleFlow does not roll up quantities through subassemblies or merge identical part numbers into one purchase order line, so a flat list is the file to import.

Method 1: a parts list on a Draft drawing

  1. Open or create a Draft (.dft) drawing of the assembly with a drawing view.
  2. Place a parts list on the view with the "Parts List" command.
  3. Right-click the parts list and choose "Properties". On the "List Control" tab, choose the atomic list option ("Atomic list (all parts)").
  4. Turn off level-based item numbers if you want a simple 1, 2, 3 numbering.
  5. On the "Columns" tab, add the columns you need, such as Document Number, Title and Material. They read the properties stored in each part file, including custom properties.
  6. Right-click the parts list and choose "Copy Contents". (Plain "Copy" copies a picture, not the data.)
  7. Paste into Excel and save the file as .xlsx or .csv.

Method 2: an assembly report (no drawing needed)

  1. In the assembly, start the "Reports" command.
  2. Choose the report type "Summary of atomic parts", a list of all unique atomic parts in the assembly.
  3. Use "Format" and "Options" to choose and order the columns.
  4. In the "Report Output" dialog, click "Copy" and paste into Excel, then save as .xlsx or .csv. ("Save As" here only offers text or RTF files.)

A report reads the properties saved in the files, so save your parts before running it.

Check the list before you import it

  • Reference parts. Parts placed only for reference can be kept out of parts lists and reports: right-click the occurrence, choose "Occurrence Properties" and set "Reports/Parts List" to "No".
  • Hidden parts. A part hidden in drawing views can drop out of a Draft parts list but still count in an assembly report, so the two methods can give different totals. Compare them once on a known assembly.
  • Same part, several rows. AssembleFlow keeps every row. If the same part number appears more than once, total it in Excel first if you want one purchase order line.
  • Extra columns. Add supplier, price or lead time in Excel before import, or later in AssembleFlow.

Import the file into AssembleFlow

In your project, choose "Import BOM" and pick the file. AssembleFlow reads CSV, XLSX, XLSM and XLS. The wizard proposes a column mapping (Part No, Description, Qty per machine, Supplier, price and so on) and you can change it. Part numbers are kept exactly as written. A "Check this column" notice appears when a column does not look like its field. Set the project's Quantity to the number of machines you are building; AssembleFlow multiplies Qty per machine by that number.

AssembleFlow cannot open Solid Edge files directly.

Using another CAD system? See the guides for SolidWorks, Inventor, Autodesk Fusion, Onshape 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.

Try it with your own Solid Edge parts list

Paste one machine's atomic parts list into Excel, save it, and import it into a 14-day free trial, no card needed. Small machine builders can also request a free 3-month pilot on one real build.

Frequently asked questions

Can Solid Edge export a parts list straight to Excel?

Siemens documentation describes copying the parts list contents and pasting them into Excel, and saving assembly reports as text. Paste into Excel and save as .xlsx or .csv.

Which list type gives total quantities?

The atomic list: parts inside subassemblies are listed, the subassemblies are not, and each quantity is the total for the assembly.

Does AssembleFlow add up subassembly quantities?

No. Import a flat (atomic) list, which already has the totals.

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

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.