Adding excel XY data to Arcmap

Question

I am having some issues with adding xy data from a .csv file. As you can see in the picture below the points are clustering. I am not sure if this is a excel format issue or a arcmap issue.

I am simply adding the .csv to arcmap> display xy data> no z field and coordinate system of: Geographic Coordinate System: Name: GCS_WGS_1984

enter image description here

enter image description here

• whyzar: Can you add a screen shot of your CSV file?
• artwork21: Can you include in your question how you are creating the point layer from .csv?
• Maksim: have you tried zooming in?
• Big T: Added the CSV file SS
• artwork21: How many records are in the excel sheet? What happens if you copy maybe 50% of the records into another excel sheet and try that one?

Answer 1

I am not seeing any decimal values greater than .59 nor .xx59 in your Excel spreadsheet. I think the spreadsheet has DD.MMmmm (degree-decimal minutes) or DD.MMSSssss (degree-minute-decimal seconds) values, not decimal degrees, DD.ddddddd. Take a look at the spreadsheet to see if you seen any .xxxx values that have>59 in the 3rd and 4th positions. If you can identify any, you have DD.MMmmmmm data.

ArcToolbox/Geoprocessing has a tool, Convert Coordinate Notation, which should be able to convert these values to decimal degrees before you attempt to add them as XY data.