AutoCAD 2013/2014/2015

AutoCAD 2013/2014/2015

Reply
Contributor
vikasranga2
Posts: 18
Registered: ‎06-13-2012
Message 1 of 3 (6,270 Views)
Accepted Solution

How to import survey points from excel sheet into AutoCAD 2013?

6270 Views, 2 Replies
06-19-2012 11:55 PM
 

There's not a 'native' way to do that, but there are a ton of LISP routines that will accomplish that goal.  Most likely you'll want to save the XLS file as a text fILE or cvs, and then use a LISP routine to place points or blocks at the coordinates. 

If you were to consider third party software (especially if your needs are more than just inserting the points) take a look at the MapWorks Points add-on, which will read the XLS file directly.

 

Also, Excel is a great tool for preparing AutoCAD SCRipt files.  You could use it to create a script file to insert your own point blocks and even populate the attributes.  Here is a detailed related example on how to create layers from a spreadsheet.

*Expert Elite*
JGerth
Posts: 2,226
Registered: ‎12-05-2005
Message 2 of 3 (6,252 Views)

Re: How to import survey points from excel sheet into AutoCAD 2013?

06-20-2012 07:48 AM in reply to: vikasranga2

There's not a 'native' way to do that, but there are a ton of LISP routines that will accomplish that goal.  Most likely you'll want to save the XLS file as a text fILE or cvs, and then use a LISP routine to place points or blocks at the coordinates. 

Distinguished Mentor
TerryDotson
Posts: 515
Registered: ‎06-06-2010
Message 3 of 3 (6,248 Views)

Re: How to import survey points from excel sheet into AutoCAD 2013?

06-20-2012 08:02 AM in reply to: vikasranga2

If you were to consider third party software (especially if your needs are more than just inserting the points) take a look at the MapWorks Points add-on, which will read the XLS file directly.

 

Also, Excel is a great tool for preparing AutoCAD SCRipt files.  You could use it to create a script file to insert your own point blocks and even populate the attributes.  Here is a detailed related example on how to create layers from a spreadsheet.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.