# 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
``````
• can you show some example points, please. Apr 6, 2016 at 12:59
• @AndreasMüller I've added some examples to the original post. Apr 6, 2016 at 16:50
• Wow, that looks quiet messy, i've no idea! But as you say Excel, sometimes Excel formats cells automatically to something completely different, often as a result of regional and language settings. Apr 6, 2016 at 18:16
• The values in ArcMap's table just show integer values, so the periods in Excel represent thousands and millions. It's more likely that each value should have a decimal delimiter inserted after 2 digits, thus leading to eastern European sightings. Apr 6, 2016 at 18:51
• It should, but I know that sometimes there are problems. Are the values in degrees or some projected coordinate system? That is, are the values: 37,206435 36,353921? Apr 6, 2016 at 19:54