Exporting and Importing SW Properties - Excel

EXPORT TO EXCEL

The macro will create a column for each property it finds in your SolidWorks file generating a row for each component. Don't forget to select an empty Excel file for the destination so that the information it contains is not deleted.

IMPORT FROM EXCEL

Fill in the columns you need and add as many as you want for the macro to create new properties for all components.

The macro is designed to be used as follows:

ACTIVE COMPONENT:
The macro will work on the active file in Solidworks. In case it is an assembly it will be traversed by the macro.

SEARCH COMPONENT:
Select the component you want within your system. In case it is an assembly it will be run through the macro.

SEARCH FOLDER:
Do you have all the files in the same folder? 
Select it and the macro will open and export them all.

Here is a video that shows how you will save a lot of time: