Skip to main content
4 of 4
deleted 125 characters in body; edited title
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345

Importing XY coordinates to ArcMap?

I am very new to GIS.

I have a dataset in Excel containing XY coordinates of points. These coordinates are said to be in WSG84, but have different decimal places lengths. Longest of them have 9 decimal places. They have 3 digits before decimal points. So a 9 digit coordinate is XXX.YYY.ZZZ or a 6 digit one is XXX.YYY. I want them all to be in decimal coordinate system. Is there way that I can do this automatically in Excel?

When I try to convert the data to XY points, ArcMap disregards the decimals even though both the shape layer and the points layer are in WSG84 format. Thus, drawing the points to a totally unrelated space.

Example Coordinates from the dataset;

362.935.938 339.309.883
363.010.152 3.396.492
404.244.154 264.695.215
40.63   26.83
41.128.471  29.145.429
41.305.968  286.615.491
411.788.295 291.018.963
4.102.785   2.906.803
4.112.674   2.915.039
41.019  28.571
413.621.671 285.677.379
krypt
  • 23
  • 3