Can you import excel to create points on a topo map?
Can you import excel to create points on a topo map?
(OP)
I am trying to create a topographic map given 4000+ points in a spreadsheet and was wondering if the spreadsheet could be imported into autocad.





RE: Can you import excel to create points on a topo map?
Regards,
Namdac
RE: Can you import excel to create points on a topo map?
s murrison @ cox. net
Take the spaces out. I don't want attract spammers to this site.
Scott
RE: Can you import excel to create points on a topo map?
RE: Can you import excel to create points on a topo map?
surveli
can you elaborate on the function you use to import the text file? i know how to get the text file set up and all that but cannot figure out how/where to pull the list in to cad as multiple points.
i'll keep looking around since this thread is a few months old...
RE: Can you import excel to create points on a topo map?
thanks again
RE: Can you import excel to create points on a topo map?
"multiple
point"
at the top and save it as the txt. then rename it as .scr
in autocad, type script and it'll import the points. there's a few kinks i've still gotta work out. like you've got to make sure the txt/scr file is in the units designated to import in autocad. and it only plotted the first and last point out of my list so i've got to figure out why it did that. thought i'd pass it along in case others would like a way to do this without paying extra for it.
RE: Can you import excel to create points on a topo map?
once you've set up the .scr file, you type "script" in the command line.
will post back once i get all the details figured out.
RE: Can you import excel to create points on a topo map?
http:/
RE: Can you import excel to create points on a topo map?
i just used "x,y" type coordinates and haven't tried including point numbers.
so to summarize: create a text file like this
multiple
point
5,5
10,10
20,20
end
then rename it with .scr instead of .txt
go to autocad and type "script" and locate the file and that's it. the last thing that will happen is that "end" will be left in the command line...just hit esc (in other words, the end doesn't really do anything as far as i can tell but it does make something about it all work).
mem1, i'm clueless about autolisp but i'll take a look since i'm always trying to get better at my cad skills.
RE: Can you import excel to create points on a topo map?