AutoCAD 2010/2011/2012 DWG Format

[#1]

I have a drawing with the x and y as grid references, I have an excel spreadsheet with point information with grid references which are within the range on the drawing. How do I put the excell info onto the drawing?

[#2]

Go here and grab it.

http://lee-mac.com/ptmanager.html

[#3]

With a little concatenation in your excel file you can copy and paste (and insert) the whole lot into your drawing via the command line.

Attached is a quick example.  Copy and paste everything in Col F to the command line and the points will be plotted.

Dave.

[#4]

I have tried both suggestions but seemed to have got nowhere. What I was hoping for was a spot or cross where the coordinates are followed by a description of the object. I'm a complete newby to autocad and quite honestly don't know how I can make it work for me. On a .dwg file I have a map with a grid, when I move my cursor then the coordinates change, so I thought if I can input my coordinates from my excel file I can anotate my map with the objects - tree locations. What I have in one column is this

 350437,171695,Atlantic Cedar

I would like to put a coloured circle at the grid point to indicate whether it is a conifer or a broadleaved tree. And also include it's database number in the above case 0322. Any more suggestions most gratefully received. Chris

[#5]

That would require Land desktop, Civil 3d or an add-on program available from DOTSOFT.COM for a cheaper price.

[#6]

Thanks for your help. Doubt if I can justify the expense so I'll just draw each one in individually. chris

[#7]

Attach whatever you have, let me see if this free program I have will do what you want.

[#8]

Thanks for the offer. I've tried sending but .dwg file is too large at 2.6m. Chris

[#9]

Chris,  If your files are too large to attach to email, there are options such as "yousendit.com" as free file FTP sites - you upload your files & just send a link via email for downloading.  Might be too late now, but thought you might like to know you have options.

Cheers!

TdH