In this article, I have explained two different ways of importing the X, Y, Z Coordinates (Easting, Northing & Reduced Levels) from an Excel sheet to AutoCAD in the course of points.

In the first method, nosotros will employ but excel to compile information then we volition but import the data in AutoCAD. In the 2nd method nosotros will transfer the date from excel to a simple script file and and then we will import the script file in AutoCAD to make the points.

These methods are explained in the tutorial video every bit well shown below, merely if you adopt the article then here information technology is.

Importing coordinates using excel formula

As shown in this motion picture beneath, we take Ten, Y, Z coordinates, otherwise Easting, Northing & Reduced levels of more than than 10000 points in an Excel sheet.

To create points using this data (to Consign this data into an AutoCAD drawing), we have to convert this data into the language that AutoCAD can sympathise. We can convert this data in coordinate points and AutoCAD uses POINT Command to make points in AutoCAD.

Type in POINT in the control bar and striking the Enter key.

Now we take a message at the Command Prompt, 'Specify a Point', In that location are two methods to specify a point.

  1. Feed the 10, Y, Z Coordinates of the Bespeak in the Control Bar.
  2. Click anywhere in the drawing area and an AutoCAD point Object will be created at that particular point.

Here I will get with the first method i.e feeding the Ten, Y, Z Coordinates of the Point in the command bar, let it be 1000,1000,1000.

Press the Enter cardinal and an AutoCAD bespeak is created at m,1000 with an elevation of 1000, see the animated gif above for reference. If you desire to verify the coordinates of the point you can practice that using the Property Palette.

Select the Point, Right Click, select Properties from the menu. Values which nosotros used to create this point are shown against the labels Position X, Position Y, Position Z as shown in the epitome below.

The sequence of commands used to create the point can exist replicated approximately ten,000 times to create all the points simply obviously, it tin can't be done manually and this is where the Excel formula comes into the picture. The period of command for POINT looks like this on the command bar history.

Here is the period of the command shown in the prototype above.

Command: POINT

Current point modes:  PDMODE=0  PDSIZE=0.0000

Specify a point: 1000,grand,g

In our Excel canvas, 10,Y,Z Coordinates of Point one are in the cells B2, C2 and D2 respectively.

From the command history, it is clear that the syntax for creating a indicate in AutoCAD is Indicate 10,Y,Z. So for x,000 points, this value should be repeated for as many times. The resulting data should look similar data within the scarlet box of the epitome below.

For creating a indicate using the coordinates given in the cells B2, C2 and D2, nosotros accept to join the data in the cells B2, C2 & D2 preceded past Indicate command and we tin can use CONCATENATE function in Excel to join the strings.

In the image to a higher place the CONCATENATE function is used to join the strings, for your reference I am writing the complete formula here likewise.

=CONCATENATE("Betoken ",B3,",",C3,",",D3) is the formula to join the five strings listed below.

  1. POINT (AutoCAD Command)
  2. " "(Space Graphic symbol)
  3. B2 (the cell containing the 10 Coordinate)
  4. C2 (the cell containing the Y Coordinate)
  5. D2 (the jail cell containing the Z Coordinate)

And the issue is POINT X,Y,Z, The formula can be copied into the downward cells using the fill handle feature in Excel.

Copy this information, Open an AutoCAD drawing and Paste it into the command bar as shown in the blithe gif below.

And by doing that and we just created around 10000 points. To cross check the total number of points created, Select all (Ctrl+A is the shortcut for selecting all objects in an AutoCAD drawing), Right click for the Properties palette and there you can run across the total number of points in the drawing.

Nosotros tin can besides use Command Aliases in the formula, control Allonym for Point Command is PO. The formula will then become, =CONCATENATE("PO ",B3,",",C3,",",D3)

Using Script file to import coordinates

There is besides some other method which works in a similar mode and it makes use of the script file of AutoCAD.

Again, allow'due south assume we accept our coordinate data in an excel canvass in 3 columns namely X, Y and Z (or Northing, easting and pinnacle if you prefer). Now copy data from all of these cells then open Notepad or any other simple text editor and paste the complete data in information technology, this process is shown in the video below.

Yous data will look similar the image shown beneath, with lots of spaces betwixt the values of corresponding cells. We need to supersede the spaces hither with the comma. Select the infinite between corresponding cell entries and go to the edit menu of Notepad and select the Replace pick.

Now in the replace with field, blazon "," (without quotes) and press supervene upon all button and close the replace window, take reference of animated gif shown below.

At present type _MULTIPLE_POINT in the first line of the notepad text just before the coordinate values and then go to file bill of fare then save as option and save the file with .scr format. Y'all can give information technology any proper noun you lot want, in this example, I am using indicate.scr as the notepad file name.

At present we can import these points pretty easily in AutoCAD using SCRIPT command. Type SCRIPT then press Enter key in your AutoCAD command bar and then locate the scr file you created in the example above and click on Open push.

The points will be added in the drawing, the point command will besides remain active which you tin deactivate by pressing the ESC cardinal.

That was all, I promise you have found this article useful. If you have questions related to the article feel free to let me know in the comments below.

References: Autodesk knowledge network commodity