How to import X Y Z coordinates from Excel to AutoCAD - Engineering Society
Press Enter To Search
404 This page was not found

Thursday, December 20, 2018

How to import X Y Z coordinates from Excel to AutoCAD

In this video you will learn How to import X Y Z coordinates from excel to AutoCAD and also learn how to draw a 3D POLYLINE with multiple point coordinates data by just copy and paste.

you can import points in batch from excel to autocad. The details discussion in this video are given below:- 

I have taken some coordinates data consisting Easting, Northing and RL values. thne i applied a formula in excel. The formula is CONCATENATE which joins several texts in a single text string. 

To import points in autocad the easting northing and rl values that is x y z coordinates should be arranged followed by comma. for example x,y,z after creating x,y,z format I copied all x,y,z formatted data and then opened autocad and after choosing multiple points option i paste the data in autocad command bar. do not use POINT command use Multiple point command. after importing points I have shown how to draw 3D POLYLINE by using the coordinates data.

Share on :

Author :

No comments:

Post a Comment

live stream

Live stream with us at 7 pm





Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
All Rights Reserved Engineering Society
Designed by