CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
Cesky English Deutsch
 Visitors: 7206 
Plex.Earth connects AutoCAD and Google Earth

CAD tip CAD tip # 7193:

Question CAD 
 %  platform  category 
Q - question

How to create DWG layers from a list in CSV/Excel?

A - answer Using the free utility CADstudio CsvLayers you can automatically create (import) an arbitrary list of layers to your DWG drawing by reading in a text file with layer definitions.

You can create the layer list in Excel (CSV - comma-delimited values format), or type it in a text editor. The list can contain either the layer names only, or also their properties - color, linetype, lineweight, plot/noplot, visibility… Possible already existing layers will be redefined with the properties from the CSV file.

You can download the application CsvLayers from

An example of the layer definition file:

;CsvLayers sample file
;Expected format:  
MyHidden,4,Dashed,1,1,1,25,This will be hidden  
Ceske Budejovice,,,,,,,My hometown

Created layers

100% *  CAD 
29.1.2010    20008×  
Comments   Tell a friend

See also:
Tip 11160:Dynamic display of layer/block/text style/linetype properties.
Tip 10693:List of blocks (incl. nested blocks) used in a DWG drawing.
Tip 9843:How to add Classic workspace (toolbars) to AutoCAD 2015?
Tip 9694:Random object colors in 3ds Max.
Tip 9185:Fix problem of Areas on self-intersecting curves in AutoCAD 2013.

Back   All CAD Tips All CAD tips&tricks

How to restore AutoCAD messages hidden by checking "Ignore"? « | » How to increase the offset between MLeader text and underline?

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 add-on functions for AutoCAD Civil 3D
CADstudio Civil Tools More info

Please use these tips at your own risk.
CAD Studio (Xanadu) is not responsible for possible problems that may occur as a result of using any of these tips.