SOLIDWORKS Macro: BOM and Table Export to CSV or Excel

What this macro does

Finds BOM or general tables in the active drawing or assembly and exports their visible cells to CSV, with optional Excel automation.

Best for

• Purchasing handoff
• ERP import preparation
• BOM audits

Inputs

• Open drawing or assembly containing BOM/table annotations

Outputs

CSV, XLSX

Filename rules

{document}_table_{index}.csv.

How to use

1. Test on copied SOLIDWORKS files first.
2. Download and import BomTableToCsvExcel.bas into a SOLIDWORKS VBA macro project.
3. Open the required document type: Drawing, Assembly.
4. Run main from the macro editor or assign it to a toolbar button.
5. Review all generated files before using them for production release.

Limitations

• Exports visible table text, not resolved ERP data.
• Excel export requires Microsoft Excel to be installed.