How to easily import x,y,z coordinate data from EXCEL to AutoCAD


Do you need to import a series of XLS coordinates points into your drawing, and draw them as a series of POINTs, LINE segments, or 2D or 3D POLYLINEs?



With LitioLAB paste XLS coordinate data into AutoCAD as entities.



How to import XLS coordinate data into AutoCAD/GStarCAD



    • For 3D surface examples and a video check below.
    • For a 2D- and 3D-POLYLINE examples and a video check below.


Paste XLS to Points: This tool creates a 2D or 3D curve [as: a polyline, a set of points, or a set of line segments], or a 3D surface [as: a set of points, or a 3D mesh], when you paste a set of XLS [o simmilar] coordinates.



First choose the type of data [point coordinates] to enter [either 2D points - curve; 3D points - curve; or 3D points - surface].



Choose the type of data [point coordinates] to enter 
curves: either2D points or 3D points
surfaces: 3D points.


Note: For surfaces you will also need to enter the number of N x M points.

Then, copy your XLS data [set of 2 or 3 columns], all the required range, and paste the data in your CAD’s command line. The data will be automatically catched as it got pasted.



Select and copy your XLS data 
[a set of 2 or 3 columns], all the required range,
into LitioLAB's input line.


Paste the data in your CAD’s command line.


The resulting 2D o 3D curve, or 3D surface will be drawn.



Paste the data in your CAD’s command line.



    Get your now!

    Or use the following secondary link, or go to the downloads page.

Get you ACTIVATION code.



now!
Unlock YOUR FULL version of LitioLAB and start making all patterns right away!





How to import a collection of XLS 3D point coordinate data into AutoCAD/GStarCAD to draw a 3D MESH surface




For these examples, I picked the headform definition to test helmets as per ISO 16073 standard.



The standard defines a set of 3D coordinates as a function of an angle and a height. It is easy to copy and paste these data into an XLS file and do some XLS calculations to get the set of X Y Z coordinates of the headform definition.



So, I got these sets of points for three Headforms. For easier input, I have copied the data into a TEXT file, every point coordinate after the other.



So, for the first example I run LitioLAB and input the data belonging to the first set: the headform D.



The same for the next one, which is the headform G.



And finally, the same for the headform K.



These graphs can be used for CNC machining or 3D printing.



How to import a collection of XLS point coordinate data into AutoCAD/GStarCAD to draw a 2D/3D Polyline


Comming soon...