Extracting attributes from an Excel file

This process allows you to automatically extract all or some of the properties from your SOLIDWORKS documents located in a Windows folder.

- Selection of Applications
You can select the folder(s) to scan by clicking the icon 
- File Locations
We specify:
- The Excel file template containing the result columns to be obtained. You can manually choose the location of your Excel template by clicking on the icon

→ 
- Then the location of the output file

Extract All Properties: This option allows you to extract all the properties of your files in the selected folder(s). You no longer need to choose a custom Excel template because all possible properties will automatically be created as columns in the Excel file.
- Defining Excel Data
Define the names of your columns that retrieve the full file name and the configuration name:

Select the formats you want to include in your export:

- Selecting Configurations
Set the property recovery option.
You can retrieve:
- the properties of a specific configuration
- the document's properties only
- the properties of the document and all configurations
- Result
When you click the "Apply" button, you get this:
Document ownership
Configuration property - one line per configuration
