• Blog posts

    Bio

    By Dennis Collin

    AutoCAD_Tip_-_Need_to_input_points_from_an_Excel_or_CSV_file_-_1.JPG

    AutoCAD_Tip_-_Need_to_input_points_from_an_Excel_or_CSV_file_-_2.JPG

    AutoCAD gets used by many disciplines who need the software to perform a wide range of tasks. I was recently asked about how I would go about creating geometry from a list of XYZ coordinates. These points could be boundary markers or survey stations, but if there are many points to place, this can be quite a tedious and error prone process.

    Fortunately, AutoCAD has a very flexible API with a range of environments, LISP is an old language but still has a place in performing routine tasks. I noticed a useful free Lisp routine that does precisely this task of inputting points from a text file, as either point entities, geometry or attributed blocks.

    These routines can be loaded into AutoCAD start-up suite of bespoke commands. I have discussed this process in a previous post here:

    https://www.cadlinecommunity.co.uk/hc/en-us/categories/200349221-Blogs

    AutoCAD_Tip_-_Need_to_input_points_from_an_Excel_or_CSV_file_-_3.JPG

    Once loaded via Appload, the command INPUTXYZ becomes available to AutoCAD for the reading in of survey data from a compatible file. INPUTXYZ routine is a free download at https://JefferyPsanders.com. This routine allows the selection of a suitable file format such as XLS, TXT, CSV or similar. The routine also has a, get data function that allows for format checking and then a user defined option of how that data should be shown within a drawing.

    AutoCAD_Tip_-_Need_to_input_points_from_an_Excel_or_CSV_file_-_4.JPG

    Once imported other routines could be used to connect them with lines, place on layers and be used to create surfaces.