CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
Cesky English Deutsch
 Visitors: 3899 

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    21218×  
Comments   Tell a friend

See also:
Tip 11868:Open just a part of a DWG drawing - layers, views.
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.

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   

Link your AutoCAD texts with Excel tables/sheets. Export. Change. Import.
Try DwgText 2015 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.