HOW TO DOWNLOAD AND USE EXCEL LISP

EXCEL LISP:

 Automating Data Transfer from Excel to AutoCAD

This is an Excel automation sheet that helps you to reflect your coordinates from Excel to Autocade
first, you have to download this lisp then you will see the interface of this sheet like this as shown below.

scroll down you will get a download option

Note: Do not click yes to save changes after Closing.

In the field of civil engineering and design, precision and efficiency are critical. Excel Lisp is a powerful automation tool designed to streamline the process of transferring data from Microsoft Excel to AutoCAD, specifically text, polylines, point names, and level text. This tool is particularly useful for professionals who need to accurately reflect as-built data collected from total stations into AutoCAD drawings.

What is Excel Lisp

Excel Lisp is an automation sheet that facilitates the seamless transfer of various types of data from Excel spreadsheets to AutoCAD. This includes:

Point Mark

Polylines

Level Text

Line

By using Excel Lisp, users can efficiently manage and transfer their survey data into AutoCAD, saving time and reducing the likelihood of errors associated with manual data entry.

How to Use Excel Lisp

Using Excel Lisp involves three main steps: selecting your desired operations, inputting your data, and transferring the data to AutoCAD.

1. Select Your Operations

Excel Lisp provides a user-friendly interface where you can choose what you want to display in your AutoCAD drawing. The options include:
Show Point Number: Display the point number at the corresponding coordinate location.
Show Text Level: Display the level text at the specified location.
Draw Polyline: Create polylines based on the coordinate data.
Point Mark: Mark specific points on the drawing at the corresponding coordinates.
Draw Line: Draw lines between specified points with the help of coordinates.
Additionally, you can customize the height and rotation of your text, allowing for greater flexibility and clarity in your drawings.

2. Input Your Data

The second portion of the Excel Lisp sheet is where you input your data. This typically includes columns for:
Easting
Northing
Level (or any other text)
You paste the data collected from your total station into these columns. This setup allows you to organize your data efficiently and prepare it for transfer.

3. Transfer Data to AutoCAD

The final step involves copying the prepared data from Excel and pasting it into the AutoCAD command bar. Here’s how to do it:
1. Prepare the Data: Once your data is organized in the Excel sheet, copy the relevant columns.
2. Paste in AutoCAD: Open AutoCAD and paste the copied data into the command bar.
3. Automatic Processing: Excel Lisp will automatically process the data and display the results in your AutoCAD drawing.

Download:

you can download this Excel lisp for free just give us a comment for feedback.

Benefits of Using Excel Lisp

Time-Saving: Automates the transfer process, significantly reducing the time required to input data manually.
Accuracy: Minimizes human error, ensuring that the data transferred is precise and reliable.
Efficiency: Streamlines the workflow, making it easier to manage and manipulate large datasets.
Customization: Allows for customization of text height and rotation, providing greater flexibility in presenting data.

Conclusion

Excel Lisp is an invaluable tool for civil engineers, surveyors, and designers who need to transfer data from Excel to AutoCAD accurately and efficiently. By automating the process of transferring text, polylines, point names, and level text, Excel Lisp enhances productivity and ensures that your AutoCAD drawings are both precise and detailed. Whether you are working on infrastructure projects, urban planning, or detailed architectural designs, Excel Lisp helps you take control of your data transfer needs with ease and confidence.