I have a list of Excel lat long coordinates in a spreadsheet that I want to import as points in ArcMap by displaying the XY Data.
lat lon 5235746 486124 5236799 487447 5238042 489453 523686 486487 5236528 49301
However, ArcMap does not seem to recognise/display my coordinate data as points. I think because there are some 6-numbered coordinates in there as well. How should I tackle this problem?