SolidWorks Custom Properties Manager is a CAD automation tool designed to simplify batch editing of SolidWorks custom properties across multiple PART and ASM files.
The tool was developed by Ramu Gopal, creator of The Tech Thinker, as part of ongoing research and development in engineering automation and SolidWorks workflow optimization.
Engineering teams often need to update metadata across hundreds of CAD files, including:
- Description
- Part Number
- Material
- Finish
- Vendor properties
- Revision information
Manually editing these properties inside SolidWorks can be slow and error-prone.
This tool automates the process using an Excel-based batch workflow.
- Batch export of SolidWorks custom properties
- Excel-based editing of metadata
- Bulk re-import of updated properties
- Folder-level automation
- Engineering workflow optimization
- SolidWorks API
- VBA (Visual Basic for Applications)
- Excel Automation
The tool uses a simple UI-driven workflow built using the SolidWorks API and VBA.
Workflow:
SolidWorks Files ↓ Export Custom Properties ↓ Edit Metadata in Excel ↓ Batch Import Back to SolidWorks
- Batch export properties
- Excel metadata editing
- Bulk import to SolidWorks
- Folder-level automation
- SolidWorks
- VBA enabled
- Excel
- Download the release
- Open SolidWorks
- Run the macro
Ramu Gopal Mechanical Engineer | CAD Automation Developer
Creator of The Tech Thinker https://thetechthinker.com
Full explanation of the tool architecture and workflow:
https://thetechthinker.com/solidworks-custom-properties-manager-guide/