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

CAD tip CAD tip # 11076:

Question CAD 
 %  platform  category 
Q - question

Reading and displaying 3D point matrix from a CSV file.

A - answer The CSV2PTS utility (free from can import an Excel (.CSV) file with Z-coordinates of a regular point matrix (rectangular grid, e.g. an array of measured data). You can represent the points data in 3D, optionally converting them to a 3D surface e.g. with Civil3D tools or with DTM.

A sample .csv file is included in the download. Load the CSV2PTS LISP utility with APPLOAD and start the CSV2PTS command. Specify the .csv filename (comma-delimited) and the cell size (X,Y). Make sure you set the PDMODE and PDSIZE variables to display the imported points (after REGEN).

For smaller grids (<256 rows and colums) you can also create a 3D Mesh from the CSV data.

See also PtMesh, with a more general input file format -

100% *  CAD 
1.9.2016    4126×  
Prices - CAD eShop:
applies to: AutoCAD ·

See also:
Tip 10709:How to create a profile from imported XYZ points in Fusion 360?
Tip 9698:Data formats supported in Autodesk InfraWorks 360.
Tip 8496:Import a XYZ-coordinate file as AutoCAD points with labels.
Tip 8325:Importing CSV file into an AutoCAD table.
Tip 7465:How to import XYZ coordinates as DWG points with elevation labels?

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   

Extend your AutoCAD LT productivity with our popular add-on
CADstudio LT Extension 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.