PDM2Excel has become the go-to tool for companies looking to automate the export of Bills of Materials (BOMs) from SOLIDWORKS PDM into Excel spreadsheets. It streamlines workflows by reducing manual work, ensuring consistency across teams, and giving businesses a reliable way to format and distribute engineering data.

With the 2025 release, and especially with the focus on what’s new in PDM2Excel 2025, the tool introduces several highly-requested improvements, simplifying setup, expanding export capabilities, and improving output customization.

Key Features in 2025

1. No Need for a Document Manager API Key

In earlier versions, administrators had to configure the Document Manager API license key before using PDM2Excel.

• This step has now been eliminated.
• Setup is faster, with fewer dependencies to manage.
• IT and administrators no longer need to track or renew the API license key, reducing overhead.

2. Create New Display States and Export in One Spreadsheet

Engineers often need BOMs with different views or display states in one place.

• PDM2Excel 2025 can now generate new display states automatically.
• These can be exported into a single spreadsheet, consolidating information that previously required multiple exports.
• This is especially useful for companies that manage multiple configurations or need reports for different stakeholders.

3. Background Color Customization

Presentation and readability matter when sharing BOMs with management or suppliers.

• A new option allows users to define background colors for BOM exports.
• This ensures key data stands out and reports align with company branding.
• Combined with Excel templates, this gives teams even more control over how BOMs are delivered.

4. Weldment Quantity Aggregation

For companies using weldments, handling quantities in BOMs has always been a challenge.

• PDM2Excel 2025 now aggregates quantities of identical weldment bodies.
• This ensures BOM exports reflect accurate totals, avoiding duplication or miscounts.
• The result: a cleaner, more reliable BOM that matches how weldments are manufactured.

Why These Updates Matter

These changes aren’t just incremental — they reflect feedback from real-world engineering teams:

• Simplified setup → No more Document Manager API dependency.
• Better data visibility → Consolidated spreadsheets with multiple display states.
• Improved communication → More polished Excel exports with background color control.
• Accuracy for weldments → Correct roll-ups and totals where they matter most.

PDM2Excel continues to evolve as the standard for PDM-to-Excel BOM automation, ensuring teams can spend less time exporting data and more time building products.