CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 6305
Plex.Earth connects AutoCAD and Google Earth

CAD tip CAD tip # 13757:

Question CAD 
 %  platform  category 
Q - question

Bulk editing of drawing properties (DWGprops) from Excel.

A - answer With the freeware LISP utility DWGpropsCSV you can set the values of the drawing properties (DWGprops) of all DWG files in the whole folder at once, according to an Excel table with the property prescriptions.

Download the DWGpropsCSV utility from Download, load it into your AutoCAD using APPLOAD and run it, even in an empty drawing, by typing DWGPROPSCSV.

In the first prompt, enter the name of the text CSV (comma/semicolon-separated values, e.g. from Excel) file containing the prescription (import-rules) for the property settings. It may look something like this:

Lines beginning with a semicolon are comments. The first content row contains a list of property names to be set (column names with property values). One of these properties must be DWGNAME - the name or wildcard mask of the DWG filename.

The next lines of the file then list the property values for the individual DWG files. The individual files are identified by their filename in the DWGNAME column, or collectively by a mask (wildcard), perhaps even just "*" for uniform property settings applied for all DWG files in a folder. If no name in the table matches the name of the currently processed DWG file, no changes will be made to it.

You can set both standard properties, e.g. "Author", and also set/add any additional custom properties.

In the next prompt (dialog) you specify the folder from which all DWG drawings will be successively processed. However, the actual property settings (changes) will only be applied for DWG files whose name is specified in the CSV file (DWGNAME column) or whose names match the specified filename mask. The property settings will be applied from the first row of the table that matches the DWG name.

Note: If you want to use comma-separated (or semicolon separated) CSV files even in local environments, set the LISP variable:

(setq _CSVdelimiter ",")

100% *  CAD 
8.6.2023    2577×  

See also:
Tip 13599:How to read iProperties from Inventor models and drawings in AutoCAD DWGs?
Tip 13056:How to copy DWG Properties from one drawing to another?
Tip 12796:How to reorder custom DWG properties?
Tip 9516:Automating properties in DWG drawings - hidden gem in Express Tools.
Tip 9514:Automatically set the Author property in DWG files.

Back   All CAD Tips

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

Increase your productivity with our set of BIM add-on functions for Autodesk Revit
CADstudio Revit Tools More info

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.