Tip 2234: AutoCAD Tables to Excel
And finally, the top tip of the month is AutoCAD Tables to Excel by Doug Barnes. This utility quickly converts tables of text in an AutoCAD drawing to a comma-delimited file suitable for loading directly into Microsoft Excel and other spreadsheet programs. After loading the LISP code into AutoCAD, type Bom at the Command line. You will be prompted to locate corner points surrounding the table of text, and the rest is automatic. If text is found, the utility creates a file named BOM.CSV in the same folder as the drawing. This file is an ASCII text file in which each column is separated by a comma and each row appears as a new line -- perfect for importing into a spreadsheet. If you want to see how to sort data points and use filters, open the code to take a look under the hood in this function set. Great stuff, Doug!