choblo wrote:Our company has about 6 thousand points we need to plot all are in coordinate form, lat/long (DMS format) though I can convert them to decimal or UTM format as well. The coordinates are in Excel....So now I'm looking to see if Topo will be able to do the same thing. If anyone could point me into the right direction I would greatly appreciate it!
You can import them with a text file. DMS format is okay, but it needs to be with a space between each, and a comma in this format:
- Code: Select all
D M S, D M S (Lat, Lon)
Take a look at this for a good start: http://www.delorme.com/support/supporttemplate.aspx?id=251
It will take some work to get your Excel file in the required format, but it can be done. My suggestion would be to use Excel to get it into two columns with decimal degrees, Lat first, Lon second. Then copy those columns and Paste Special Values (so you have the values and not the formula in the cell. Then delete all other columns. Save the file as a .csv and rename it to .txt, then edit it to add the BEGIN and END lines. Finally, use Topo to Import the text file.