Help! Importing Coordinates into Topo

[choblo]

I'm currently working on importing coordinates into the topo system. 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. I recently converted all the points into a XML format and uploaded them into Google Earth, but it doesn't have a topographical system that I can see. 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! Thanks!

[xapie128]

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.

[choblo]

Thank you! I'll be working on this in the near future. Its nice of everyone here to be devoting time and thought to helping others, for free. Its not everyday that you get such helpful constructive responses from online an community or forums.