Autodesk 22505-051400-9000 - AutoCAD Electrical 2008, User Manual, Page: 1079 / 1304

If you start with panel layouts before you create schematics, schematic pick
list data is not available to automate footprint selection and annotation. An
alternative is available. If you list your panel components in a spreadsheet
and in a format that AutoCAD Electrical expects, this spreadsheet data can
become your schematic pick list data for panel layout.
Component spreadsheet data format
The spreadsheet data must be in this order and have 28 columns of data and
be saved in a "CSV comma delimited" text format. Most of the fields can be
left blank:
Component tag id (ex: "PB101") TAG 1
Optional installation code INST 2
Optional location code LOC 3
Optional mount code MOUNT 4
Optional group code GROUPWIDTH 5
Manufacturer code MFG 6
Catalog number CAT 7
Optional catalog assembly code ASM 8
Optional count value CNT 9
Optional unit of measure UM 10
Three lines of description text DESC1-DESC3 11-13
Schematic block name (used to determine cata-
log lookup table name) BLKNAM 14
Optional rating values RATING1-12 15-26
Select component data from a spreadsheet | 1067