How to Import Point from Excel to AutoCAD/LT using SCRIPT file

Importing Points from Excel to AutoCAD/LT Using a SCRIPT File

How can I input X and Y coordinates into AutoCAD and create a SCRIPT file to produce Line, Circle, Block, Point, Donut, or Pline output in AutoCAD/LT?

What steps should I follow to input X and Y coordinates into AutoCAD and generate a SCRIPT file that produces LINE, Circle, Block, Point, Donut, or Pline output in AutoCAD/LT?

The solution is provided below.

Click here's the link to YouTube demonstration

The following video demonstrates how to utilize Excel VBA to generate a Script file by entering a list of points into AutoCAD. 

Attached is the Excel file with VBA macro built-in and without VBA to generate the SCRIPT file. 

Output for Line, Circle, Pline, Donut, Point, and Block insertion 

    

XYZ Survey point format

Other non VBA Sample figure:

Inset block attribute data sample figure:

Attached: ExcelVBA_file_for SCRIPT_to_AutoCAD_and_LT

or 

Attached: EXCEL_without_VBA_copy_paste_import_line_pline_point_Text_others_script_to_AutoCAD_Full_and_LT

 Note :

After a script file has been created, it can be run in AutoCAD using the SCRIPT command
Running A Script File in A Drawing
Create a new drawing.
On the ribbon, click Manage tab > Applications panel > Run Script. Find.
In the Select Script File dialog box, browse to and select the Script file generated from Excel 
Click Open.

Or 

Just type SCRIPT in  AutoCAD/LT commandline area and browse to and select the Script file generated from Excel and Click Open.

And Other methods (For Excel without VBA) 

From the script generated by the EXCEL column, just copy the script in the specified Excel column and paste it into AutoCAD/LT commandline area.

Enjoy ...

Sim

sim@acadsystems.com

https://acadsystems.com