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

CAD tip CAD tip # 8496:

Question CAD 
 %  platform  category 
Q - question

Import a XYZ-coordinate file as AutoCAD points with labels.

A - answer With the enhanced version of the free LISP utility ASCPOINT - see - you can import CDF/SDF text files into 2D or 3D points, polylines and block references.

The ASCPOINT command reads selected file (comma- or space-delimited, e.g. from Excel, CSV) and inserts points, vertices or blocks on the specified coordinates. The option "Insert" allows to select a predefined block with any number of attributes. The input file can then contain the values of these attributes which will be filled in on import - e.g.:

12.3 4.56 7.8 MyAtt1 MyAtt2

For a single label you can use e.g. the block AttPoint (download and insert the DWG) and an input file in the format:


Sample video:

100% *  CAD 
28.2.2012    58087×  
Prices - CAD eShop:
applies to: AutoCAD ·

See also:
Tip 12198:How to remove duplicate points and COGO points from a DWG?
Tip 11076:Reading and displaying 3D point matrix from a CSV file.
Tip 10709:How to create a profile from imported XYZ points in Fusion 360?
Tip 10167:Keyboard shortcuts in Autodesk Fusion 360.
Tip 9788:How to import named workpoints from Excel to Inventor?

Back   All CAD Tips All CAD tips&tricks

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   

Simply link AutoCAD LT blocks to Excel table data.
Excellink LT 2006 More info

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