CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 5707

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 Download) 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 - Download.

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

See also:
Tip 12926:How to import point coordinates from Excel to AutoCAD?
Tip 12837:RenameCSV - rename layers, blocks, layouts, views, linetypes using Excel tables
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.

Back   All CAD Tips

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   

Increase your productivity with our set of add-on functions for AutoCAD Civil 3D
CADstudio Civil Tools More info

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