CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE
Over 1.096.000 registered users (EN+CZ). AutoCAD tips, Inventor tips, Revit tips. Try the new precise Engineering calculator and the updated Barcode generator. New AutoCAD 2026 commands and variables.

CAD tip CAD tip # 11076:

Question

CAD 
 %  platform  category 
A
The CSV2PTS utility (free from DL 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 - DL Download.

ACAD
100% *CAD
1.9.2016    24854×  
applies to: AutoCAD ·

See also:
Tip 14361:Extended ATTOUT/ATTIN for block attribute management in Excel (also for LT).
Tip 14059:Import coordinates from CSV files into Fusion profiles.
Tip 13766:Edit the Fusion 360 CAM tool library using Excel.
Tip 13757:Bulk editing of drawing properties (DWGprops) from Excel.
Tip 12926:How to import point coordinates from Excel to AutoCAD?


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
  



Featuring:
Export 3D VRML scenes from AutoCAD and Inventor
VRMLout More info


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