CSV file will not load into ArcGIS Online

Question

Hi-

New to GIS and taking a class this summer and created some waypoints.  Entered them into Excel and saved them into .csv format.  Tried loading into ArcGIS and nothing will load.

I typed in the lat and long just as it was displayed on my Garmin etrex.

Attached is the txt file i created from the csv file as Google will not let me upload .csv file extensions.

Thanks!

Mike

GPS-275 Coordinates.txt.zip

AkshayHarshe_0-1779199898532.png

JanetHatfield · Answer

Mike-
There are multiple converters available online.  Try simply Googling what it is you want to do, you will be surprised at the resources available to you.

I think I used this one...

http://transition.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html/

Good luck.

Janet

MikeMichalkiewicz · Answer

Mike-
In order for CSV files to work properly, the coordinates need to be in decimal degrees instead of degrees, decimal minutes and instead of using N and W use the minus sign for latitudes west of the Prime meridian, or south of the equator.

For Example: 
Your first coordinate
VCom1 N 39° 57.184' W 105° 01.311'

should read more like:

VCom1         39.953066     -105.02185

This should help.

Janhat-

Thanks a bunch..but how do I convrt to decimal degrees with the data i have?