There is also another method which works in a similar way and it makes use of the script file of AutoCAD.ДЄgain, letвЂ™s assume we have our coordinate data in an excel sheet in three columns namely X, Y and Z (or Northing, easting and elevation if you prefer). The formula will then become, =CONCATENATE(вЂњPO вЂњ,B3,вЂќ,вЂќ,C3,вЂќ,вЂќ,D3) Using Script file to import coordinates We can also use Command Aliases in the formula, command Alias for Point Command is PO.

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 see the total number of points in the drawing. D2 (the cell containing the Z Coordinate)ДЄnd the result is POINT X,Y,Z, The formula can be copied into the downward cells using the fill handle feature in Excel.Д¬opy this data, Open an AutoCAD drawing and Paste it into the command bar as shown in the animated gif below.ДЄnd by doing that and we just created around 10000 points.C2 (the cell containing the Y Coordinate).B2 (the cell containing the X Coordinate).=CONCATENATE(вЂњPOINT вЂњ,B3,вЂќ,вЂќ,C3,вЂќ,вЂќ,D3) is the formula to join the 5 strings listed below. In the image above the CONCATENATE function is used to join the strings, for your reference I am writing the complete formula here as well. The resulting data should look like data inside the red box of the image below.ДЇor creating a point using the coordinates given in the cells B2, C2 and D2, we have to join the data in the cells B2, C2 & D2 preceded by POINT command and we can use CONCATENATE function in Excel to join the strings. So for 10,000 points, this value should be repeated for as many times. In our Excel sheet, X,Y,Z Coordinates of Point 1 are in the cells B2, C2 and D2 respectively.ДЇrom the command history, it is clear that the syntax for creating a point in AutoCAD is POINT X,Y,Z. Here is the flow of the command shown in the image above.Д¬urrent point modes: PDMODE=0 PDSIZE=0.0000 The flow of command for POINT looks like this on the command bar history. The sequence of commands used to create the point can be replicated approximately 10,000 times to create all the points but obviously, it canвЂ™t be done manually and this is where the Excel formula comes into the picture. Values which we used to create this point are shown against the labels Position X, Position Y, Position Z as shown in the image below. Select the Point, Right Click, select Properties from the menu. If you want to verify the coordinates of the point you can do that using the Property Palette.

Press the Enter key and an AutoCAD point is created at 1000,1000 with an elevation of 1000, see the animated gif above for reference. Here I will go with the first method i.e feeding the X, Y, Z Coordinates of the Point in the command bar, let it be 1000,1000,1000.

Click anywhere in the drawing area and an AutoCAD point Object will be created at that particular point.

Feed the X, Y, Z Coordinates of the Point in the Command Bar.

Now we have a message at the Command Prompt, вЂ Specify a PointвЂ™, There are two methods to specify a point. Type in POINT in the command bar and hit the Enter key. We can convert this data in coordinate points and AutoCAD uses POINT Command to make points in AutoCAD.

To create points using this data (to Export this data into an AutoCAD drawing), we have to convert this data into the language that AutoCAD can understand. Importing coordinates using excel formulaДЄs shown in this pic below, we have X, Y, Z coordinates, otherwise Easting, Northing & Reduced levels of more than 10000 points in an Excel sheet.

Access autocad plot style location